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. ---------------------------(end of broadcast)--------------------------- TIP 4: Don't 'kill -9' the postmaster
