> -----Original Message----- > From: pgsql-general-ow...@postgresql.org [mailto:pgsql-general- > ow...@postgresql.org] On Behalf Of Evan D. Hoffman > Sent: Wednesday, May 08, 2013 2:27 PM > To: Postgresql Mailing List > Subject: [GENERAL] pg_upgrade fails, "mismatch of relation OID" - 9.1.9 > to 9.2.4 > > I've tried several times to upgrade a test database (with real data, > ~500 GB) from 9.1 to 9.2 using pg_upgrade and every time it fails with > the same error. I've tried a few different options to pg_upgrade but > always the same result. Nothing really useful has turned up in Google. > Any thoughts? Complete output is below: > > > > Linking user relation files > /var/lib/pgsql/9.1/data/base/16406/3016054 > Mismatch of relation OID in database "dbname": old OID 2938685, new OID > 299721 Failure, exiting > >
Is it always the same file, same OIDs (old/new)? If it's the same file, did you try to find out what relation it belongs to? Igor Neyman -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
