Re: [HACKERS] postmaster crash and .s.pgsql file - Mailing list pgsql-hackers

From James Hughes
Subject Re: [HACKERS] postmaster crash and .s.pgsql file
Date
Msg-id Pine.LNX.3.93.980127060456.24792A-100000@xport.bluewall.com
Whole thread Raw
In response to Re: [HACKERS] postmaster crash and .s.pgsql file  (Goran Thyni <goran@bildbasen.se>)
Responses Re: [HACKERS] postmaster crash and .s.pgsql file
Re: [HACKERS] postmaster crash and .s.pgsql file
List 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 by date:

Previous
From: Zeugswetter Andreas DBT
Date:
Subject: No: implied sort with group by
Next
From: Bruce Momjian
Date:
Subject: Re: [HACKERS] postmaster crash and .s.pgsql file