Pipe it into gzip:
pg_dump db_name|gzip>dbname.sql.gz
NickF
--------------------------------------------------------------------------
Nick Fankhauser nickf@ontko.com Phone 1.765.935.4283 Fax 1.765.962.9788
Ray Ontko & Co. Software Consulting Services http://www.ontko.com/
> -----Original Message-----
> From: pgsql-admin-owner@postgresql.org
> [mailto:pgsql-admin-owner@postgresql.org]On Behalf Of Fred Moyer
> Sent: Tuesday, March 19, 2002 4:39 PM
> To: pgsql-admin@postgresql.org
> Subject: [ADMIN] pg_dump max file size exceeded
>
>
> 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
>
>
> ---------------------------(end of broadcast)---------------------------
> TIP 2: you can get off all lists at once with the unregister command
> (send "unregister YourEmailAddressHere" to majordomo@postgresql.org)
>