pgsql: Give up on running with NetBSD/OpenBSD's default semaphore setti

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: pgsql-committers(at)lists(dot)postgresql(dot)org
Subject: pgsql: Give up on running with NetBSD/OpenBSD's default semaphore setti
Date: 2025-04-29 21:27:58
Message-ID: E1u9sUg-000DTo-2p@gemulon.postgresql.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-committers

Give up on running with NetBSD/OpenBSD's default semaphore settings.

This reverts commit 38da053463bef32adf563ddee5277d16d2b6c5af, which
attempted to preserve our ability to start with only 60 semaphores.

Subsequent changes (particularly 55b454d0e) have put that idea pretty
much permanently out of reach: people wishing to use Postgres v18 on
OpenBSD or NetBSD will have no choice but to increase those platforms'
default values of SEMMNI and SEMMNS.

Hence, revert 38da05346's changes in SEMAS_PER_SET and the minimum
tested value of max_connections. Adjust a comment from the subsequent
patch 6d0154196, and tweak the wording in runtime.sgml to make it
clear that changing SEMMNI/SEMMNS is no longer even a little bit
optional on these platforms.

Although 38da05346 was later back-patched into v17, leave that branch
alone: it's still capable of starting with 60 semaphores, and there's
no reason to break that.

Author: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
Reviewed-by: Nathan Bossart <nathandbossart(at)gmail(dot)com>
Discussion: https://postgr.es/m/E1tuZNv-0037Gs-34@gemulon.postgresql.org
Discussion: https://postgr.es/m/1052019.1745947915@sss.pgh.pa.us

Branch
------
master

Details
-------
https://git.postgresql.org/pg/commitdiff/810a8b1c8051d4e8822967a96f133692698386de

Modified Files
--------------
doc/src/sgml/runtime.sgml | 24 ++++++++++++------------
src/backend/port/sysv_sema.c | 8 +-------
src/bin/initdb/initdb.c | 9 ++++-----
3 files changed, 17 insertions(+), 24 deletions(-)

Browse pgsql-committers by date

  From Date Subject
Next Message David Rowley 2025-04-30 01:41:03 pgsql: Fix a couple of comment typos
Previous Message Jacob Champion 2025-04-29 20:23:24 pgsql: oauth: Classify oauth_client_secret as a password