Re: pg_upgrade fails, "mismatch of relation OID" - 9.1.9 to 9.2.4

> -----Original Message-----
> From: pgsql-general-owner(at)postgresql(dot)org [mailto:pgsql-general-
> owner(at)postgresql(dot)org] On Behalf Of Evan D. Hoffman
> Sent: Wednesday, May 08, 2013 2:27 PM
> To: Postgresql Mailing List
> Subject: [GENERAL] pg_upgrade fails, "mismatch of relation OID" - 9.1.9
> to 9.2.4
>
> I've tried several times to upgrade a test database (with real data,
> ~500 GB) from 9.1 to 9.2 using pg_upgrade and every time it fails with
> the same error. I've tried a few different options to pg_upgrade but
> always the same result. Nothing really useful has turned up in Google.
> Any thoughts? Complete output is below:
>
>
>
> Linking user relation files
> /var/lib/pgsql/9.1/data/base/16406/3016054
> Mismatch of relation OID in database "dbname": old OID 2938685, new OID
> 299721 Failure, exiting
>
>

Is it always the same file, same OIDs (old/new)?
If it's the same file, did you try to find out what relation it belongs to?

Igor Neyman