so my problem is that i have pg8.3 + postgis 1.3.x and i want to upgrade both of em to pg9.2.4 + postgis 2.0.4. so i've installed pg9.2.4 with postgis 2.0.4 and the server is running in a different port (5433) so both servers are up and running (not a big deal). when i try to pg_upgrade it gives me an error that pg_upgrade was expecting that some libraries provided by postgis extensions were installed so did a bit of research and i was missing this two "commands" from the postgis installation guide: CREATE EXTENSION postgis; CREATE EXTENSION postgis_topology; so everything went "well" after that, my pg_upgrade was able to advance a little more, but suddenly it gives me this error New cluster database "postgres" is not empty Failure, exiting obviously i went to psql and saw that the database "postgres" was not empty and was filled with 3 relations : Schema | Name | Type | Owner ----------+-----------------+-------+---------- public | spatial_ref_sys | table | postgres topology | layer | table | postgres topology | topology | table | postgres that were added by the 2 psql commands i just mention (that installed the extensions i was missing from the past) so im stuck here and i really need help or if someone could tell where to contact the postgis people. -- View this message in context: http://postgresql.1045698.n5.nabble.com/pg-upgrade-postgis-issue-tp5761138.html Sent from the PostgreSQL - admin mailing list archive at Nabble.com. -- Sent via pgsql-admin mailing list (pgsql-admin@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-admin
