Re: duplicate OID issue when using pg_upgrade to move from 8.4 to 9.2 - Mailing list pgsql-general

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.klaver@gmail.com