<!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/docs/current/kernel-resources.html</a>
</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(at)gmail(dot)com">barwick(at)gmail(dot)com</a>> wrote:
</div>
<div>
</div>
<div>
</div>
<div>
2022年7月28日(木) 0:35 Scott Ribe <<a href="mailto:scott_ribe(at)elevated-dev(dot)com">scott_ribe(at)elevated-dev(dot)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(at)elevated-dev(dot)com">scott_ribe(at)elevated-dev(dot)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>