Re: pg_dumpall in post

"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