The following bug has been logged online:
Bug reference: 4815
Logged by: Damien Guignard
Email address: damien.guignard@lotsys.com
PostgreSQL version: 8.3.4
Operating system: Windows
Description: max_connections setting has no impact
Details:
While testing connections i tried to raise up max_connections but this
setting is never taken into account. The maximum connection (backends from
pg_stat_database) seems to be the default number : 101.
Setting in postgresql.conf :
max_connections = 200
Commands to count connections in psql CLI :
show max_connections -> 200 (ok)
but stressed whith hundreds of connections :
select sum(numbackends) from pg_stat_database; -> 101