[postgis-users] When To Upgrade

Michael Fuhr mike at fuhr.org
Sun Mar 5 09:50:37 PST 2006

On Sun, Mar 05, 2006 at 06:18:41PM +0200, Devrim GUNDUZ wrote:
> On Sun, 2006-03-05 at 08:08 -0800, Paul Ramsey wrote:
> > * DO NOT dump and restore for PostgreSQL upgrades of 0.0.1 (8.0.1 to  
> > 8.0.2).
> This may not be %100 true. AFAIR on a minor release on 7.4.X or 8.0.X (I
> can't remember right now), on-disk format was changed, so everyone
> needed to dump/reload the data.

Versions 7.4.2, 7.4.8, and 8.0.3 had system catalog changes that
could be fixed by dump/initdb/restore, but the Release Notes provided
intructions on how to manually update the system catalogs without
the need for dump/restore.  I'd agree that statements like the above
should be qualified with "unless the PostgreSQL Release Notes state

Michael Fuhr

More information about the postgis-users mailing list