From: | Adrian Klaver <adrian(dot)klaver(at)gmail(dot)com> |
---|---|
To: | pgsql-general(at)postgresql(dot)org, depesz(at)depesz(dot)com |
Cc: | Roger Niederland <roger(at)niederland(dot)com> |
Subject: | Re: pg_dump compress |
Date: | 2011-09-23 13:58:10 |
Message-ID: | 201109230658.10797.adrian.klaver@gmail.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
On Friday, September 23, 2011 6:46:49 am hubert depesz lubaczewski wrote:
> On Thu, Sep 22, 2011 at 11:00:10PM -0700, 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
>
> please note that pg_dump --help shows:
> -Z, --compress=0-9 compression level for compressed formats
>
> hint: the part "for compressed formats" is critical.
The docs show:
http://www.postgresql.org/docs/9.1/interactive/app-pgdump.html
-Z 0..9
--compress=0..9
Specify the compression level to use. Zero means no compression. For the
custom archive format, this specifies compression of individual table-data
segments, and the default is to compress at a moderate level. For plain text
output, setting a nonzero compression level causes the entire output file to be
compressed, as though it had been fed through gzip; but the default is not to
compress. The tar archive format currently does not support compression at all.
>
> plain dump is not compressed, you'd have to use -Fc to get compression,
> but it's good to use anyway.
>
> Best regards,
>
> depesz
--
Adrian Klaver
adrian(dot)klaver(at)gmail(dot)com
From | Date | Subject | |
---|---|---|---|
Next Message | Adrian Klaver | 2011-09-23 14:01:29 | Re: pg_dump compress |
Previous Message | Adrian Klaver | 2011-09-23 13:56:23 | Re: pg_dump compress |