Adrian, On 1/1/14, 12:26 PM, "Adrian Klaver" <adrian.klaver@xxxxxxxxx> wrote: >On 01/01/2014 09:08 AM, Reiser, John J. wrote: >> The --link argument doesn't work, either: >> > >> >> Consult the last few lines of "pg_upgrade_restore.log" for >> the probable cause of the failure. >> Failure, exiting >> bash-4.1$ tail -n 20 pg_upgrade_restore.log >> (1 row) >> >> CREATE TYPE "spheroid" ( >> INTERNALLENGTH = 65, >> INPUT = spheroid_in, >> OUTPUT = spheroid_out, >> ALIGNMENT = double, >> STORAGE = plain >> ); >> CREATE TYPE >> ALTER TYPE "public"."spheroid" OWNER TO "reiser"; >> ALTER TYPE >> SET search_path = "sde", pg_catalog; >> SET >> CREATE FUNCTION "st_envelope_in"(cstring) RETURNS st_envelope >> LANGUAGE "c" IMMUTABLE STRICT >> AS 'st_geometry', 'ST_ENVELOPE_In'; >> psql:pg_upgrade_dump_db.sql:371910: ERROR: duplicate key value violates >> unique constraint "pg_type_oid_index" >> DETAIL: Key (oid)=(1407909) already exists. >> >> Again, any help that you could provide would be greatly appreciated. > >So have you already installed the GIS stuff into the 9.2 cluster before >the upgrade? I have installed PostGIS 1.5.8 and the st_geometry.so file that ESRI requires into the 9.2 directory (/usr/pgsql-9.2/lib). pg_upgrade wouldn't proceed as far as it did without doing that. I received your other email and will try the upgrade again and compare the OIDs in new and old. I'll email the list again once I've done that. Thanks again for your help. >> John >> > > >-- >Adrian Klaver >adrian.klaver@xxxxxxxxx -- Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
