Re: pg_upgrade 9.0->9.2 failure: Mismatch of relation OID in database

From: Christoph Berg <christoph(dot)berg(at)credativ(dot)de>
To: Bruce Momjian <bruce(at)momjian(dot)us>
Cc: PostgreSQL Bugs <pgsql-bugs(at)postgresql(dot)org>
Subject: Re: pg_upgrade 9.0->9.2 failure: Mismatch of relation OID in database
Date: 2013-10-04 08:23:22
Message-ID: 20131004082322.GA4232@msgid.credativ.de
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-bugs

Re: Bruce Momjian 2013-10-02 <20131002170628(dot)GC5960(at)momjian(dot)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

In response to

Browse pgsql-bugs by date

  From Date Subject
Next Message Mani Sarkar 2013-10-04 09:32:40 Re: BUG #8496: psqlODBC driver does not work well via Excel
Previous Message Pavel Stehule 2013-10-04 07:24:29 Re: BUG #8496: psqlODBC driver does not work well via Excel