From: Tom Lane <tgl@sss.pgh.pa.us>
To: Adrian Klaver <adrian.klaver@aklaver.com>
cc: "stevej@stevej.name" <stevej@stevej.name>,
        pgsql-general@lists.postgresql.org
Subject: Re: What happens if the socket lock file is deleted?
In-reply-to: <dfe95e1a-6d6d-4ba1-8cfa-6636c60538d4@aklaver.com>
References: <FA028C3B-70E0-4185-B581-72EDC1FB6847@stevej.name> <dfe95e1a-6d6d-4ba1-8cfa-6636c60538d4@aklaver.com>
Comments: In-reply-to Adrian Klaver <adrian.klaver@aklaver.com>
	message dated "Thu, 29 Jan 2026 12:40:06 -0800"
MIME-Version: 1.0
Content-Type: text/plain; charset="us-ascii"
Content-ID: <1363738.1769721879.1@sss.pgh.pa.us>
Content-Transfer-Encoding: quoted-printable
Date: Thu, 29 Jan 2026 16:24:39 -0500
Message-ID: <1363739.1769721879@sss.pgh.pa.us>
Archived-At: <https://www.postgresql.org/message-id/1363739.1769721879%40sss.pgh.pa.us>
Precedence: bulk

Adrian Klaver <adrian.klaver@aklaver.com> writes:
>  From here at ~line 1781:

> https://github.com/postgres/postgres/blob/master/src/backend/postmaster/=
postmaster.c

>         /*
>          * Once a minute, verify that postmaster.pid hasn't been removed=
 or
>          * overwritten.  If it has, we force a shutdown.

Actually, Steve was asking about socket lock files, so the relevant
code fragment is the bit just below that:

        /*
         * Touch Unix socket and lock files every 58 minutes, to ensure th=
at
         * they are not removed by overzealous /tmp-cleaning tasks.  We as=
sume
         * no one runs cleaners with cutoff times of less than an hour ...
         */
        if (now - last_touch_time >=3D 58 * SECS_PER_MINUTE)
        {
            TouchSocketFiles();
            TouchSocketLockFiles();
            last_touch_time =3D now;
        }

			regards, tom lane