Re: postgres under linux can't start because of postmaster.pid

Поиск
Список
Период
Сортировка
От Tom Lane
Тема Re: postgres under linux can't start because of postmaster.pid
Дата
Msg-id 15453.1193323178@sss.pgh.pa.us
обсуждение исходный текст
Ответ на Re: postgres under linux can't start because of postmaster.pid  ("Richard Wang" <ruc_wang@hotmail.com>)
Список pgsql-hackers
"Richard Wang" <ruc_wang@hotmail.com> writes:
> I just consider this may happens and pg can't recover correctly:
> if postgres crashed last time and left a postmaster.pid file, and last 
> postgres
> id is reused by another process which is not postgres now.

Postgres defends itself against that just fine, at least in any
reasonably recent release.  There are some corner cases where it
could have problems, but scripted hacking on the .pid file is just
about guaranteed to make things worse not better.
        regards, tom lane


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

Предыдущее
От: Tom Lane
Дата:
Сообщение: Re: order by in cursor declaration does not allow update
Следующее
От: Tom Lane
Дата:
Сообщение: Re: MaxOffsetNumber versus MaxHeapTuplesPerPage