| From: | Roger Niederland <roger(at)niederland(dot)com> |
|---|---|
| To: | pgsql-general(at)postgresql(dot)org |
| Subject: | pg_dump compress |
| Date: | 2011-09-23 06:00:10 |
| Message-ID: | 4E7C206A.1020402@niederland.com |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | 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
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Craig Ringer | 2011-09-23 06:26:51 | Re: 10GbE / iSCSI storage for postgresql. |
| Previous Message | pasman pasmański | 2011-09-23 04:34:52 | Re: how just install psql on windows? |