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
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() |