Re: pg_upgrade fails: "Mismatch of relation OID in database" - 9.2.4 to 9.3.2

From: Stefan Warten <stefan(dot)warten(at)researchgate(dot)net>
To: "pgsql-general(at)postgresql(dot)org" <pgsql-general(at)postgresql(dot)org>
Subject: Re: pg_upgrade fails: "Mismatch of relation OID in database" - 9.2.4 to 9.3.2
Date: 2014-01-21 16:13:55
Message-ID: 52DE9CC3.6040705@researchgate.net
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Ubuntu 12.04.2 LTS with packages from apt.postgresql.org repo.
pg_upgradecluster is the one from postgresql-common=151.pgdg12.4+1.

On 21.01.2014 16:36, Adrian Klaver wrote:
> On 01/21/2014 05:42 AM, Stefan Warten wrote:
>> I've tried to upgrade a large production database from 9.2.4 to 9.3.2
>> using pg_upgradecluster (using pg_upgrade method) and it fails with the
>> error below. Upgrade using dump/restore seems to work on a test system
>> but would require a too long downtime on the production system.
>>
>> # pg_upgradecluster --method=upgrade 9.2 main /data/postgresql/9.3/main
>> [...]
>> Removing support functions from new cluster ok
>> Copying user relation files
>> /data/postgresql/9.2/main/base/12034/7174572
>> Mismatch of relation OID in database "rg_www": old OID 22046, new OID 17671
>> Failure, exiting
>> Error: pg_upgrade run failed
>> [...]
>>
>> Any thoughts? How can this be fixed?
>
> Not sure, but it would help if you provided information on what
> distribution you are running and the version of said distribution. I ask
> because a quick search on pg_upgradecluster did not show the --method
> switch.
>
>>
>> Regards, SW.
>>
>>
>
>

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Jeff Janes 2014-01-21 17:04:03 Re: client_min_messages not suppressing messages in psql nor pgAdminIII
Previous Message Kevin Field 2014-01-21 15:57:34 client_min_messages not suppressing messages in psql nor pgAdminIII