pg_dumpall problem

Поиск
Список
Период
Сортировка
От pgsql-bugs@postgresql.org
Тема pg_dumpall problem
Дата
Msg-id 200105220323.f4M3Now73744@hub.org
обсуждение исходный текст
Список 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 по дате отправления:

Предыдущее
От: Tom Lane
Дата:
Сообщение: Re: psql dumps core when entering invalid backslash command
Следующее
От: Bruce Momjian
Дата:
Сообщение: Re: Comments on Database Broken