Re: db recovery (FATAL 2)

Поиск
Список
Период
Сортировка
От Tom Lane
Тема Re: db recovery (FATAL 2)
Дата
Msg-id 3233.1020876360@sss.pgh.pa.us
обсуждение исходный текст
Ответ на Re: db recovery (FATAL 2)  (Bojan Belovic <bbelovic@usa.net>)
Список pgsql-admin
Bojan Belovic <bbelovic@usa.net> writes:
> You are correct, it's 7.1.2 . However, the problem is not with disk space
> (there's several gigs available), but there could be a problem with a bad
> sector on one of the log files. If this is the case, and the log file is
> corrupted, is there any way of recovering, even with a certain data loss?

Hm.  It's complaining about a write, not a read, so there is no lost
data (yet), even if your theory is correct.  You might first try copying
the entire $PGDATA/pg_xlog directory somewhere else.

If nothing else avails, see contrib/pg_resetxlog.  But that should be
your last resort not first.

            regards, tom lane

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

Предыдущее
От: "Vilson farias"
Дата:
Сообщение: Re: Performance question related with temporary tables
Следующее
От: Tom Lane
Дата:
Сообщение: Re: Performance question related with temporary tables