At 13:53 30/06/00 -0300, The Hermit Hacker wrote:
>
>Sounds like something that is a suitable replacement for what we have now
>... I particularly like the 'compressed output' *but* is there some way,
>for the paranoid, of doing an uncompressed format
>(--dont-compress?)?  Then again, how does this handle someone wanting to
>dump the database for reloading into a non-PgSQL database?  
>

As suggested I have now added a '--plain-text, -p' option to pg_dump to
dump it into text. Needless to say the output can not be used by pg_restore
(although, I suppose, it is feasible). This also supports the -Z flag, to
dump in gzip format.






----------------------------------------------------------------
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   |/

Sat, 01 Jul 2000 23:10:33 +1000
Philip Warner <pjw@rhyme.com.au>
Re: Modified pg_dump & new pg_restore need testing...
[ Charset ISO-8859-1 unsupported, converting... ]
> Philip Warner writes:
> 
> > As suggested I have now added a '--plain-text, -p' option to pg_dump
> > to dump it into text.
> 
> The *default* action of pg_dump should be to write plain text and to
> standard output. Changing that will certainly make a lot of people very
> unhappy.

Agreed.  We need a enable-compress switch.

-- 
  Bruce Momjian                        |  http://www.op.net/~candle
  pgman@candle.pha.pa.us               |  (610) 853-3000
  +  If your life is a hard drive,     |  830 Blythe Avenue
  +  Christ can be your backup.        |  Drexel Hill, Pennsylvania 19026

Sat, 1 Jul 2000 17:15:39 -0400 (EDT)
Bruce Momjian <pgman@candle.pha.pa.us>
Re: Modified pg_dump & new pg_restore need testing...
Philip Warner writes:

> As suggested I have now added a '--plain-text, -p' option to pg_dump
> to dump it into text.

The *default* action of pg_dump should be to write plain text and to
standard output. Changing that will certainly make a lot of people very
unhappy.


-- 
Peter Eisentraut                  Sernanders vï¿½g 10:115
peter_e@gmx.net                   75262 Uppsala
http://yi.org/peter-e/            Sweden


Sat, 1 Jul 2000 23:23:53 +0200 (CEST)
Peter Eisentraut <peter_e@gmx.net>
Re: Modified pg_dump & new pg_restore need testing...
At 23:23 1/07/00 +0200, Peter Eisentraut wrote:
>> As suggested I have now added a '--plain-text, -p' option to pg_dump
>> to dump it into text.
>
>The *default* action of pg_dump should be to write plain text and to
>standard output. Changing that will certainly make a lot of people very
>unhappy.

Good point; I'll make it the default. The -Z {0..9] switch and -F {p|c|f}
switches can be used to select output compression levels and output format.


----------------------------------------------------------------
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   |/

Sun, 02 Jul 2000 11:34:26 +1000
Philip Warner <pjw@rhyme.com.au>
Re: Modified pg_dump & new pg_restore need testing...