pg_dumpall problem - Mailing list pgsql-bugs

From pgsql-bugs@postgresql.org
Subject pg_dumpall problem
Date
Msg-id 200105220323.f4M3Now73744@hub.org
Whole thread Raw
List pgsql-bugs
Karthikeyan V (karthik@asianbourses.com) reports a bug with a severity of 2
The lower the number the more severe it is.

Short Description
pg_dumpall problem

Long Description
I'm using tar version of PostgreSql 7.0. I'm planning to move to PostgreSql 7.1 and I wanted to backup the databases
usingpg_dumpall.  
But when I run the command pg_dumpall > filename . I get the following error:

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

I checked for the table user_details in the database but there was no such table in that name. The entire database was
migratedfrom PostGreSql 6.5 to 7.0. We had the table user_details but it had been deleted. I would like to know how to
getaround this problem. It would be better, if you could look into this matter immediately and give me the solution. I
cansee from the mailing list many people having this problem. 

Note:
----
I tried creating the table user_details in the database space still the error is coming up.

Looking forward your reply

Regards
Karthikeyan V

Sample Code


No file was uploaded with this report

pgsql-bugs by date:

Previous
From: Tom Lane
Date:
Subject: Re: psql dumps core when entering invalid backslash command
Next
From: Bruce Momjian
Date:
Subject: Re: Comments on Database Broken