Thread

1. pg_dumpall in post

   karthikeyan V <karthik@asianbourses.com> — 2001-05-21T07:09:37Z

   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
   
   
   
   

2. Re: pg_dumpall in post

   Tom Lane <tgl@sss.pgh.pa.us> — 2001-05-23T14:41:35Z

   "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