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?
_______________________________________________
postgis-users mailing list
postgis-users@postgis.refractions.net
http://postgis.refractions.net/mailman/listinfo/postgis-users
