pg_dumpall in post
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 follows:
"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.
Any immediate solution will be appreciated.
Regards
karthi
"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