BUG #18094: max max_connections cannot be set

From: PG Bug reporting form <noreply(at)postgresql(dot)org>
To: pgsql-bugs(at)lists(dot)postgresql(dot)org
Cc: nikolay(at)samokhvalov(dot)com
Subject: BUG #18094: max max_connections cannot be set
Date: 2023-09-07 15:56:33
Message-ID: 18094-884970cc4c015d42@postgresql.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-bugs

The following bug has been logged on the website:

Bug reference: 18094
Logged by: Nikolay Samokhvalov
Email address: nikolay(at)samokhvalov(dot)com
PostgreSQL version: 15.4
Operating system: MacOS
Description:

(apologies for double posting, please disregard the previous message)

Expectation for max max_connections is 262143 in PG14, but it cannot be
achieved:

nik=# select version();
version
---------------------------------------------------------------------------------------------------------------------------------
PostgreSQL 15.4 (Homebrew) on aarch64-apple-darwin22.4.0, compiled by Apple
clang version 14.0.3 (clang-1403.0.22.14.1), 64-bit
(1 row)

nik=# select max_val from pg_settings where name = 'max_connections';
max_val
---------
262143
(1 row)

nik=# alter system set max_connections to 262143;
ERROR: invalid value for parameter "max_connections": 262143
nik=# alter system set max_connections to 262142;
ERROR: invalid value for parameter "max_connections": 262142
nik=# alter system set max_connections to 262140;
ERROR: invalid value for parameter "max_connections": 262140
nik=# alter system set max_connections to 262135;
ERROR: invalid value for parameter "max_connections": 262135
nik=# alter system set max_connections to 262130;
ERROR: invalid value for parameter "max_connections": 262130
nik=# alter system set max_connections to 262100;
ALTER SYSTEM

Responses

Browse pgsql-bugs by date

  From Date Subject
Next Message David G. Johnston 2023-09-07 16:07:53 Re: BUG #18094: max max_connections cannot be set
Previous Message Zhijie Hou (Fujitsu) 2023-09-07 12:10:52 RE: BUG #18055: logical decoding core on AllocateSnapshotBuilder()