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

Adrian,

On 1/1/14, 12:26 PM, "Adrian Klaver" <adrian(dot)klaver(at)gmail(dot)com> 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(dot)klaver(at)gmail(dot)com