Re:

On Wed, 2002-09-11 at 08:20, Dave Page wrote:
>
>
> > -----Original Message-----
> > From: Oliver Elphick [mailto:olly(at)lfix(dot)co(dot)uk]
> > Sent: 11 September 2002 07:29
> > To: Tom Lane
> > Cc: Lamar Owen; Bruce Momjian; Philip Warner; Laurette
> > Cisneros; pgsql-hackers(at)postgresql(dot)org
> > Subject: Re: [HACKERS]
> >
> >
> > Let me reiterate. I got these problems dumping 7.2 data with 7.3's
> > pg_dumpall:
>
> I wonder how many people would do something more like:
>
> pg_dumpall > db.sql
> make install
> psql -e template1 < db.sql
>
> rather than manually installing pg_dumpall from 7.3 first?

I suppose that what people will do unless told otherwise, but the
introduction of schemas means that it is much better to use 7.3's dump,
otherwise, for example, all functions will be private rather than
public.

Perhaps a note should be added to INSTALL. At the moment it says:

2. To dump your database installation, type:

pg_dumpall > outputfile

...

Make sure that you use the "pg_dumpall" command from the version
you are currently running. 7.2's "pg_dumpall" should not be used
on older databases.

But now we should be telling people to use 7.3's pg_dumpall, at least
for 7.2 data. (How far back can it go?)

Make sure you use pg_dumpall from the new 7.3 software to dump
your data from 7.2. To do this, you must have the 7.2
postmaster running and run the 7.3 pg_dumpall by using its full
pathname. 7.2's pg_dumpall is unsuitable because of the
introduction of schemas in 7.3 which make it necessary to grant
public access to features that will, if created from a 7.2 dump,
be given access by their owner only.

(Have I got that right?)

--
Oliver Elphick Oliver(dot)Elphick(at)lfix(dot)co(dot)uk
Isle of Wight, UK
http://www.lfix.co.uk/oliver
GPG: 1024D/3E1D0C1C: CA12 09E0 E8D5 8870 5839 932A 614D 4C34 3E1D 0C1C
========================================
"I am crucified with Christ; nevertheless I live; yet
not I, but Christ liveth in me; and the life which I
now live in the flesh I live by the faith of the Son
of God, who loved me, and gave himself for me."
Galatians 2:20