Re: pg_dump fundenental question

From: Rob Sargent <robjsargent(at)gmail(dot)com>
To: pgsql-general(at)postgresql(dot)org
Subject: Re: pg_dump fundenental question
Date: 2016-07-05 17:03:42
Message-ID: 577BE86E.5020102@gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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(at)jdcassidy(dot)eu
> <mailto:sean(at)jdcassidy(dot)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.
>
I like the 'file' command, and now the MS is shipping bash, it should be
available to all.

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message J. Cassidy 2016-07-05 17:10:05 Re: pg_dump fundenental question
Previous Message David G. Johnston 2016-07-05 16:54:09 Re: pg_dump fundenental question