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

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: "Evan D(dot) Hoffman" <evandhoffman(at)gmail(dot)com>
Cc: Igor Neyman <ineyman(at)perceptron(dot)com>, "pgsql-general(at)postgresql(dot)org" <pgsql-general(at)postgresql(dot)org>
Subject: Re: pg_upgrade fails, "mismatch of relation OID" - 9.1.9 to 9.2.4
Date: 2013-05-08 20:30:26
Message-ID: 15036.1368045026@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general pgsql-hackers

"Evan D. Hoffman" <evandhoffman(at)gmail(dot)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

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Igor Neyman 2013-05-08 20:31:51 Re: pg_upgrade fails, "mismatch of relation OID" - 9.1.9 to 9.2.4
Previous Message Jerry Sievers 2013-05-08 20:25:49 Re: Trigger function on Warm Standby

Browse pgsql-hackers by date

  From Date Subject
Next Message Igor Neyman 2013-05-08 20:31:51 Re: pg_upgrade fails, "mismatch of relation OID" - 9.1.9 to 9.2.4
Previous Message Evan D. Hoffman 2013-05-08 20:21:34 Re: pg_upgrade fails, "mismatch of relation OID" - 9.1.9 to 9.2.4