Re: AW: Modified pg_dump & new pg_restore need testing...

From: Philip Warner <pjw(at)rhyme(dot)com(dot)au>
To: Zeugswetter Andreas SB <ZeugswetterA(at)wien(dot)spardat(dot)at>, pgsql-hackers(at)postgreSQL(dot)org
Subject: Re: AW: Modified pg_dump & new pg_restore need testing...
Date: 2000-07-03 08:02:10
Message-ID: 3.0.5.32.20000703180210.022538f0@mail.rhyme.com.au
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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 |/

Browse pgsql-hackers by date

  From Date Subject
Next Message Zeugswetter Andreas SB 2000-07-03 08:18:19 AW: Modified pg_dump & new pg_restore need testing...
Previous Message Zeugswetter Andreas SB 2000-07-03 07:56:36 AW: Modified pg_dump & new pg_restore need testing...