[PERFORM] Changing max_connections without restart ?

2006-08-25 Thread Jean Arnaud 

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

Re: [PERFORM] Changing max_connections without restart ?

2006-08-25 Thread Tom Lane 
Jean Arnaud [EMAIL PROTECTED] 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