Date: Wed, 26 Jun 2013 07:10:11 -0700 (PDT)
From: Marcos Cano <mcano@stsa.info>
To: pgsql-admin@postgresql.org
Message-ID: <1372255811365-5761138.post@n5.nabble.com>
Subject: pg_upgrade / postgis issue
MIME-Version: 1.0
Content-Type: text/plain; charset=us-ascii
Content-Transfer-Encoding: 7bit
Precedence: bulk
Sender: pgsql-admin-owner@postgresql.org

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@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-admin