Re: Safe to kill idle connections?

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