Re: [GENERAL] Hard upgrade (everything)

2014-02-25 Thread Frank Broniewski
Hi everybody, I just wanted to let you know my notes I took during the upgrade process from Postgresql 9.1 to 9.3 and Postgis 1.5 to 2.1. Maybe someone finds them useful. I'm running the cluster on FreeBSD 9.2 so all commands apply to FreeBSD of course, but it should be fairly easy to translate th

Re: [GENERAL] Hard upgrade (everything)

2014-02-12 Thread Bruce Momjian
On Thu, Feb 6, 2014 at 10:07:18AM +0100, Rémi Cura wrote: > On my private computer I upgraded first the postgres to 9.3, then upgraded > postgis. > Sadly according to http://trac.osgeo.org/postgis/wiki/ > UsersWikiPostgreSQLPostGIS , > postgis 1.5 is not compatible with postgres 9.3. > However POs

Re: [GENERAL] Hard upgrade (everything)

2014-02-06 Thread Rémi Cura
On my private computer I upgraded first the postgres to 9.3, then upgraded postgis. Sadly according to http://trac.osgeo.org/postgis/wiki/UsersWikiPostgreSQLPostGIS , postgis 1.5 is not compatible with postgres 9.3. However POstgis 2.1 is compatible with you current postgres option. So as suggested

Re: [GENERAL] Hard upgrade (everything)

2014-02-06 Thread alexandros_e
I would use normal pg_dump and pg_restore for the DBs and not utils/postgis_restore.pl. Also, AFTER I backup all databases and everything else, you could try to upgrade Postgis without upgrading PostgreSQL by buliding from source e.g. http://trac.osgeo.org/postgis/wiki/UsersWikiPostGIS21Ubuntu1304s

[GENERAL] Hard upgrade (everything)

2014-02-06 Thread Frank Broniewski
-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 Hi list, I've asked this question already on the PostGIS list, but I think it might get great answers here too. I'm running two database cluster with PostGIS 1.5 and PostgreSQL 9.1 on FreeBSD 9.2-RELEASE-p3 and apparently my PostGIS and PostgreSQL are