| From: | Richard Huxton <dev(at)archonet(dot)com> |
|---|---|
| To: | Francisco Reyes <lists(at)natserv(dot)com> |
| Cc: | pgsql General List <pgsql-general(at)postgresql(dot)org> |
| Subject: | Re: Safe to kill idle connections? |
| Date: | 2005-10-17 14:32:36 |
| Message-ID: | 4353B604.1000901@archonet.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
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
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Jan Wieck | 2005-10-17 14:39:15 | Re: PostgreSQL Gotchas |
| Previous Message | Douglas McNaught | 2005-10-17 14:29:58 | Re: fine tuned database dump/reload? |