From: raf <raf@raf.org>
To: pgsql-admin@lists.postgresql.org
Subject: Re: error I don't understand
Date: Thu, 28 Jul 2022 19:26:24 +1000
Message-ID: <YuJWQBcdr51/DVgT@raf.org> (raw)
In-Reply-To: <3222447.1658978804@sss.pgh.pa.us>
References: <BACA8550-4F3D-41D0-A0E1-5BF307BCD648@elevated-dev.com>
<CAB8KJ=jhhNv1JR8yJfqdTN2W3B1=YaJOg_+P6EHqUrzYW_5cHQ@mail.gmail.com>
<54A636CB-DD71-4B4E-A6E6-1CE146454C0E@elevated-dev.com>
<3222447.1658978804@sss.pgh.pa.us>
On Wed, Jul 27, 2022 at 11:26:44PM -0400, Tom Lane <tgl@sss.pgh.pa.us> wrote:
> Scott Ribe <scott_ribe@elevated-dev.com> writes:
> > On Jul 27, 2022, at 11:30 AM, Ian Lawrence Barwick <barwick@gmail.com> wrote:
> >> If you are using a Systemd-enabled Linux, check that "RemoveIPC" is
> >> set to "no".
>
> > That was the answer. I checked other servers, they had it set. But they are much older OSs (overdue for updates, RSN), different installers.
>
> I looked at this on my own machines and was interested to find that
> RHEL8 defaults it to "no", although the upstream default is evidently
> "yes" and Fedora follows that. Not sure what to make of that,
> except that OS-vendor opinion isn't universal that this is a great
> idea.
>
> regards, tom lane
It is not a great idea. On Debian, I had a postgres user cronjob,
and occasionally, systemd in its infinite wisdom would decide
that the end of the cronjob meant that the postgres user had
logged out and needed to have its IPC resources deleted, even
though the IPC resources in question were created by a different
long-running postgres user "session" that was still running
(i.e., the database server). The consequence was error messages
from the database claiming that the database was corrupt. Very
scary. It wasn't corrupt. It just needed systemd to stop deleting
its stuff.
cheers,
raf
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-admin@postgresql.org
Cc: raf@raf.org, pgsql-admin@lists.postgresql.org
Subject: Re: error I don't understand
In-Reply-To: <YuJWQBcdr51/DVgT@raf.org>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox