From: | Adrian Klaver <adrian(dot)klaver(at)gmail(dot)com> |
---|---|
To: | pgsql-general(at)postgresql(dot)org |
Cc: | Roger Niederland <roger(at)niederland(dot)com> |
Subject: | Re: pg_dump compress |
Date: | 2011-09-23 13:56:23 |
Message-ID: | 201109230656.24080.adrian.klaver@gmail.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
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.
Works here on a Linux machine. Maybe the gzip code is not installed in your
Windows install? By the way as concerns the -i option, from the docs:
http://www.postgresql.org/docs/9.1/interactive/app-pgdump.html
-i
--ignore-version
A deprecated option that is now ignored.
So ignore is ignored:)
>
> Roger
--
Adrian Klaver
adrian(dot)klaver(at)gmail(dot)com
From | Date | Subject | |
---|---|---|---|
Next Message | Adrian Klaver | 2011-09-23 13:58:10 | Re: pg_dump compress |
Previous Message | hubert depesz lubaczewski | 2011-09-23 13:46:49 | Re: pg_dump compress |