Skip site navigation (1) Skip section navigation (2)

Re: pg_upgrade relation OID mismatches

From: Peter Eisentraut <peter_e(at)gmx(dot)net>
To: Bruce Momjian <bruce(at)momjian(dot)us>
Cc: pgsql-hackers <pgsql-hackers(at)postgresql(dot)org>
Subject: Re: pg_upgrade relation OID mismatches
Date: 2011-11-22 21:56:55
Message-ID: 1321999015.4882.6.camel@vanquo.pezone.net (view raw or flat)
Thread:
Lists: pgsql-hackers
On tis, 2011-11-22 at 15:42 -0500, Bruce Momjian wrote:
> Peter Eisentraut wrote:
> > I thought these were fixed a while ago, but I'm still seeing these when
> > upgrading from master to self (using testing script sent in a while
> > ago).   This is completely reproducible.  What's happening?
> > 
> > ...
> > Restoring user relation files
> >   /home/peter/devel/postgresql/git/postgresql/contrib/pg_upgra
> > Mismatch of relation OID in database "regression": old OID 16701, new OID 16689
> > Failure, exiting
> 
> Yes, I certainly thought they were all addressed.  What object is 16701
> in the old database?  Anything unusual about it?  This is saying the
> relation oid was not preserved.

It came in with the range types feature:

+ psql -d regression -x -c 'select * from pg_class where oid = 16701'
-[ RECORD 1 ]--+----------------
relname        | test_range_gist
relnamespace   | 2200
reltype        | 16703
reloftype      | 0
relowner       | 10
relam          | 0
relfilenode    | 16701
reltablespace  | 0
relpages       | 33
reltuples      | 6200
relallvisible  | 33
reltoastrelid  | 16704
reltoastidxid  | 0
relhasindex    | t
relisshared    | f
relpersistence | p
relkind        | r
relnatts       | 1
relchecks      | 0
relhasoids     | f
relhaspkey     | f
relhasrules    | f
relhastriggers | f
relhassubclass | f
relfrozenxid   | 1627
relacl         | 
reloptions     | 



In response to

Responses

pgsql-hackers by date

Next:From: ktm@rice.eduDate: 2011-11-22 21:58:06
Subject: Re: Optimize postgres protocol for fixed size arrays
Previous:From: Mikko TiihonenDate: 2011-11-22 21:47:22
Subject: Optimize postgres protocol for fixed size arrays

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group