[postgis-users] PostGIS 2.0.0beta3

[Andy Colson]

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
>> work.
>
> 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 ?
>
> --strk;
>
>    ,------o-.
>    |   __/  |    Delivering high quality PostGIS 2.0 !
>    |  / 2.0 |    http://strk.keybit.net - http://vizzuality.com
>    `-o------'
>
> _______________________________________________
> postgis-users mailing list
> postgis-users at postgis.refractions.net
> http://postgis.refractions.net/mailman/listinfo/postgis-users

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 
any.

I'm now attempting backup pg 9.0 postgis 1.5, and restore it to my new 
pg 9.1 postgis 2.0.

-Andy