From: Tom Lane <tgl@sss.pgh.pa.us>
To: Evan Rempel <erempel@uvic.ca>
Cc: Chris Hoover <chrish@aweber.com>
Cc: pgsql-admin@lists.postgresql.org
Subject: Re: New PG14 server won't start with >2GB shared_buffers
Date: Sat, 25 Feb 2023 11:35:17 -0500
Message-ID: <1177969.1677342917@sss.pgh.pa.us> (raw)
In-Reply-To: <8b47c295-4b16-1a00-32e4-807103816475@uvic.ca>
References: <A446608A-42A3-4CBB-BD45-47BE009B0029@aweber.com>
<4b583c4a-022f-f452-c0c8-0a932a6ee411@gmail.com>
<C6285AA6-5195-4C8B-A599-401845EFD174@aweber.com>
<4a41387e-516e-0782-6110-89c05a99d020@sqlexec.com>
<20230225144930.GS9791@aart.rice.edu>
<B6A7F0D1-D06E-43F1-8787-BE90ADB3D05D@aweber.com>
<8b47c295-4b16-1a00-32e4-807103816475@uvic.ca>
Evan Rempel <erempel@uvic.ca> writes:
> Bear in mind that if you are using systemd to start postgres, then these
> user limits may not apply.
Yeah, it seems likely that the PG server is being started under
more-restrictive limits than what these manual reports suggest.
It would be useful to try logging in as the Postgres OS user and
manually starting the server -- just do "postgres &" and see what
happens. (If it does start, "pg_ctl stop" can be used to shut it
down again, or you can manually send SIGTERM to the postmaster
process.)
I tried to reproduce the problem by intentionally setting
"ulimit -v" too small for my PG settings, and I got error messages
that were similar but not identical to what Chris reported.
(I think the sysv case failed at shmat() not shmget().) So it's
probably not ulimit per se that's responsible. But if the
server is being started under systemd, then I can entirely
believe that systemd has some poorly-documented feature that
sets additional limits for daemon processes.
I'm still wondering about cgroups, too.
regards, tom lane
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: pgsql-admin@postgresql.org
Cc: tgl@sss.pgh.pa.us, erempel@uvic.ca, chrish@aweber.com, pgsql-admin@lists.postgresql.org
Subject: Re: New PG14 server won't start with >2GB shared_buffers
In-Reply-To: <1177969.1677342917@sss.pgh.pa.us>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox