Thread: BUG #4815: max_connections setting has no impact
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
"Damien Guignard" wrote: >PostgreSQL version: 8.3.4 >Operating system: Windows > >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. I guess the last question in the Windows FAQ is answering your question: <http://wiki.postgresql.org/wiki/Running_%26_Installing_PostgreSQL_On_Native_Windows> Rainer