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 [EMAIL PROTECTED] | (610) 359-1001 + If your life is a hard drive, | 13 Roberts Road + Christ can be your backup. | Newtown Square, Pennsylvania 19073 ---------------------------(end of broadcast)--------------------------- TIP 4: Don't 'kill -9' the postmaster