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.
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. "