Re: Safe to kill idle connections? - Mailing list pgsql-general

From Richard Huxton
Subject Re: Safe to kill idle connections?
Date
Msg-id 4353B604.1000901@archonet.com
Whole thread Raw
In response to Re: Safe to kill idle connections?  (Francisco Reyes <lists@natserv.com>)
List 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

pgsql-general by date:

Previous
From: Tom Lane
Date:
Subject: Re: PostgreSQL Gotchas
Next
From: Jan Wieck
Date:
Subject: Re: PostgreSQL Gotchas