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 you can upgrade postgis (see hard/soft upgrade), the upgrade postgres. By the way postgis is very easy to compil with ubuntu (use package system to get dependecies, then simply sudo ./autogen.sh, sudo ./configure, make , sudo make install) Cheers, Remi-C
2014-02-06 alexandros_e <alexandros...@gmail.com>: > 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/UsersWikiPostGIS21Ubuntu1304src. There > it > says that Postgis 2.1 could be used with PostgreSQL 9.1. This will give you > access to Postgis 2.1 features without reinstalling everything. > > Of course normally I would not upgrade if this is an 1-2 years project, > unless I 100% need Postgis 2.1 features not present in 1.5. > > > > > > -- > View this message in context: > http://postgresql.1045698.n5.nabble.com/Hard-upgrade-everything-tp5790801p5790811.html > Sent from the PostgreSQL - general mailing list archive at Nabble.com. > > > -- > Sent via pgsql-general mailing list (pgsql-general@postgresql.org) > To make changes to your subscription: > http://www.postgresql.org/mailpref/pgsql-general >
