Home > mailing lists

Re: [GENERAL] pg_upgrade fails, "mismatch of relation OID" - 9.1.9 to 9.2.4 - Mailing list pgsql-hackers

From	Evan D. Hoffman
Subject	Re: [GENERAL] pg_upgrade fails, "mismatch of relation OID" - 9.1.9 to 9.2.4
Date	May 9, 2013 23:21:11
Msg-id	CABRB-LuuWWV3RedUeWBBPmJ0QB6obepiJ=k5aTpsv2nPBWJEsQ@mail.gmail.com Whole thread Raw
In response to	Re: [GENERAL] pg_upgrade fails, "mismatch of relation OID" - 9.1.9 to 9.2.4 (Bruce Momjian <bruce@momjian.us>)
Responses	Re: [GENERAL] pg_upgrade fails, "mismatch of relation OID" - 9.1.9 to 9.2.4 (Tom Lane <tgl@sss.pgh.pa.us>) Re: [GENERAL] pg_upgrade fails, "mismatch of relation OID" - 9.1.9 to 9.2.4 (Bruce Momjian <bruce@momjian.us>)
List	pgsql-hackers

Looks like your guess was correct:

[ehoffman@dev-db2 ~]$ psql -Upostgres db -p 5433

psql (9.2.4)

Type "help" for help.

db=# SELECT oid, relname, reltoastrelid, reltoastidxid FROM pg_class

db-# WHERE reltoastrelid = 299749;

oid | relname | reltoastrelid | reltoastidxid

-------+-----------+---------------+---------------

17304 | setupinfo | 299749 | 0

(1 row)

db=# \q

[ehoffman@dev-db2 ~]$ psql -Upostgres db -p 5432

psql (9.2.4, server 9.1.9)

WARNING: psql version 9.2, server version 9.1.

Some psql features might not work.

Type "help" for help.

db=# SELECT oid, relname, reltoastrelid, reltoastidxid FROM pg_class

db-# WHERE oid = 17304;

oid | relname | reltoastrelid | reltoastidxid

-------+-----------+---------------+---------------

17304 | setupinfo | 0 | 0

(1 row)

db=#

On Thu, May 9, 2013 at 4:15 PM, Bruce Momjian <bruce@momjian.us> wrote:

SELECT oid, relname, reltoastrelid, reltoastidxid FROM pg_class
WHERE oid =

From: Bruce Momjian
Date: 09 May 2013, 23:15:45
Subject: Re: [GENERAL] pg_upgrade fails, "mismatch of relation OID" - 9.1.9 to 9.2.4

From: Tom Lane
Date: 09 May 2013, 23:24:41
Subject: Re: [GENERAL] pg_upgrade fails, "mismatch of relation OID" - 9.1.9 to 9.2.4