Re: Data recovery!

Поиск
Список
Период
Сортировка
От Tom Lane
Тема Re: Data recovery!
Дата
Msg-id 20601.1074488427@sss.pgh.pa.us
обсуждение исходный текст
Ответ на Data recovery!  (avalon@dolphin-3.bg)
Список pgsql-general
avalon@dolphin-3.bg writes:
> Hallo. This is the log. This is postgresql 7.4.0.
> The problem appeared after few hang-ups because of phisical memory
> problem. Is there any way to recover the data?

Well, since the WAL log is clearly corrupt, you might as well do
pg_resetxlog.  Don't have a lot of faith in the validity of your
database afterwards though --- I'd suggest a dump and reload plus
as much manual cross-checking as you can think of.

            regards, tom lane

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

Предыдущее
От: Tom Lane
Дата:
Сообщение: Re: UNICODE-encoded database does not accept umlaut-characters.
Следующее
От: Tom Lane
Дата:
Сообщение: Re: when I create a table, postgresql creates a new type