Re: - Mailing list pgsql-hackers

On Wed, 2002-09-11 at 08:20, Dave Page wrote:
> 
> 
> > -----Original Message-----
> > From: Oliver Elphick [mailto:olly@lfix.co.uk] 
> > Sent: 11 September 2002 07:29
> > To: Tom Lane
> > Cc: Lamar Owen; Bruce Momjian; Philip Warner; Laurette 
> > Cisneros; pgsql-hackers@postgresql.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
surethat you use the "pg_dumpall" command from the version       you are currently running. 7.2's "pg_dumpall" should
notbe 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
havethe 7.2       postmaster running and run the 7.3 pg_dumpall by using its full       pathname.  7.2's pg_dumpall is
unsuitablebecause of the       introduction of schemas in 7.3 which make it necessary to grant       public access to
featuresthat will, if created from a 7.2 dump,       be given access by their owner only.       
 
(Have I got that right?)


-- 
Oliver Elphick                                Oliver.Elphick@lfix.co.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
livethin me; and the life which I      now live in the flesh I live by the faith of the Son      of God, who loved me,
andgave himself for me."                                               Galatians 2:20