Search Postgresql Archives

Re: pg_dump compress

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



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


[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
[Index of Archives]     [Postgresql Jobs]     [Postgresql Admin]     [Postgresql Performance]     [Linux Clusters]     [PHP Home]     [PHP on Windows]     [Kernel Newbies]     [PHP Classes]     [PHP Books]     [PHP Databases]     [Postgresql & PHP]     [Yosemite]
  Powered by Linux