[postgis-users] PostGIS 2.0.0beta3
andy at squeakycode.net
Wed Mar 14 13:41:52 PDT 2012
On 3/14/2012 3:33 PM, Sandro Santilli wrote:
> On Wed, Mar 14, 2012 at 03:14:54PM -0500, Andy Colson wrote:
>> I have a PG 9.0 with Postgis 1.5. I tried to use pg_upgrade to PG
>> 9.1 and Postgis 2.0, but, as you can probably guess, it doesn't
> How did you try pg_upgrade to postgis-2.0 ?
> Doesn't pg_upgrade create a _new_ database and populates
> with a dump of the old ?
> | __/ | Delivering high quality PostGIS 2.0 !
> | / 2.0 | http://strk.keybit.net - http://vizzuality.com
> postgis-users mailing list
> postgis-users at postgis.refractions.net
I followed the pg_upgrade instructions.
1) run pg91/bin/inidb
2) install extensions (in this case postgis 2.0)
3) stop all versions of pg
4) run: pg91/bin/pg_upgrade (with paths to old and new)
It complained it could not load postgis-1.5 in the newdb, which is
correct, because I installed postgis-2.0.
I was trying to avoid backup/restore. But after reading the Postgis 2
docs, you have to anyway to get from 1.5 to 2... so pg_upgrade wont help
I'm now attempting backup pg 9.0 postgis 1.5, and restore it to my new
pg 9.1 postgis 2.0.
More information about the postgis-users