Re: duplicate OID issue when using pg_upgrade to move from 8.4 to 9.2

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?

> John
>

--
Adrian Klaver
adrian(dot)klaver(at)gmail(dot)com