Re: pg_dump 2GB limit?

Christopher Kings-Lynne <chriskl@familyhealth.com.au>

From: Christopher Kings-Lynne <chriskl@familyhealth.com.au>

To: Doug McNaught <doug@wireboard.com>

Cc: Laurette Cisneros <laurette@nextbus.com>, <pgsql-hackers@postgresql.org>

Date: 2002-03-29T04:18:05Z

Lists: pgsql-hackers

> > File size limit exceeded (core dumped)
> >
> > We suspect pg_dump.  Is this true?  Why would there be this limit in
> > pg_dump?  Is it scheduled to be fixed?

Try piping the output of pg_dump through bzip2 before writing it to disk.
Or else, I think that pg_dump has -z or something parameters for turning
on compression.

Chris