On 01/21/2014 08:13 AM, Stefan Warten wrote:
> Ubuntu 12.04.2 LTS with packages from apt.postgresql.org repo.
> pg_upgradecluster is the one from postgresql-common=151.pgdg12.4+1.
Alright I see --method is there, just not in the man pages I was looking
at. Reading through the script I see it will not work for installations
with user created tablespaces. In the low hanging fruit category, is
that by any chance the case here?
Should not that be the case. log into the database rg_www and:
select * from pg_class where oid = 22046;
This should return the relation that pg_upgrade is having a problem
with. See below for details on the information returned:
http://www.postgresql.org/docs/9.2/interactive/catalog-pg-class.html
This might narrow down where the problem is.
>
>
> 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.
>>>
>>>
>>
>>
>
>
--
Adrian Klaver
adrian.klaver@gmail.com