From: | Roger Niederland <roger(at)niederland(dot)com> |
---|---|
To: | depesz(at)depesz(dot)com |
Cc: | pgsql-general(at)postgresql(dot)org |
Subject: | Re: pg_dump compress |
Date: | 2011-09-23 14:26:19 |
Message-ID: | 4E7C970B.2080402@niederland.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
On 9/23/2011 6:46 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.
>
> plain dump is not compressed, you'd have to use -Fc to get compression,
> but it's good to use anyway.
>
> Best regards,
>
> depesz
>
On previous versions the -Z 9 option would compress the plain text sql
output to a gzipped file.
Now it now longer compresses. Using the -Fc the outputs a compressed
file, which is only readable
by pg_restore.
Roger
From | Date | Subject | |
---|---|---|---|
Next Message | Adrian Klaver | 2011-09-23 14:34:35 | Re: pg_dump compress |
Previous Message | hamann.w | 2011-09-23 14:02:46 | Re: looking for a faster way to do that |