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