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

From: Steve Singer <steve(at)ssinger(dot)info>
To: Bruce Momjian <bruce(at)momjian(dot)us>
Cc: "Evan D(dot) Hoffman" <evandhoffman(at)gmail(dot)com>, Andres Freund <andres(at)2ndquadrant(dot)com>, Alvaro Herrera <alvherre(at)2ndquadrant(dot)com>, Greg Stark <stark(at)mit(dot)edu>, Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>, Igor Neyman <ineyman(at)perceptron(dot)com>, PostgreSQL-development <pgsql-hackers(at)postgresql(dot)org>
Subject: Re: Re: [GENERAL] pg_upgrade fails, "mismatch of relation OID" - 9.1.9 to 9.2.4
Date: 2013-05-13 13:36:51
Message-ID: BLU0-SMTP92C937D23C1D145DB2F9E7DCA00@phx.gbl
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general pgsql-hackers

On 05/11/2013 04:58 PM, Bruce Momjian wrote:
> On Fri, May 10, 2013 at 08:03:38PM -0400, Bruce Momjian wrote:
>> OK, this verifies that the table had a lot of DDL churn. I have no idea
>> how to pursue this further because I am unsure how we are going to
>> replicate the operations performed on this table in the past, as you
>> mentioned much of this was before your time on the job.
>>
>> Evan, I suggest you force a toast table on the table by doing:
>>
>> ALTER TABLE bpm.setupinfo ADD COLUMN dummy TEXT;
>>
>> Then drop the column. That will create a toast table and will allow
>> pg_upgrade to succeed.
> FYI, I did test adding a TEXT column and altering a column to TEXT on
> Postgres 9.1, and both created a toast table. I am still have no clues
> about what would have caused the missing toast table.
>

I once saw a case where a varchar(x) column was changed to something
larger by manually updating the catalog with an UPDATE statement on
pg_attribute.atttypmod. Everything was fine until they tried pg_upgrade
which failed because the DDL to create the table from pg_dump with the
larger column creates a table that had a toast table but the original
table in the 8.3 cluster did not have a toast table.

Steve

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Ray Stell 2013-05-13 13:38:19 Re: In what situations do you use -U of initdb?
Previous Message Raghavendra 2013-05-13 11:57:47 Re: PAM implementation in PG 9.2.3

Browse pgsql-hackers by date

  From Date Subject
Next Message Jon Nelson 2013-05-13 13:45:41 Re: corrupt pages detected by enabling checksums
Previous Message Andres Freund 2013-05-13 13:32:48 Re: corrupt pages detected by enabling checksums