MIME-Version: 1.0
From: Albin Ary <albinary10@gmail.com>
Date: Tue, 10 May 2022 22:23:02 +0200
Message-ID: 
 <CAGCWzU+OhJ7Z938nmkQh4yRijEKow3VC+t0dYgmErPcsEDeYpg@mail.gmail.com>
Subject: Tuning Linux for Postgresql - Database failed to start
To: pgsql-admin@lists.postgresql.org
Content-Type: multipart/alternative; boundary="000000000000370d4405deae1865"
Archived-At: 
 <https://www.postgresql.org/message-id/CAGCWzU%2BOhJ7Z938nmkQh4yRijEKow3VC%2Bt0dYgmErPcsEDeYpg%40mail.gmail.com>
Precedence: bulk

--000000000000370d4405deae1865
Content-Type: text/plain; charset="UTF-8"

Hello,
I have a Postgresql Database cluster.
Version: 14.2
OS: Oracle Linux 8

I tried to follow the link to optimize the server.
https://www.enterprisedb.com/blog/tuning-red-hat-enterprise-linux-family-postgresql


Unfortunately, after rebooting the database is not starting anymore. I know
the HINT is straightforward but I am not able to see what the reason could
be.

Any advice would be appreciated.

-- Unit postgresql-14.service has begun starting up.
May 10 22:10:40 postgersdb.localdomain postmaster[1612]: 2022-05-10
22:10:40.047 CEST [1612] FATAL:  could not map anonymous shared memory:
Cannot allocate memory
May 10 22:10:40 postgersdb.localdomain postmaster[1612]: 2022-05-10
22:10:40.047 CEST [1612] *HINT:  This error usually means that PostgreSQL's
request for a shared memory segment exceeded available memory,>*
May 10 22:10:40 postgersdb.localdomain postmaster[1612]: 2022-05-10
22:10:40.048 CEST [1612] LOG:  database system is shut down
May 10 22:10:40 postgersdb.localdomain systemd[1]: postgresql-14.service:
Main process exited, code=exited, status=1/FAILURE
May 10 22:10:40 postgersdb.localdomain systemd[1]: postgresql-14.service:
Failed with result 'exit-code'.
-- Subject: Unit failed
-- Defined-By: systemd
-- Support: https://support.oracle.com

--000000000000370d4405deae1865
Content-Type: text/html; charset="UTF-8"
Content-Transfer-Encoding: quoted-printable

<div dir=3D"ltr">Hello,=C2=A0<div>I have a Postgresql Database cluster.=C2=
=A0</div><div>Version: 14.2</div><div>OS: Oracle Linux 8</div><div><br></di=
v><div>I tried to follow the link to optimize the server.</div><div><a href=
=3D"https://www.enterprisedb.com/blog/tuning-red-hat-enterprise-linux-famil=
y-postgresql">https://www.enterprisedb.com/blog/tuning-red-hat-enterprise-l=
inux-family-postgresql</a>=C2=A0<br></div><div><br></div><div>Unfortunately=
, after rebooting the database is not starting anymore. I know the HINT is =
straightforward but I am not able to see what the reason could be.=C2=A0</d=
iv><div><br></div><div>Any advice would be appreciated.</div><div><br></div=
><div>-- Unit postgresql-14.service has begun starting up.<br>May 10 22:10:=
40 postgersdb.localdomain postmaster[1612]: 2022-05-10 22:10:40.047 CEST [1=
612] FATAL: =C2=A0could not map anonymous shared memory: Cannot allocate me=
mory<br>May 10 22:10:40 postgersdb.localdomain postmaster[1612]: 2022-05-10=
 22:10:40.047 CEST [1612] <b>HINT: =C2=A0This error usually means that Post=
greSQL&#39;s request for a shared memory segment exceeded available memory,=
&gt;</b><br>May 10 22:10:40 postgersdb.localdomain postmaster[1612]: 2022-0=
5-10 22:10:40.048 CEST [1612] LOG: =C2=A0database system is shut down<br>Ma=
y 10 22:10:40 postgersdb.localdomain systemd[1]: postgresql-14.service: Mai=
n process exited, code=3Dexited, status=3D1/FAILURE<br>May 10 22:10:40 post=
gersdb.localdomain systemd[1]: postgresql-14.service: Failed with result &#=
39;exit-code&#39;.<br>-- Subject: Unit failed<br>-- Defined-By: systemd<br>=
-- Support: <a href=3D"https://support.oracle.com">https://support.oracle.c=
om</a><br></div></div>

--000000000000370d4405deae1865--