From: | Marcos Cano <mcano(at)stsa(dot)info> |
---|---|
To: | pgsql-admin(at)postgresql(dot)org |
Subject: | pg_upgrade / postgis issue |
Date: | 2013-06-26 14:10:11 |
Message-ID: | 1372255811365-5761138.post@n5.nabble.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-admin |
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.
From | Date | Subject | |
---|---|---|---|
Next Message | Bruce Momjian | 2013-06-26 14:16:30 | Re: pg_upgrade / postgis issue |
Previous Message | Albe Laurenz | 2013-06-25 11:07:21 | Re: pg_xlogfile_name for PostgreSQL 8.0 |