Re: pg_upgrade fails, "mismatch of relation OID" - 9.1.9 to 9.2.4 - Mailing list pgsql-general

From Tom Lane
Subject Re: pg_upgrade fails, "mismatch of relation OID" - 9.1.9 to 9.2.4
Date
Msg-id 15036.1368045026@sss.pgh.pa.us
Whole thread Raw
In response to Re: pg_upgrade fails, "mismatch of relation OID" - 9.1.9 to 9.2.4  ("Evan D. Hoffman" <evandhoffman@gmail.com>)
List pgsql-general
"Evan D. Hoffman" <evandhoffman@gmail.com> writes:
> (The file referenced in the error was
> /var/lib/pgsql/9.1/data/base/16406/3016054)

I'm not sure about how pg_upgrade manages its output, but it seems
entirely possible that that was the last file successfully transferred,
not the one the error occurred on.

> Looks like it IS the same OID every time, referencing an index.

What index exactly?  Anything different about that index (or its
table) from others in the database?

            regards, tom lane


pgsql-general by date:

Previous
From: Jerry Sievers
Date:
Subject: Re: Trigger function on Warm Standby
Next
From: Igor Neyman
Date:
Subject: Re: pg_upgrade fails, "mismatch of relation OID" - 9.1.9 to 9.2.4