Re: pg_dump's over 2GB

Bryan White wrote:
> 
> I am thinking that
> instead I will need to pipe pg_dumps output into gzip thus avoiding the
> creation of a file of that size.
> 

sure, i do it all the time.  unfortunately, i've had it happen a few
times where even gzipping a database dump goes over 2GB, which is a real
PITA since i have to dump some tables individually.  generally, i do
something like 
	pg_dump database | gzip > database.pgz 
to dump the database and 
	gzip -dc database.pgz | psql database
to restore it.  i've always thought that compress should be an option
for pg_dump, but it's really not that much more work to just pipe the
input and output through gzip.

-- 

Jeff Hoffmann
PropertyKey.com