

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

Regards, Dave.

Wed, 11 Sep 2002 08:20:22 +0100
"Dave Page" <dpage@vale-housing.co.uk>
Re: 
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 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.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 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 


11 Sep 2002 18:07:46 +0100
Oliver Elphick <olly@lfix.co.uk>
Re: 
Oliver Elphick wrote:
> 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.

That's a pretty big hurtle.  I think we are better off giving them an
SQL UPDATE to run.

-- 
  Bruce Momjian                        |  http://candle.pha.pa.us
  pgman@candle.pha.pa.us               |  (610) 359-1001
  +  If your life is a hard drive,     |  13 Roberts Road
  +  Christ can be your backup.        |  Newtown Square, Pennsylvania 19073

Wed, 11 Sep 2002 13:20:45 -0400 (EDT)
Bruce Momjian <pgman@candle.pha.pa.us>
Re: 