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.
When creating linux users that work with Postgres, do it like this:
adduser -r myuser
or
useradd -m --system myuser
See "systemd RemoveIPC" section in
Regards,
Michael Vitale
>
could not open shared memory segment "/PostgreSQL.3631378696": No such file or directory
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?
If you are using a Systemd-enabled Linux, check that "RemoveIPC" is
set to "no".
Regards
Ian Barwick
--
Scott Ribe
>
>
>
>