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. >> >> > > -- Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
