From: | Adrian Klaver <adrian(dot)klaver(at)gmail(dot)com> |
---|---|
To: | Stefan Warten <stefan(dot)warten(at)researchgate(dot)net>, 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 15:36:46 |
Message-ID: | 52DE940E.9060206@gmail.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
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.
>
>
--
Adrian Klaver
adrian(dot)klaver(at)gmail(dot)com
From | Date | Subject | |
---|---|---|---|
Next Message | Kevin Field | 2014-01-21 15:57:34 | client_min_messages not suppressing messages in psql nor pgAdminIII |
Previous Message | Postgres Question | 2014-01-21 14:26:12 | UDP Overflow / UDP Drops on Standby Postgres Service |