Re: pg_dump fundenental question

On Tue, Jul 5, 2016 at 10:54 AM, J. Cassidy <sean@jdcassidy.eu> 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).

​

​ In general the easiest way to answer the question of whether something (well, a text file at least) is compressed or not is to attempt to open it in a text editor - if you can read the contents​

 

​ its not compressed.

Reading the Description section at the following location provides the answer you seek - no, there is no compression by default.​

​https://www.postgresql.org/docs/9.5/static/app-pgdump.html

 

​David J.