From: | "J(dot) Cassidy" <sean(at)jdcassidy(dot)eu> |
---|---|
To: | "Adrian Klaver" <adrian(dot)klaver(at)aklaver(dot)com> |
Cc: | pgsql-general(at)postgresql(dot)org |
Subject: | Re: pg_dump fundenental question |
Date: | 2016-07-05 17:10:05 |
Message-ID: | b66dd37b8e52b7610017d1c8ff85d807.webmail@mx1bln1.prossl.de |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
Hello Adrian,
appreciate the prompt reply, thank you.
As
stated in the original email, I want to know whether compression (whatever level)
is on by default (or not) - if I supply NO extra switches/options.
I
have read the documentation and it is unclear in this respect. I am a Mainframer
and perhaps have a different world view on how to explain things...
TIA
and regards,
Henk.
On 07/05/2016 07:54 AM,
J. Cassidy wrote:
> Hello all,
>
> I have hopefully an
"easy" question.
>
> If I issue the pg_dump command with
no switches or options i.e.
>
> /usr/local/pgsql/bin/pg_dump -v
dbabcd > /data3TB/Backup/dbabcd
>
> Is their any
"default" compression involved or not? Does pg_dump talk to
>
zlib during the dump process given that I have not specified any
>
compression on the
> command line? (see above).
>
> Your
considered opinions would be much appreciated.
https://www.postgresql.org/docs/9.5/static/app-pgdump.html
"
-F format
--format=format
Selects the format of the output.
format can be one of the following:
p
plain
Output a
plain-text SQL script file (the default).
"
......
In line tag:
"-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.
<* SEE HERE 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. SEE HERE *> The
tar archive format currently
does not support compression at all.
"
>
>
> Regards,
>
>
> Henk
>
--
Adrian Klaver
adrian(dot)klaver(at)aklaver(dot)com
J
From | Date | Subject | |
---|---|---|---|
Next Message | Tom Lane | 2016-07-05 17:11:17 | Re: 9.6 Beta 2 Performance Regression on Recursive CTE |
Previous Message | Rob Sargent | 2016-07-05 17:03:42 | Re: pg_dump fundenental question |