Re: pg_dumpall in post - Mailing list pgsql-bugs

From Tom Lane
Subject Re: pg_dumpall in post
Date
Msg-id 14612.990628895@sss.pgh.pa.us
Whole thread Raw
In response to pg_dumpall in post  ("karthikeyan V" <karthik@asianbourses.com>)
List pgsql-bugs
"karthikeyan V" <karthik@asianbourses.com> writes:
> "failed sanity check, table user_details was not found
> pg_dump failed on users, exiting"

Probably, you deleted the pg_shadow entry for the user that owned this
table.  7.1's pg_dump is somewhat smarter about this sort of situation,
but in older versions it doesn't cope well.  Look in pg_class to see
what relowner the table has, and create a new user with matching sysid.
Or change the relowner to match the sysid of an existing user.

            regards, tom lane

pgsql-bugs by date:

Previous
From: Tom Lane
Date:
Subject: Re: Failing backend on plpgsql function
Next
From: Oleg Bartunov
Date:
Subject: rfd: multi-key GiST index problems