Received: from malur.postgresql.org ([217.196.149.56]) by arkaria.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.96) (envelope-from ) id 1vlcHO-001Qfb-2s for pgsql-general@arkaria.postgresql.org; Fri, 30 Jan 2026 00:22:30 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.96) (envelope-from ) id 1vlcHM-0028sh-38 for pgsql-general@arkaria.postgresql.org; Fri, 30 Jan 2026 00:22:29 +0000 Received: from makus.postgresql.org ([2001:4800:3e1:1::229]) by malur.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.96) (envelope-from ) id 1vlcHM-0028sY-22 for pgsql-general@lists.postgresql.org; Fri, 30 Jan 2026 00:22:29 +0000 Received: from mail-oi1-x233.google.com ([2607:f8b0:4864:20::233]) by makus.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_128_GCM_SHA256 (Exim 4.96) (envelope-from ) id 1vlcHL-0003Et-0T for pgsql-general@postgresql.org; Fri, 30 Jan 2026 00:22:28 +0000 Received: by mail-oi1-x233.google.com with SMTP id 5614622812f47-45c7a71ba20so696886b6e.2 for ; Thu, 29 Jan 2026 16:22:27 -0800 (PST) ARC-Seal: i=1; a=rsa-sha256; t=1769732546; cv=none; d=google.com; s=arc-20240605; b=gZhRX3SNYtgTpSgmhbrvYChKTmoCLMDg1EhctA5ZNdcOtsHrY4szPjhxXsrySp97nC YRP5DwV7Ly49aS/PtCiSQxnKYDDoGF5qbgDzzFzLtatmiKcE1HAplkZeYzNfXcpZkKlD aJOQrxlD4ey4a9MD4RwKlNt7YUlpr4fERyPoZ9WglaJa9J6z2By2s2ZLjbpjeGRkfhGQ RYAdAOWM9Y+KsmvQWS8S9Gd5riq1DU+hurz54MdqG1+/JPFa0EwCheDQcsNK/+4oMnEf jg+LKzR+NkAVbpX6aLadn9lf/y7Fym4JRYS+scJkV24zzFOZPjUA11bPpwTEOITUnWru NI0w== ARC-Message-Signature: i=1; a=rsa-sha256; c=relaxed/relaxed; d=google.com; s=arc-20240605; h=to:subject:message-id:date:from:in-reply-to:references:mime-version :dkim-signature; bh=moi8YMMi5HHIEPxYTeuev4nOdap4IwxvxojIxXN6Bkg=; fh=KNSq+t9BltSXFnT3Yof/aKGBtqxeA+bTALiYdvTslaY=; b=FJer0h0a6GGq6G7UUEJwmy9pTwl0666fpBH4EsW5EikJf86UozLfWeUOmmonVYD3Dq LCuU3zmbjq68D3wHeSzfEfTlOpXAkLJqN2WTIQLmnNY1L+z6t545+lhM0IafOi0qHNXB 5X1aHB/LayUgcnLoGKRIPEsc5wae207/OrgRfWRWpQq7M9KSXac0VMh0wQO9eS3ODzxj Lw3ukLi7/QOkrWt9vfXYaQWI1C0uJFIfY/B25SNoYdytIReWeNWTV8jc+ozV1EQWqNee JIC0Ng5GFF3FEkwaMxoqeArZoFpDQ4HAW+eGSCDWvtlL+EMi2vEV525USv9N+nM5Dd3l zoKQ==; darn=postgresql.org ARC-Authentication-Results: i=1; mx.google.com; arc=none DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=20230601; t=1769732546; x=1770337346; darn=postgresql.org; h=to:subject:message-id:date:from:in-reply-to:references:mime-version :from:to:cc:subject:date:message-id:reply-to; bh=moi8YMMi5HHIEPxYTeuev4nOdap4IwxvxojIxXN6Bkg=; b=WaIL8bFFdIXiyIacNRpzYB3ingMEL0/6oR1A6VOaxXaazgtWGLaiRuYfagUFIepJ/h jixD+ClghTc8VYwIZpqrdQ4dbrS+6xmUIGdZzfkrcEy6Xi83JwRcYJrq+/+lB/mtazHF s8Wgd1XuPV6wbxxvh3G1kBwkCBpd20hbLgcHIM213ypqlOVUXcWch/lW1PHAY6ZdkbVi I26XbjjQoG348/kkYSKLs+8rPRMwN7Hkdq4sefUwQgXTnsnpVYvNijqdtjHdxfn6TYXZ HSdtT5gQ0cVIzrneJsZ6q4Z1cJ5xywv7V7HOB2gBdqTxnDIJcXa9L0gNUiOhGdfadLws 0CqQ== X-Google-DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=1e100.net; s=20230601; t=1769732546; x=1770337346; h=to:subject:message-id:date:from:in-reply-to:references:mime-version :x-gm-gg:x-gm-message-state:from:to:cc:subject:date:message-id :reply-to; bh=moi8YMMi5HHIEPxYTeuev4nOdap4IwxvxojIxXN6Bkg=; b=wyVokENLaMVuprs29pdHznVe4sI30arkuRAjsPye5es005EXCmZoRz/9hbxLywnoCj Kse+2fdyOAw4SWJN9rb7ofV2VsWc+nsqOwfmdFgLGWRhB7WQ3CpaPBZjNetKO1zuRyCe w5TrbjaoxCqbDIaprzustF6ysJQl3SgKYxn6guB02sujvIv67qrC41ZX1D5hIIdL0LWa 4Lo9jP3XKxgh8iT2cswJm7R5qGcsW9CYVX5e6pWfxEXNokaIdApUICK4pP8KCTclAYCt wQqCLMagpNYzDfsfJtrIRYLY0XCsDeDyMLXGDSjUyvrEDlRTPK4Pql9tdOCciMXb1ezH duHQ== X-Gm-Message-State: AOJu0YyOgItOHH/hosY2Y2Jl/ly+S5Vdn5lVqny5W89cY4msvMZLD+ph jMPpm5idFuFVYKaC0AJ89gKyf+4RwusTN+7BxFBmMLXO0RhMl6UEW9u21uJJcXYAXo6iXwgRd6Y +/mK7F9MVin7voQjnXt13jqzTYMVx6QVKRA== X-Gm-Gg: AZuq6aK7Rd1s7n09aT3TdlI1cWUpMbytw2Ntn9fC0YuSwF9/jhyxicTBBB9wCreBKy4 Bf9s/GkmIomIlo8Ob6suD8eT+L7FDP3kHCOLm2RO/amHyudii4SuMl10LWty/1uZ4XzHuGqFHHX TPhAMAbtb6jF6Khm0tIcZ8sri0fwrt5lMAc608BCZQ+og/LvQ/crs01SpSxzejusSNmugqX0rlh xos5u2iX42qGlPp8e/lV5fl85JvbORS+cZHq9QCAjuub7X/1OGY6WDuGEgQIoH7+IrBBi7B+2OA QVC37UI= X-Received: by 2002:a05:6808:30a5:b0:450:cb93:69ef with SMTP id 5614622812f47-45f34d41631mr692521b6e.56.1769732546116; Thu, 29 Jan 2026 16:22:26 -0800 (PST) MIME-Version: 1.0 References: In-Reply-To: From: Ron Johnson Date: Thu, 29 Jan 2026 19:22:15 -0500 X-Gm-Features: AZwV_QhyZdsyfLDy1OhpqeuqfXuClHFCeQM0kdlMO6EVhYBJ5XrKmmuyrC2A52U Message-ID: Subject: Re: What happens if the socket lock file is deleted? To: pgsql-general Content-Type: multipart/alternative; boundary="000000000000c2429e06498ff7de" List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk --000000000000c2429e06498ff7de Content-Type: text/plain; charset="UTF-8" Content-Transfer-Encoding: quoted-printable On Thu, Jan 29, 2026 at 3:30=E2=80=AFPM stevej@stevej.name wrote: > In software I have developed separately, I have noticed that most systems > will periodically delete files within the temporary directory hierarchy > that have not been accessed recently, and that includes lock files for lo= ng > running processes. I have never noticed the lock file associated with a > postgreSQL socket be missing though. That's interesting, and more than a bit scary. /tmp gets erased at boot, but I've never seen such a thing in RHEL. --=20 Death to , and butter sauce. Don't boil me, I'm still alive. lobster! --000000000000c2429e06498ff7de Content-Type: text/html; charset="UTF-8" Content-Transfer-Encoding: quoted-printable
On Thu, Jan 29, 2026 at 3:30=E2=80=AFPM <= a href=3D"mailto:stevej@stevej.name">stevej@stevej.name <stevej@stevej.name> wrote:
In software I have developed separately, I have noticed that= most systems will periodically delete files within the temporary directory= hierarchy that have not been accessed recently, and that includes lock fil= es for long running processes. I have never noticed the lock file associate= d with a postgreSQL socket be missing though.

That's interesting, and more than a bit scary.=C2=A0 /tmp gets erase= d at boot, but I've never seen such a thing in RHEL.
--
Death to <Redacted>, an= d butter sauce.
Don't boil me, I'm still alive.
&l= t;Redacted> lobster!
--000000000000c2429e06498ff7de--