Received: from malur.postgresql.org ([217.196.149.56]) by arkaria.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.92) (envelope-from ) id 1oGmxx-0005FP-W7 for pgsql-admin@arkaria.postgresql.org; Wed, 27 Jul 2022 19:45:09 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.92) (envelope-from ) id 1oGmxw-00082K-OR for pgsql-admin@arkaria.postgresql.org; Wed, 27 Jul 2022 19:45:08 +0000 Received: from makus.postgresql.org ([2001:4800:3e1:1::229]) by malur.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.92) (envelope-from ) id 1oGmxw-00081a-DD for pgsql-admin@lists.postgresql.org; Wed, 27 Jul 2022 19:45:08 +0000 Received: from mout.perfora.net ([74.208.4.196]) by makus.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.92) (envelope-from ) id 1oGmxu-0003o3-4a for pgsql-admin@lists.postgresql.org; Wed, 27 Jul 2022 19:45:07 +0000 Received: from oxusgaltgw00.schlund.de ([10.72.72.46]) by mrelay.perfora.net (mreueus003 [74.208.5.2]) with ESMTPSA (Nemesis) id 0Lhgpj-1ncnIl3OpF-00mqs0; Wed, 27 Jul 2022 21:45:02 +0200 Date: Wed, 27 Jul 2022 15:45:01 -0400 (EDT) From: MichaelDBA Vitale To: Ian Lawrence Barwick , Scott Ribe Cc: Pgsql-admin Message-ID: <742509973.2598765.1658951101637@email.ionos.com> In-Reply-To: References: Subject: Re: error I don't understand MIME-Version: 1.0 Content-Type: text/html; charset=UTF-8 Content-Transfer-Encoding: quoted-printable X-Priority: 3 Importance: Normal X-Mailer: Open-Xchange Mailer v7.10.6-Rev18 X-Originating-Client: open-xchange-appsuite X-Provags-ID: V03:K1:TEFVhPyv9wL4nxHnP6Qjw2ezeNNhKj2OMKkoWrCYuKaEYVGVzgd NtaypNy1z+ERjDZetxKvraitLljmonnIUexHm8sfYxdu6bA3KyLjXQNq/SzfGJ1PcOp7YMx 3LHTjGp2cjM/bO7IYeHGHZNMfQe6eZOnzE+VbLnxG+te3A1vqVG0b3G1dCFSa5iyFxIPjd8 qf/jGcaMFSDw/OkMao8gw== X-Spam-Flag: NO X-UI-Out-Filterresults: notjunk:1;V03:K0:Lv5KX1vBQtU=:mLPx4pN7Fh66SnBvJIMbdy D45Atj0crJacNb7Pej8Mg9SVctPyiH/eURMeZzWbq7wXicTypxG0UQqGWFKOKjXymXeCCI+rq k6CWYzypYAfD7FRQ7//F15+ZTbOdsS3ZgK/qOumpxr1ZkjwR1djWaMn3Xzo5sDbcjD36S+XSh 2fKPy7vofeYPuxlW7GtIwQZpAlzaRz4wdGSS23mFk92h2uwujc0yKb33twbx+7Fz4E1xmcZW+ 9VPb360RIP+p67dZoyKITwMuoTwXmmrE6+pkkD6qCSqqNhpRIcK9YbOTIXuXtP3DpcAv87mcT OpEwooqxWFtmMyp2F8QInQyTnA/MkuAezNsxMaRZ3eiI+VjqVqEx7zfSFfh78/pKhUcaet6yf BK5upDKkr5WLBK7MXwhqMoBaW1NDGgjBveuHHaPx6xlPL1Rrt5iH/BSfq2C3v/+LAQ4lZQXdY 3Mo3Nz4LXKCpEU02YabHJhjYS0KVI3ZBF7s97uq/vc5CQwRQ9EyAX9lKE/NBQ7HfjUvrbGNPZ 93KeNPodTqDUolnHiK+sHlYO7K5lG3weR4jK5JHXmtBTSSDChsfU3cOy15dL+L4xoT4EXmEPe bpgujHDVJK5bVkMw5Dk2NAajz2iM+SrMGFr2bowoNdcTBPo4DHXSMlSzz+QyUcIYnEIfjGB52 Ha2KSLE50B23Ozjntv4fV9YLsompoUP6Jgntx7htTZQTHs8mca8bGqdxUefoXMLxxDjWsEiZN sbcNRxUQ5IRst9wL List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk =20 =20
I think if the linux user is defined as a system user, then you are OK.&= nbsp; It's only when the user is not defined as a system user that these ba= d side-effects can happen.
=20
 
=20
When creating linux users that work with Postgres, do it like this:
=20
adduser -r myuser
=20
or
=20
useradd -m --system myuser
=20
 
=20
See "systemd RemoveIPC" section in 
=20
https://www.postgresql.org/docs/current/kernel-resources.html
=20
 
=20
 
=20
Regards,
=20
Michael Vitale
=20
 
=20
=20
On 07/27/2022 1:30 PM EDT Ian Lawrence Barwick <barwick@gmail.com> wrote:
=20
 
=20
 
=20
2022=E5=B9=B47=E6=9C=8828=E6=97=A5(=E6=9C=A8) 0:35 Scott Ribe <scott_ribe@elevated-dev.com&g= t;:
=20
>
=20
=20
could not open shared memory segment "/PostgreSQL.3631378696": No such= file or directory
=20
=20
=20
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?
=20
=20
If you are using a Systemd-enabled Linux, check that "RemoveIPC" is
=20
set to "no".
=20
 
=20 =20
 
=20
Regards
=20
 
=20
Ian Barwick
=20
 
=20
 
=20
=20
--
=20
Scott Ribe
=20 =20 =20
=20
>
=20
>
=20
>
=20
>
=20