pg_dump compress - Mailing list pgsql-general

From Roger Niederland
Subject pg_dump compress
Date
Msg-id 4E7C206A.1020402@niederland.com
Whole thread Raw
Responses Re: pg_dump compress
Re: pg_dump compress
Re: pg_dump compress
Re: pg_dump compress
List pgsql-general
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

pgsql-general by date:

Previous
From: "Reuven M. Lerner"
Date:
Subject: Re: Speed of lo_unlink vs. DELETE on BYTEA
Next
From: hubert depesz lubaczewski
Date:
Subject: Re: pg_dump compress