Received: from malur.postgresql.org ([217.196.149.56]) by arkaria.postgresql.org with esmtp (Exim 4.80) (envelope-from ) id 1UrqWQ-0001Lk-TD for pgsql-admin@arkaria.postgresql.org; Wed, 26 Jun 2013 14:16:35 +0000 Received: from localhost ([127.0.0.1] helo=postgresql.org) by malur.postgresql.org with smtp (Exim 4.80) (envelope-from ) id 1UrqWQ-0007b5-AI for pgsql-admin@arkaria.postgresql.org; Wed, 26 Jun 2013 14:16:34 +0000 Received: from makus.postgresql.org ([2001:4800:7903:4::125]) by malur.postgresql.org with esmtp (Exim 4.80) (envelope-from ) id 1UrqWP-0007az-HY for pgsql-admin@postgresql.org; Wed, 26 Jun 2013 14:16:33 +0000 Received: from momjian.us ([72.94.173.45]) by makus.postgresql.org with esmtp (Exim 4.80) (envelope-from ) id 1UrqWM-0007Jr-VF for pgsql-admin@postgresql.org; Wed, 26 Jun 2013 14:16:32 +0000 Received: from bruce by momjian.us with local (Exim 4.72) (envelope-from ) id 1UrqWM-00039m-F5; Wed, 26 Jun 2013 10:16:30 -0400 Date: Wed, 26 Jun 2013 10:16:30 -0400 From: Bruce Momjian To: Marcos Cano Cc: pgsql-admin@postgresql.org Subject: Re: pg_upgrade / postgis issue Message-ID: <20130626141630.GB3329@momjian.us> References: <1372255811365-5761138.post@n5.nabble.com> MIME-Version: 1.0 Content-Type: text/plain; charset=us-ascii Content-Disposition: inline In-Reply-To: <1372255811365-5761138.post@n5.nabble.com> User-Agent: Mutt/1.5.20 (2009-06-14) X-Pg-Spam-Score: -0.5 (/) List-Archive: List-Help: List-ID: List-Owner: List-Post: List-Subscribe: List-Unsubscribe: X-Mailing-List: pgsql-admin Precedence: bulk Sender: pgsql-admin-owner@postgresql.org On Wed, Jun 26, 2013 at 07:10:11AM -0700, Marcos Cano wrote: > 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. I don't think postgis can go from 1 to 2 with pg_upgrade because I thought they changed their internal format, but I am not sure. There are various ways of getting help for postgis: http://postgis.net/support/ -- Bruce Momjian http://momjian.us EnterpriseDB http://enterprisedb.com + It's impossible for everything to be true. + -- Sent via pgsql-admin mailing list (pgsql-admin@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-admin