Re: db recovery (FATAL 2)

Поиск
Список
Период
Сортировка
От Tom Lane
Тема Re: db recovery (FATAL 2)
Дата
Msg-id 29774.1020837586@sss.pgh.pa.us
обсуждение исходный текст
Ответ на db recovery (FATAL 2)  (Bojan Belovic <bbelovic@usa.net>)
Список pgsql-admin
Bojan Belovic <bbelovic@usa.net> writes:
> FATAL 2:  write(logfile 10 seg 93 off 15474688) failed: Success

This would be what PG version?

Broad-jumping to conclusions, I'm going to guess (a) 7.1.0-7.1.2
and (b) you are out of disk space for the WAL logs.

If so, you'll need to free up 16MB or so to restart the postmaster,
and you'd be well advised to update to 7.1.3 before trying another
VACUUM.

            regards, tom lane

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

Предыдущее
От: "otisg"
Дата:
Сообщение: Re: Dying PostgreSQL backend
Следующее
От: "Rajesh Kumar Mallah."
Дата:
Сообщение: data loss due to improper handling of postmaster ....