Re: Problems with pg_dump

Поиск
Список
Период
Сортировка
От Tom Lane
Тема Re: Problems with pg_dump
Дата
Msg-id 19712.1047327721@sss.pgh.pa.us
обсуждение исходный текст
Ответ на Re: Problems with pg_dump  ("Ben Ramsey" <ben@eureka-interactive.com>)
Ответы Re: Problems with pg_dump  ("Ben Ramsey" <ben@eureka-interactive.com>)
Список pgsql-general
"Ben Ramsey" <ben@eureka-interactive.com> writes:
> Well, now.  That can't be very good.  If this is the case, anyone have any
> ideas of how to retrieve this data, or am I just stuck for good and out
> hours of work trying to get this data for our clients?

With 11 out of 12 databases apparently corrupted, your odds seem bleak.

If you are really lucky, the failures all come from one isolated
problem, rather than suggesting massive misfeasance on the part of
your disk.  I'd bet on pg_shadow as the best candidate (though it
could maybe be pg_group or pg_database; there are no other shared
tables, hence no other prospect for a common-mode failure).  Can you
do "select * from pg_shadow" without errors?  How about pg_group and
pg_database?

            regards, tom lane

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

Предыдущее
От: Lonni J Friedman
Дата:
Сообщение: Re: [NOVICE] General Performance questions
Следующее
От: Hadley Willan
Дата:
Сообщение: Re: Is there any way to delete a column