Re: AW: Modified pg_dump & new pg_restore need testing... - Mailing list pgsql-hackers

From Philip Warner
Subject Re: AW: Modified pg_dump & new pg_restore need testing...
Date
Msg-id 3.0.5.32.20000703180210.022538f0@mail.rhyme.com.au
Whole thread Raw
List pgsql-hackers
At 09:56 3/07/00 +0200, Zeugswetter Andreas SB wrote:
>
>> - the default output file format is a custom format with compressed
>> sections (the data dumps). It is NOT a text file.
>
>Can this be turned off, or made to be feature, that you can turn on ? 
>Imho most dumps will be piped to a locally 
>optimized compressor (a tape, a storage manager, lzop, ...) anyway, 
>thus most of the time a backup would compress twice.

Yes. The default is now plain text for compatibility with the original
pg_dump (and with pg_dumpall). But by going to plain text output you gain
none of the features of pg_restore (reordering, selection etc).

----------------------------------------------------------------
Philip Warner                    |     __---_____
Albatross Consulting Pty. Ltd.   |----/       -  \
(A.C.N. 008 659 498)             |          /(@)   ______---_
Tel: (+61) 0500 83 82 81         |                 _________  \
Fax: (+61) 0500 83 82 82         |                 ___________ |
Http://www.rhyme.com.au          |                /           \|                                |    --________--
PGP key available upon request,  |  /
and from pgp5.ai.mit.edu:11371   |/


pgsql-hackers by date:

Previous
From: Zeugswetter Andreas SB
Date:
Subject: AW: Modified pg_dump & new pg_restore need testing...
Next
From: Zeugswetter Andreas SB
Date:
Subject: AW: Modified pg_dump & new pg_restore need testing...