Re: pg_dumpall in post

"karthikeyan V" <karthik(at)asianbourses(dot)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