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@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
_______________________________________________
postgis-users mailing list
postgis-users@postgis.refractions.net
http://postgis.refractions.net/mailman/listinfo/postgis-users
