Thread: pg_dumpall in post

pg_dumpall in post

From
"karthikeyan V"
Date:
Hi People

I'm planning to upgrade postgresql version 7.0 to 7.1. I tried backuping of=
 my databases using pg_dumpall > filename.dump. I'm getting the error as fo=
llows:

"failed sanity check, table user_details was not found
pg_dump failed on users, exiting"

I couldn't find solution for this problem any where. I need to know how to =
fix this problem. This has been dragging for  a month.=20
Any immediate solution will be appreciated.=20

Regards
karthi

Re: pg_dumpall in post

From
Tom Lane
Date:
"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