pg_dumpall problem

From: pgsql-bugs(at)postgresql(dot)org
To: pgsql-bugs(at)postgresql(dot)org
Subject: pg_dumpall problem
Date: 2001-05-22 03:23:50
Message-ID: 200105220323.f4M3Now73744@hub.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-bugs

Karthikeyan V (karthik(at)asianbourses(dot)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 using pg_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 migrated from PostGreSql 6.5 to 7.0. We had the table user_details but it had been deleted. I would like to know how to get around this problem. It would be better, if you could look into this matter immediately and give me the solution. I can see 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

Browse pgsql-bugs by date

  From Date Subject
Next Message Bruce Momjian 2001-05-22 11:35:41 Re: psql dumps core when entering invalid backslash command
Previous Message Tom Lane 2001-05-21 19:33:37 Re: psql dumps core when entering invalid backslash command