From: MichaelDBA Vitale <michaeldba@sqlexec.com>
To: Ian Lawrence Barwick <barwick@gmail.com>
To: Scott Ribe <scott_ribe@elevated-dev.com>
Cc: Pgsql-admin <pgsql-admin@lists.postgresql.org>
Subject: Re: error I don't understand
Date: Wed, 27 Jul 2022 15:45:01 -0400 (EDT)
Message-ID: <742509973.2598765.1658951101637@email.ionos.com> (raw)
In-Reply-To: <CAB8KJ=jhhNv1JR8yJfqdTN2W3B1=YaJOg_+P6EHqUrzYW_5cHQ@mail.gmail.com>
References: <BACA8550-4F3D-41D0-A0E1-5BF307BCD648@elevated-dev.com>
<CAB8KJ=jhhNv1JR8yJfqdTN2W3B1=YaJOg_+P6EHqUrzYW_5cHQ@mail.gmail.com>
<!doctype html>
<html>
<head>
<meta charset="UTF-8">
</head>
<body>
<div>
I think if the linux user is defined as a system user, then you are OK. It's only when the user is not defined as a system user that these bad side-effects can happen.
</div>
<div class="default-style">
</div>
<div class="default-style">
When creating linux users that work with Postgres, do it like this:
</div>
<div class="default-style">
adduser -r myuser
</div>
<div class="default-style">
or
</div>
<div class="default-style">
useradd -m --system myuser
</div>
<div class="default-style">
</div>
<div class="default-style">
See "systemd RemoveIPC" section in
</div>
<div class="default-style">
<a href="https://www.postgresql.org/docs/current/kernel-resources.html">https://www.postgresql.org/doc...;
</div>
<div class="default-style">
</div>
<div class="default-style">
</div>
<div class="default-style">
Regards,
</div>
<div class="default-style">
Michael Vitale
</div>
<div class="default-style">
</div>
<blockquote type="cite">
<div>
On 07/27/2022 1:30 PM EDT Ian Lawrence Barwick <<a href="mailto:barwick@gmail.com">barwick@gmail.com</a>> wrote:
</div>
<div>
</div>
<div>
</div>
<div>
2022年7月28日(木) 0:35 Scott Ribe <<a href="mailto:scott_ribe@elevated-dev.com">scott_ribe@elevated-dev.com</a>>:
</div>
<div>
>
</div>
<blockquote type="cite">
<div>
could not open shared memory segment "/PostgreSQL.3631378696": No such file or directory
</div>
</blockquote>
<blockquote type="cite">
<div>
Context is in parallel workers. Does this just mean that I don't have enough shmem allocated for the PG config that I set up?
</div>
</blockquote>
<div>
If you are using a Systemd-enabled Linux, check that "RemoveIPC" is
</div>
<div>
set to "no".
</div>
<div>
</div>
<div>
See: <a href="https://wiki.postgresql.org/wiki/Systemd"; target="_blank" rel="noopener">https://wiki.postgresql.org/wiki/Systemd</a;
</div>
<div>
</div>
<div>
Regards
</div>
<div>
</div>
<div>
Ian Barwick
</div>
<div>
</div>
<div>
</div>
<blockquote type="cite">
<div>
--
</div>
<div>
Scott Ribe
</div>
<div>
<a href="mailto:scott_ribe@elevated-dev.com">scott_ribe@elevated-dev.com</a>
</div>
<div>
<a href="https://www.linkedin.com/in/scottribe/"; target="_blank" rel="noopener">https://www.linkedin.com/in/scottribe/</a;
</div>
</blockquote>
<div>
>
</div>
<div>
>
</div>
<div>
>
</div>
<div>
>
</div>
</blockquote>
</body>
</html>
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: michaeldba@sqlexec.com, barwick@gmail.com, scott_ribe@elevated-dev.com, pgsql-admin@lists.postgresql.org
Subject: Re: error I don't understand
In-Reply-To: <742509973.2598765.1658951101637@email.ionos.com>
* 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