On Friday, September 23, 2011 7:26:19 am Roger Niederland wrote: > On 9/23/2011 6:46 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. > > > > plain dump is not compressed, you'd have to use -Fc to get compression, > > but it's good to use anyway. > > > > Best regards, > > > > depesz > > On previous versions the -Z 9 option would compress the plain text sql > output to a gzipped file. > Now it now longer compresses. Using the -Fc the outputs a compressed > file, which is only readable > by pg_restore. Seems there has been a code change in pg_dump.c that ignores compression level for plain text. >From line 537: /* * Ignore compression level for plain format. XXX: This is a bit * inconsistent, tar-format throws an error instead. */ The documentation has not caught up with this change. > > Roger -- 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
