On Tue, 2002-03-19 at 16:39, Fred Moyer wrote:
> hey fellow pg'ers.
>
> ran time pg_dump -c --verbose database > datafile.psql from the command line
> and got a file size limit exceeded. datafile.psql stopped at 2 gigs. any
> ideas how to exceed that limit?
>
> redhat 7.2, 2.4.9-31 kernel
> postgres 7.2
Hello Fred
Are you trying to dump over NFS? NFS has a 2G file size limit and AFAIK
there is no simple way to get around it.
Howver, you could compress you dump on the fly:
pg_dump -c --verbose database |gzip -c >datafile.psql.gz
or
pg_dump -c --verbose database | bzip2 -c >datafile.psql.bz2
(for better compression)
restoring:
zcat datafile.psql.gz | psql database
or
bzcat datafile.psql.gz | psql database
Cheers,
--Jyry
C:-( C:-/ C========8-O C8-/ C:-(
Kansainvälisten kisojen tulosteksteissä käytetään
kilpailijoiden nimiin äänestoainetta.
