> -----Original Message-----
> From: Evan D. Hoffman [mailto:evandhoffman@gmail.com]
> Sent: Wednesday, May 08, 2013 3:35 PM
> To: Igor Neyman
> Subject: Re: [GENERAL] pg_upgrade fails, "mismatch of relation OID" -
> 9.1.9 to 9.2.4
>
> Looks like it IS the same OID every time, referencing an index. I
> already reindexed the entire DB in case it was some problem with a
> corrupt index. Here's the index info, if it's of any use.
>
>
> Interestingly, if I query which that relation's in, it's not the one
> that it complained about:
>
> db=# select pg_relation_filepath(2938685); pg_relation_filepath
> ----------------------
> base/16407/21446253
> (1 row)
>
> db=#
>
> (The file referenced in the error was
> /var/lib/pgsql/9.1/data/base/16406/3016054)
>
> On Wed, May 8, 2013 at 2:35 PM, Igor Neyman <ineyman@perceptron.com>
> wrote:
> >
> >> -----Original Message-----
> >> From: pgsql-general-owner@postgresql.org [mailto:pgsql-general-
> >> owner@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
> >>
> >>
> >> 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
> >
Is it the same file though?
And, if it is what do you get when you run:
Select relname from pg_class where relfilenode = 3016054::oid;
Please, reply to the list ("reply to all"), so that other people who may have better ideas/solutions for could see it.
Igor Neyman
