Re: pg_dumpall in post

Поиск
Список
Период
Сортировка
От Tom Lane
Тема Re: pg_dumpall in post
Дата
Msg-id 14612.990628895@sss.pgh.pa.us
обсуждение исходный текст
Ответ на pg_dumpall in post  ("karthikeyan V" <karthik@asianbourses.com>)
Список pgsql-bugs
"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

В списке pgsql-bugs по дате отправления:

Предыдущее
От: Tom Lane
Дата:
Сообщение: Re: Failing backend on plpgsql function
Следующее
От: Oleg Bartunov
Дата:
Сообщение: rfd: multi-key GiST index problems