Thread: pg_dump: oldie but goldie

pg_dump: oldie but goldie

From
Kovacs Zoltan
Date:
Philip, the last element of the chain has caused a big problem for me
changing from 7.0.2 to 7.1beta4: dumping the database out and putting
back.

As you might not know, at my place getting the data from the database is
not a simple pg_dump, but the data come through complex filter programs
(awk scripts and others). And loading the data back is also contains
several scripts transforming the modified dump. So I am in a terrible need
to have the same output in 7.1beta4 as in 7.0.2. I used pg_dump
with -acnD and -acnd switches in 7.0.2.

The old binary of pg_dump could not be used due to the changed database
internals... :-(

Is there any (maybe undocumented) switches satisfying my needs?

TIA, Zoltan
--                         Kov\'acs, Zolt\'an                        kovacsz@pc10.radnoti-szeged.sulinet.hu
          http://www.math.u-szeged.hu/~kovzol                        ftp://pc10.radnoti-szeged.sulinet.hu/home/kovacsz
 




Re: pg_dump: oldie but goldie

From
Philip Warner
Date:
At 23:39 7/02/01 +0100, Kovacs Zoltan wrote:
>So I am in a terrible need
>to have the same output in 7.1beta4 as in 7.0.2. I used pg_dump
>with -acnD and -acnd switches in 7.0.2.
>
>The old binary of pg_dump could not be used due to the changed database
>internals... :-(
>
>Is there any (maybe undocumented) switches satisfying my needs?
>

I don't think so. Due to changes in PG, it is simply not possible to dump
in the same format as 7.0.2. Are there any specific differences that you
would like to see?


----------------------------------------------------------------
Philip Warner                    |     __---_____
Albatross Consulting Pty. Ltd.   |----/       -  \
(A.B.N. 75 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   |/