Re: pg_upgrade / postgis issue

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



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  <bruce@xxxxxxxxxx>        http://momjian.us
  EnterpriseDB                             http://enterprisedb.com

  + It's impossible for everything to be true. +


-- 
Sent via pgsql-admin mailing list (pgsql-admin@xxxxxxxxxxxxxx)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-admin




[Index of Archives]     [KVM ARM]     [KVM ia64]     [KVM ppc]     [Virtualization Tools]     [Spice Development]     [Libvirt]     [Libvirt Users]     [Linux USB Devel]     [Linux Audio Users]     [Yosemite Questions]     [Linux Kernel]     [Linux SCSI]     [XFree86]

  Powered by Linux