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


---------------------------(end of broadcast)---------------------------
TIP 6: explain analyze is your friend

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

---------------------------(end of broadcast)---------------------------
TIP 2: Don't 'kill -9' the postmaster