public inbox for [email protected]  

help / color / mirror / Atom feed

From: Albin Ary <[email protected]>
Cc: [email protected]
Subject: Re: Tuning Linux for Postgresql - Database failed to start
Date: Tue, 10 May 2022 22:39:09 +0200
Message-ID: <CAGCWzU++r4o+JAWPn8xn1yA+KncBz1=U22tjsw4Fw_d4a-wwTw@mail.gmail.com> (raw)
In-Reply-To: <[email protected]>
References: <CAGCWzU+OhJ7Z938nmkQh4yRijEKow3VC+t0dYgmErPcsEDeYpg@mail.gmail.com>
	<[email protected]>

Hello,

Thanks a lot for your inputs.

I only changed the section related to HugePages.

This server has 4 GB RAM.

shared_buffers = '1GB'
vm.nr_hugepages=650

tuned profile:



[main]
summary=Tuned profile for EDB PostgreSQL Instances
[bootloader]
cmdline=transparent_hugepage=never
[cpu]
governor=performance
energy_perf_bias=performance
min_perf_pct=100
[sysctl]
vm.swappiness = 10
vm.dirty_expire_centisecs = 500
vm.dirty_writeback_centisecs = 250
vm.dirty_ratio = 10
vm.dirty_background_ratio = 3
vm.overcommit_memory=0
net.ipv4.tcp_timestamps=0

[vm]
transparent_hugepages=never
vm.nr_hugepages=605

On Tue, 10 May 2022 at 22:29, Scott Ribe <[email protected]>
wrote:

> > On May 10, 2022, at 2:23 PM, Albin Ary <[email protected]> wrote:
> >
> > 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
>
> This is a decent quick guide to the parameters affecting this:
>
> https://docs.oracle.com/cd/E19879-01/821-0182/fxxua/index.html
>
> And here is the explanation as to how they related to postgres:
>
> https://www.postgresql.org/docs/14/kernel-resources.html
>
>

view thread (5+ messages)  latest in thread

reply

Reply instructions:

You may reply publicly to this message via plain-text email
using any one of the following methods:

* Reply to all the recipients using the --to and --cc options:
  reply via email

  To: [email protected]
  Cc: [email protected], [email protected]
  Subject: Re: Tuning Linux for Postgresql - Database failed to start
  In-Reply-To: <CAGCWzU++r4o+JAWPn8xn1yA+KncBz1=U22tjsw4Fw_d4a-wwTw@mail.gmail.com>

* Save the following mbox file, import it into your mail client,
  and reply-to-all from there: mbox

This inbox is served by agora; see mirroring instructions
for how to clone and mirror all data and code used for this inbox