Re: [GENERAL] dealing with file size when archiving databases

2005-06-21 Thread Vivek Khera
On Jun 20, 2005, at 10:28 PM, Andrew L. Gould wrote: compressed database backups is greater than 1GB; and the results of a gzipped pg_dumpall is approximately 3.5GB. The processes for creating the iso image and burning the image to DVD-R finish without any problems; but the resulting file is u

Re: [GENERAL] dealing with file size when archiving databases

2005-06-20 Thread Tino Wildenhain
Am Montag, den 20.06.2005, 21:28 -0500 schrieb Andrew L. Gould: > I've been backing up my databases by piping pg_dump into gzip and > burning the resulting files to a DVD-R. Unfortunately, FreeBSD has > problems dealing with very large files (>1GB?) on DVD media. One of my > compressed databas

Re: [GENERAL] dealing with file size when archiving databases

2005-06-20 Thread Andrew L. Gould
On Monday 20 June 2005 10:14 pm, Alvaro Herrera wrote: > On Mon, Jun 20, 2005 at 09:28:51PM -0500, Andrew L. Gould wrote: > > I've been backing up my databases by piping pg_dump into gzip and > > burning the resulting files to a DVD-R. Unfortunately, FreeBSD has > > problems dealing with very larg

Re: [GENERAL] dealing with file size when archiving databases

2005-06-20 Thread Andrew L. Gould
On Monday 20 June 2005 09:53 pm, Tom Lane wrote: > "Andrew L. Gould" <[EMAIL PROTECTED]> writes: > > I've been backing up my databases by piping pg_dump into gzip and > > burning the resulting files to a DVD-R. Unfortunately, FreeBSD has > > problems dealing with very large files (>1GB?) on DVD me

Re: [GENERAL] dealing with file size when archiving databases

2005-06-20 Thread Alvaro Herrera
On Mon, Jun 20, 2005 at 09:28:51PM -0500, Andrew L. Gould wrote: > I've been backing up my databases by piping pg_dump into gzip and > burning the resulting files to a DVD-R. Unfortunately, FreeBSD has > problems dealing with very large files (>1GB?) on DVD media. One of my > compressed databa

Re: [GENERAL] dealing with file size when archiving databases

2005-06-20 Thread Tom Lane
"Andrew L. Gould" <[EMAIL PROTECTED]> writes: > I've been backing up my databases by piping pg_dump into gzip and > burning the resulting files to a DVD-R. Unfortunately, FreeBSD has > problems dealing with very large files (>1GB?) on DVD media. One of my > compressed database backups is great

[GENERAL] dealing with file size when archiving databases

2005-06-20 Thread Andrew L. Gould
I've been backing up my databases by piping pg_dump into gzip and burning the resulting files to a DVD-R. Unfortunately, FreeBSD has problems dealing with very large files (>1GB?) on DVD media. One of my compressed database backups is greater than 1GB; and the results of a gzipped pg_dumpall