[postgis-devel] Parallel installations

strk at refractions.net strk at refractions.net
Wed Dec 21 00:38:51 PST 2005

On Wed, Dec 21, 2005 at 03:34:32AM +0200, alex bodnaru wrote:
> hi strk,
> sorry if i find it too hard to understand. the scenario is:
> user has postgis-1.0.x installed and working.
> user upgrades to postgis-1.1.x (library and sql).
> user wishes to go back to 1.0.x version, by reinstalling previous library.
> i'm afraid the solution is: dump the database, create a new
> postgis-1.0.x database, and load the dumped data as non dba.
> please just confirm.

I confirm this is the safest way.

Still, an alternative would be producing an lwpostgis_upgrade.sql
script using postgis_proc_upgrade.pl and lwpostgis.sql shipped
with 1.0.x and sourcing it against the downgrading databases.
That should make all 1.0.x functionalities available, but eventual
*new* functionalities of 1.1 untouched, thus possibly pointing
to an uninstalled library (1.1).


More information about the postgis-devel mailing list