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