Postgres Pro
Downloads
Home   >   mailing lists

Re: How to force disconnections from a Perl script? - Mailing list pgsql-general

From Tom Lane
Subject Re: How to force disconnections from a Perl script?
Date
Msg-id 18622.1171939437@sss.pgh.pa.us
Whole thread Raw
In response to Re: How to force disconnections from a Perl script?  (Csaba Nagy <nagy@ecircle-ag.com>)
Responses Re: How to force disconnections from a Perl script?  (Csaba Nagy <nagy@ecircle-ag.com>)
List pgsql-general
Tree view 
Csaba Nagy <nagy@ecircle-ag.com> writes:
> And pg_stat will only show you running queries, not the idle
> connections.

Nonsense.  pg_stat_activity + "kill -TERM" should solve this problem
reasonably well.  Some of us don't trust kill -TERM 100%, which is why
it's not currently exposed as a standard function, but if you're using
a reasonably recent PG release it's probably safe.

            regards, tom lane

pgsql-general by date:

Previous
From: Alvaro Herrera
Date:
Subject: Re: Why *exactly* is date_trunc() not immutable ?
Next
From: David Fetter
Date:
Subject: Re: complex referential integrity constraints