Re: pg_dump max file size exceeded

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.