Re: pg_dump max file size exceeded

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)
>