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. Roger |