Thread: Increase max_connections
Hi all, is it possible increase the max_connections value without restarting the server ? Ciao Gaetano
you could do a "kill -SIGHUP postmaster_pid". This will tell postmaster to re-read the configuration files.
regards,
Devinder Rajput
Stores Division Corporate Offices
Chicago, IL
(773) 442-6474
"Gaetano Mendola" <mendola@bigfoot.com> Sent by: pgsql-admin-owner@postgresql.org 01/08/2003 04:19 AM | To: pgsql-admin@postgresql.org cc: Subject: [ADMIN] Increase max_connections |
Hi all,
is it possible increase the max_connections value without
restarting the server ?
Ciao
Gaetano
---------------------------(end of broadcast)---------------------------
TIP 1: subscribe and unsubscribe commands go to majordomo@postgresql.org
"Gaetano Mendola" <mendola@bigfoot.com> writes: > is it possible increase the max_connections value without > restarting the server ? Nope, sorry. This *is* documented btw. MAX_CONNECTIONS (integer) Determines the maximum number of concurrent connections to the database server. The default is 32 (unless altered while building the server). This parameter can only be set at server start. regards, tom lane
I seen, but I was hopping till now that was not true! :-( Ciao Gaetano. "Tom Lane" <tgl@sss.pgh.pa.us> wrote in message news:4625.1042046006@sss.pgh.pa.us... > "Gaetano Mendola" <mendola@bigfoot.com> writes: > > is it possible increase the max_connections value without > > restarting the server ? > > Nope, sorry. > > This *is* documented btw. > > MAX_CONNECTIONS (integer) > > Determines the maximum number of concurrent connections to the database server. The default is 32 (unless > altered while building the server). This parameter can only be set at server start. > > > regards, tom lane > > ---------------------------(end of broadcast)--------------------------- > TIP 1: subscribe and unsubscribe commands go to majordomo@postgresql.org