Francisco Reyes wrote:
How about when one needs to reload to read new postgresql.conf files. Will iddle connections prevent the server from reloading?
http://www.postgresql.org/docs/8.0/static/app-pg-ctl.html
Also, in the future if other programs do the same, is it safe to kill these and if so what is the best way? kill command?
The pg_ctl program handles all your start/stop/reload requirements, although it just packages up various "kill" commands internally AFAIK. Probably a good idea to use it, since it gives you cross-platform compatibility for these things.
-- Richard Huxton Archonet Ltd ---------------------------(end of broadcast)--------------------------- TIP 2: Don't 'kill -9' the postmaster
