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.klaver@xxxxxxxxx -- Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
