Search Postgresql Archives

Re: pg_upgrade fails, "mismatch of relation OID" - 9.1.9 to 9.2.4

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 




> -----Original Message-----
> From: Evan D. Hoffman [mailto:evandhoffman@xxxxxxxxx]
> Sent: Wednesday, May 08, 2013 4:22 PM
> To: Igor Neyman
> Cc: pgsql-general@xxxxxxxxxxxxxx
> Subject: Re:  pg_upgrade fails, "mismatch of relation OID" -
> 9.1.9 to 9.2.4
> 
> Well, each time it fails it refers to the file
> "/var/lib/pgsql/9.1/data/base/16406/3016054", but that's not the file
> associated with OID 2938685.
> 
> Here's the output of that query:
> 
> db=# Select relname from pg_class where relfilenode = 3016054::oid;
> relname
> ---------
> (0 rows)
> 
> db=#
> 
> 

And that is before running pg_upgrade, right?

Seems like some kind of pg_catalog corruption.
I guess, Bruce Momjian would know better, what's going on here.

Igor Neyman


-- 
Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general





[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
[Index of Archives]     [Postgresql Jobs]     [Postgresql Admin]     [Postgresql Performance]     [Linux Clusters]     [PHP Home]     [PHP on Windows]     [Kernel Newbies]     [PHP Classes]     [PHP Books]     [PHP Databases]     [Postgresql & PHP]     [Yosemite]
  Powered by Linux