Re: pg_upgrade 9.0->9.2 failure: Mismatch of relation OID in database - Mailing list pgsql-bugs

From Christoph Berg
Subject Re: pg_upgrade 9.0->9.2 failure: Mismatch of relation OID in database
Date
Msg-id 20131004082322.GA4232@msgid.credativ.de
Whole thread Raw
In response to Re: pg_upgrade 9.0->9.2 failure: Mismatch of relation OID in database  (Bruce Momjian <bruce@momjian.us>)
List pgsql-bugs
Re: Bruce Momjian 2013-10-02 <20131002170628.GC5960@momjian.us>
> That is very interesting, and it certainly should not be failing.
>
> I am surprised it got an oid that was one less than the desired one,
> 18803.  Is there any mention of 18803 in the SQL file?

18803 wasn't mentioned anywhere, just 18804 like the log says.

> If you create a
> cluster with just your schema and no data, can you upgrade that cleanly?

I haven't tried that yet. This is on a customer machine we don't have
access to except when arranging a remote desktop session. I'll see if
I can do some tests there.

Mit freundlichen Grüßen,
Christoph Berg
--
Tel.: +49 (0)21 61 / 46 43-187
credativ GmbH, HRB Mönchengladbach 12080, USt-ID-Nummer: DE204566209
Hohenzollernstr. 133, 41061 Mönchengladbach
Geschäftsführung: Dr. Michael Meskes, Jörg Folz, Sascha Heuer

pgsql-bugs by date:

Previous
From: Pavel Stehule
Date:
Subject: Re: BUG #8496: psqlODBC driver does not work well via Excel
Next
From: Alvaro Herrera
Date:
Subject: Re: BUG #8434: Why does dead lock occur many times ?