Re: [HACKERS] postmaster crash and .s.pgsql file

Поиск
Список
Период
Сортировка
От James Hughes
Тема Re: [HACKERS] postmaster crash and .s.pgsql file
Дата
Msg-id Pine.LNX.3.93.980127060456.24792A-100000@xport.bluewall.com
обсуждение исходный текст
Ответ на Re: [HACKERS] postmaster crash and .s.pgsql file  (Goran Thyni <goran@bildbasen.se>)
Ответы Re: [HACKERS] postmaster crash and .s.pgsql file  (Goran Thyni <goran@bildbasen.se>)
Re: [HACKERS] postmaster crash and .s.pgsql file  (The Hermit Hacker <scrappy@hub.org>)
Список pgsql-hackers

On 27 Jan 1998, Goran Thyni wrote:

:
:    On Mon, 26 Jan 1998, Bruce Momjian wrote:
:
:    :
:    : When the postmaster crashes, it leaves the /tmp/.s.pgsql file in /tmp.
:    : Is there a way to auto-remove it after a postmaster crash?
:    :

<snip>

:    I will look at removing the file on startup when I'm in there.
:
: Don't, it gets removed at shutdown except when crashing.
: Removing at startup opens a whole new can of worms.
: (You must no postmaster is not already running.)
:

How about in postmaster.c (arround line 427), when starting up...

    1.) Check for the existence of a pid file.

    2.) If one is there, read the pid and see if a back end is alive.

    3.) If so, warn the user and exit.

    4.) If not, check for and cleanup any leftover files.

    5.) Continue with startup process.

        ...wouldn't this work OK?



-James


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

Предыдущее
От: Zeugswetter Andreas DBT
Дата:
Сообщение: No: implied sort with group by
Следующее
От: Bruce Momjian
Дата:
Сообщение: Re: [HACKERS] postmaster crash and .s.pgsql file