Re: reindexdb program error under PG 8.1.3 - Mailing list pgsql-general

From Tom Lane
Subject Re: reindexdb program error under PG 8.1.3
Date
Msg-id 15444.1148587608@sss.pgh.pa.us
Whole thread Raw
In response to reindexdb program error under PG 8.1.3  (David Wall <d.wall@computer.org>)
Responses Re: reindexdb program error under PG 8.1.3  (David Wall <d.wall@computer.org>)
List pgsql-general
David Wall <d.wall@computer.org> writes:
> When I create a brand new database and then run the reindexdb program
> under PG 8.1.3, I get the follow error:

> reindexdb: reindexing of database "xxxx" failed: ERROR:  could not open
> relation with OID 41675

> I'm not sure what this error is since we have not even added any data
> yet.  Is this something that's misconfigured in the template1 database
> (we have not customized it), something we're doing wrong, or is this
> "normal"?

I think you've done something to template1, even though you say you
haven't.  Out-of-the-box, an 8.1.3 database won't have any OIDs assigned
above about 11000, so OID 41675 would have to belong to a user-created
object.  Look in template1 and see if you see a table with that OID.

            regards, tom lane

pgsql-general by date:

Previous
From: David Wall
Date:
Subject: reindexdb program error under PG 8.1.3
Next
From: David Wall
Date:
Subject: Re: reindexdb program error under PG 8.1.3