Re: pg_dump fundenental question - Mailing list pgsql-general

From Rob Sargent
Subject Re: pg_dump fundenental question
Date
Msg-id 577BE86E.5020102@gmail.com
Whole thread Raw
In response to Re: pg_dump fundenental question  ("David G. Johnston" <david.g.johnston@gmail.com>)
Responses Re: pg_dump fundenental question
List pgsql-general


On 07/05/2016 10:54 AM, David G. Johnston wrote:
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.​


I like the 'file' command, and now the MS is shipping bash, it should be available to all.

pgsql-general by date:

Previous
From: "David G. Johnston"
Date:
Subject: Re: pg_dump fundenental question
Next
From: "J. Cassidy"
Date:
Subject: Re: pg_dump fundenental question