Loading

what is maximum limit of "max_connections" parameter in PostgreSQL 14

Pankaj

what is the maximum limit of "max_connections" parameter in PostgreSQL 14 ?

2 Replies

Know the answer? Post it — somebody with the same question will find it here.

Rajanikant Hawaldar4y ago
Accepted answer
Hello Pankaj,
Please check
SELECT name, unit, vartype, min_val, max_val
  FROM pg_settings
WHERE name = 'max_connections';

      name       |  unit  | vartype | min_val | max_val
-----------------+--------+---------+---------+---------
max_connections | <NULL> | integer | 1       | 262143
+3
Amit Mohanty4y ago
Check the link

https://postgresqlco.nf/doc/en/param/max_connections/
+1