On Friday, September 23, 2011 6:46:49 am hubert depesz lubaczewski wrote:
> On Thu, Sep 22, 2011 at 11:00:10PM -0700, Roger Niederland wrote:
> > Using pg_dump from the command line with the exe included in windows
> > 32 bit install in postgresql 9.1.
> > pg_dump  -U username -f somefile.sql.gz -Z 9 -i dbname
> 
> please note that pg_dump --help shows:
>   -Z, --compress=0-9          compression level for compressed formats
> 
> hint: the part "for compressed formats" is critical.

The docs show:

http://www.postgresql.org/docs/9.1/interactive/app-pgdump.html

-Z 0..9
--compress=0..9

    Specify the compression level to use. Zero means no compression. For the 
custom archive format, this specifies compression of individual table-data 
segments, and the default is to compress at a moderate level. For plain text 
output, setting a nonzero compression level causes the entire output file to be 
compressed, as though it had been fed through gzip; but the default is not to 
compress. The tar archive format currently does not support compression at all. 

> 
> plain dump is not compressed, you'd have to use -Fc to get compression,
> but it's good to use anyway.
> 
> Best regards,
> 
> depesz

-- 
Adrian Klaver
adrian.kla...@gmail.com

-- 
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general

Reply via email to