Re: reindexdb program error under PG 8.1.3

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