On Thursday, September 22, 2011 11:00:10 pm 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 > > outputs a file that is in plain text. In previous versions of > postgresql, this output a gzipped file. > Also tried: pg_dump -U username -Z 9 -i dbname > somefile.sql.gz > got the same results. > > Tried to revert to a previous version of pg_dump from pgadmin 1.12. > The dump is aborted because of server version mismatch (server version > 9.1.0; pg_dump version: 9.0.1) > > Looked at the pg_dump documentation and it was not noted that the -Z > option changed. I set up a 9.1 installation on my Linux machine and can confirm that the 9.1 version of pg_dump does not compress plain text format dump files. > > 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
