Thread: Changing max_connections without restart ?

Changing max_connections without restart ?

From
Jean Arnaud
Date:
Hi !

I'm looking for a way to change the "max_connections" parameter without
restarting the PostGreSQL database.
All the docs i found online are saying that this option can only be set
on startup (-N option to comand-line) or by changing it in postgresql.conf.

Does anyone know how to do it ?

Thanks

--
-- Jean Arnaud
-- Projet SARDES
-- INRIA Rhône-Alpes / LSR-IMAG
-- Tél. : +33 (0)4 76 61 52 80


Re: Changing max_connections without restart ?

From
Tom Lane
Date:
Jean Arnaud <Jean.Arnaud@inrialpes.fr> writes:
> I'm looking for a way to change the "max_connections" parameter without
> restarting the PostGreSQL database.

There is none.  That's one of the parameters that determines shared
memory array sizes, and we can't change those on-the-fly.

            regards, tom lane