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 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) Yes, that is the order I have head. You can upgrade postgis from 1.5 to 2.1 on the old server, then use pg_upgrade to upgrade Postgres. -- Bruce Momjian <bruce@xxxxxxxxxx> http://momjian.us EnterpriseDB http://enterprisedb.com + Everyone has their own god. + -- Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general