[postgis-users] Trouble upgrading to 2.0.1

Sandro Santilli strk at keybit.net
Fri Jul 20 10:30:44 PDT 2012


On Fri, Jul 20, 2012 at 11:13:35AM -0600, Hays Barrett wrote:
> Hello all. I am trying to upgrade to postgis-2.0.1.
> 
> I dumped my db with :
> pg_dump -Fc -b -v -f "/opt/dump/dump.sql" postgis
> 
> When I run "./postgis_restore.pl "/opt/dump/dump.sql" | psql -a postgis2" I
> get 2 errors.
> 
> ALTER SEQUENCE spatial_ref_sys_srid_seq OWNED BY spatial_ref_sys.srid;
> ERROR:  sequence must have same owner as table it is linked to
> SELECT pg_catalog.setval('spatial_ref_sys_srid_seq', 1, false);
> 
> 
> ALTER TABLE spatial_ref_sys ADD PRIMARY KEY(srid);
> ERROR:  could not create unique index "spatial_ref_sys_pkey"
> DETAIL:  Key (srid)=(4279) is duplicated.

This is really unexpected, I'm surprised it happens.
Did you install the spatial_ref_sys.sql in "postgis2" database
prior to sending the postgis_restore.pl output ?
Did you get any notice on stderr from postgis_restore.pl ?

--strk;

  ,------o-. 
  |   __/  |    Delivering high quality PostGIS 2.1
  |  / 2.1 |    http://strk.keybit.net - http://vizzuality.com
  `-o------'




More information about the postgis-users mailing list