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