Re: Relation 'pg_user' does not exist

Matt Beauregard <matt(at)designscape(dot)com(dot)au> writes:
>>>> NOTICE: mdopen: couldn't open pg_user: No such file or directory
>>
>> This is strange in itself. There should be an (empty) file named
>> pg_user in your $PGDATA/base/template1 directory --- is there?
>> What about pg_views?

> Neither are there.

Hmm. *Something's* been tromping on your database, then. Hard to tell
what happened from the information at hand ... but I'll bet the
corrupted index on pg_class is related somehow.

Since these are only views, the datafiles underlying them would be empty
anyway --- so you can recreate the datafiles just by doing
"touch $PGDATA/base/template1/pg_user" etc.

You could probably rebuild the corrupted index using REINDEX. I haven't
had to do that myself so I'm not sure about the procedure.

I'd definitely recommend a full dump, initdb, restore once you have
things working well enough to allow a dump. Whatever happened here,
you probably haven't seen all the effects yet :-(

regards, tom lane