Re: Database corrupted

Поиск
Список
Период
Сортировка
От Tom Lane
Тема Re: Database corrupted
Дата
Msg-id 4079.1323118432@sss.pgh.pa.us
обсуждение исходный текст
Ответ на Re: Database corrupted  (Scott Marlowe <scott.marlowe@gmail.com>)
Ответы Re: Database corrupted  (Yann ROBIN <me.show@gmail.com>)
Re: Database corrupted  (Scott Marlowe <scott.marlowe@gmail.com>)
Список pgsql-admin
Scott Marlowe <scott.marlowe@gmail.com> writes:
> On Mon, Dec 5, 2011 at 1:18 PM, Yann ROBIN <me.show@gmail.com> wrote:
>> kill -9 of the writer process

> Are you sure you killed all the postgres backends before restarting
> the server?  If other backends are still running, with a dead
> postmaster, and you restart the server, instant corruption.

There are interlocks against that ... although if you were foolish
enough to manually remove postmaster.pid, you could defeat them :-(

            regards, tom lane

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

Предыдущее
От: "Kevin Grittner"
Дата:
Сообщение: Re: Database corrupted
Следующее
От: Yann ROBIN
Дата:
Сообщение: Re: Database corrupted