From: | Bruce Momjian <bruce(at)momjian(dot)us> |
---|---|
To: | Marcos Cano <mcano(at)stsa(dot)info> |
Cc: | pgsql-admin(at)postgresql(dot)org |
Subject: | Re: pg_upgrade / postgis issue |
Date: | 2013-06-26 14:16:30 |
Message-ID: | 20130626141630.GB3329@momjian.us |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-admin |
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:
--
Bruce Momjian <bruce(at)momjian(dot)us> http://momjian.us
EnterpriseDB http://enterprisedb.com
+ It's impossible for everything to be true. +
From | Date | Subject | |
---|---|---|---|
Next Message | Azad Bolour | 2013-06-26 16:22:31 | can postgres btree indexes shrink? |
Previous Message | Marcos Cano | 2013-06-26 14:10:11 | pg_upgrade / postgis issue |