RE: [postgis-devel] About EXTENSION from UNPACKAGED on PostgreSQL 13
Regina Obe <lr@pcorp.us>
From: "Regina Obe" <lr@pcorp.us>
To: "'PostGIS Development Discussion'" <postgis-devel@lists.osgeo.org>
Cc: "'PostgreSQL Developers'" <pgsql-hackers@lists.postgresql.org>
Date: 2020-02-26T20:11:29Z
Lists: pgsql-hackers
> Presumably 15 years out from the 1.x -> 2.x we can stop worrying about > bundling unpackaged postgis into an extension, and just recommend a hard > upgrade dump/restore to the hardy souls still running 1.x. > > P. > We don't need to worry about 1.x cause 1.x can only do a hard upgrade to 2 or 3. We never supported soft upgrade from 1.x Easy solution there is just to install postgis extension and do pg_restore/postgis_restore of your data. So it's really just the 2.1 -> 3 that are of concern. I think now is a fine time to encourage everyone to upgrade to 3 if they can so they don't need to suffer any crazy solutions we come up with :) Turn this into a convenient emergency. Thanks, Regina