Re: Hard upgrade (everything) - Mailing list pgsql-general

From Bruce Momjian
Subject Re: Hard upgrade (everything)
Date
Msg-id 20140212175845.GC12558@momjian.us
Whole thread Raw
In response to Re: Hard upgrade (everything)  (Rémi Cura <remi.cura@gmail.com>)
Responses Re: Hard upgrade (everything)  (Frank Broniewski <brfr@metrico.lu>)
List pgsql-general
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@momjian.us>        http://momjian.us
  EnterpriseDB                             http://enterprisedb.com

  + Everyone has their own god. +


pgsql-general by date:

Previous
From: Adrian Klaver
Date:
Subject: Re: pg_restore issue
Next
From: Tom Lane
Date:
Subject: Re: pg_restore issue