Re: - Mailing list pgsql-hackers

From Bruce Momjian
Subject Re:
Date
Msg-id 200209111720.g8BHKju21401@candle.pha.pa.us
Whole thread Raw
In response to Re:  (Oliver Elphick <olly@lfix.co.uk>)
List pgsql-hackers
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,
Pennsylvania19073
 


pgsql-hackers by date:

Previous
From: Oliver Elphick
Date:
Subject: Re:
Next
From: Michael Meskes
Date:
Subject: Re: 7.3beta and ecpg