[postgis-users] Trouble upgrading to 2.0.1

[Hays Barrett]

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.

I looked at spatial_ref_sys and it is filled with dupes. Any ideas on what
I am doing wrong?
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.osgeo.org/pipermail/postgis-users/attachments/20120720/d6f45c45/attachment.html>