[postgis-users] Upgrading postGIS database from Postgresql 9.1.4 to 9.2

Jan Hartmann j.l.h.hartmann at uva.nl
Wed Nov 14 07:40:27 PST 2012


I've just installed from source the new PostgreSQL 9.2 distribution 
without a database. The old 9.1.4 version is running under a different 
port and uses PostGIS version 2.1.0SVN. I can't access that database 
with the 9.2 PostgreSQL binaries. There is a simple upgrade method 
(pg_upgrade), that copies the data directory from the old database to 
the new one, using the binaries from both distributions

http://excid3.com/blog/upgrade-postgres-9-1-to-9-2/
http://www.postgresql.org/docs/devel/static/pgupgrade.html

Before I start mucking things up, has anyone done this, and is it really 
as simple as this with a PostGIS (and PL/R) enabled database?

Jan
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.osgeo.org/pipermail/postgis-users/attachments/20121114/8246d2ec/attachment.html>


More information about the postgis-users mailing list