Re: pg_upgrade fails: Mismatch of relation OID in database 8.4 -> 9.3

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: Bruce Momjian <bruce(at)momjian(dot)us>
Cc: Jeff Ross <jeff(at)commandprompt(dot)com>, PostgreSQL Hackers <pgsql-hackers(at)postgresql(dot)org>
Subject: Re: pg_upgrade fails: Mismatch of relation OID in database 8.4 -> 9.3
Date: 2014-05-21 20:23:34
Message-ID: 2846.1400703814@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

Bruce Momjian <bruce(at)momjian(dot)us> writes:
> On Wed, May 21, 2014 at 10:56:59AM -0600, Jeff Ross wrote:
>> Yes, using 9.3's pg_dump of 8.4 and applying it to both an 8.4 and a
>> 9.3 cluster, the contact_email table now has toast in both 8.4 and
>> 9.3.

> So the big question is why doesn't the existing 8.4 table have a toast
> table? Did you use pg_upgrade on the old cluster before, e.g. from 8.3?

I have a vague recollection that we changed the calculations about whether
a toast table would be needed, but I can't find it in the commit logs
right now --- and anyway I think this was pre-8.4.

regards, tom lane

In response to

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message Bruce Momjian 2014-05-21 20:37:13 Re: pg_upgrade fails: Mismatch of relation OID in database 8.4 -> 9.3
Previous Message David G Johnston 2014-05-21 19:00:27 [9.3] Should we mention "set_config(...)" in 18.1.3 in Server Configuration?