[GENERAL] pg_upgrade fails: "Mismatch of relation OID in database" - 9.2.4 to 9.3.2

2014-01-21 Thread Stefan Warten
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 -

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

2014-01-21 Thread Stefan Warten
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