Re: pg_upgrade fails: Mismatch of relation OID in database 8.4 -> 9.3 - Mailing list pgsql-hackers

From Bruce Momjian
Subject Re: pg_upgrade fails: Mismatch of relation OID in database 8.4 -> 9.3
Date
Msg-id 20140521144943.GA14030@momjian.us
Whole thread Raw
In response to Re: pg_upgrade fails: Mismatch of relation OID in database 8.4 -> 9.3  (Bruce Momjian <bruce@momjian.us>)
List pgsql-hackers
On Tue, May 20, 2014 at 10:25:44PM -0400, Bruce Momjian wrote:
> Find the table that is getting the toast file on the new cluster but not
> the old one, and run all the commands related to that table from the
> dump --- you don't need to load any data, just the schema items.
> 
> Run that on the old cluster and the new cluster, then check if you are
> getting the same case where there is no toast table on the old cluster
> but one on the new cluster.  Remember to only use the 9.3 pg_dump output
> for both old and new clusters.

FYI, you might want to test this by using a different database in the old
cluster so you don't interfere with the existing data.

--  Bruce Momjian  <bruce@momjian.us>        http://momjian.us EnterpriseDB
http://enterprisedb.com
 + Everyone has their own god. +



pgsql-hackers by date:

Previous
From: Robert Haas
Date:
Subject: Re: BUGFIX: Dynamic bgworkers with BGW_NEVER_RESTART worker restarted on FatalError
Next
From: Andrew Dunstan
Date:
Subject: Re: buildfarm animals and 'snapshot too old'