Re: pg_dump fundenental question

Rob Sargent <robjsargent@xxxxxxxxx> · Tue, 5 Jul 2016 11:03:42 -0600



    On 07/05/2016 10:54 AM, David G.
      Johnston wrote:

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