Re: error I don't understand

[MichaelDBA Vitale <michaeldba@xxxxxxxxxxx>]

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 

https://www.postgresql.org/docs/current/kernel-resources.html

 

 

Regards,

Michael Vitale

 

On 07/27/2022 1:30 PM EDT Ian Lawrence Barwick <barwick@xxxxxxxxx> wrote:

 

 

2022年7月28日(木) 0:35 Scott Ribe <scott_ribe@xxxxxxxxxxxxxxxx>:

>

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".

 

See: https://wiki.postgresql.org/wiki/Systemd

 

Regards

 

Ian Barwick

 

 

--

Scott Ribe

scott_ribe@xxxxxxxxxxxxxxxx

https://www.linkedin.com/in/scottribe/

>

>

>

>