Chris Angelico wrote:
On Fri, Jul 27, 2012 at 6:27 PM, Mark Morgan Lloyd <markMLl.pgsql-general@xxxxxxxxxxxxxxx> wrote:Assuming a *nix server: if a monitoring program determines that an established connection appears to be trying to so something inappropriate, what's the best way of terminating that session rapidly?select pg_terminate_backend(procpid) from pg_stat_activity where ..... The main difficulty is recognizing which PID to terminate, though.
Exactly :-)I'd add that this is a hypothetical situation at present, I'm just trying to plan ahead.
There's a good lot of information available in pg_stat_activity; logins, application names, and connection IP addresses are handy here. But ultimately, it's just pg_terminate_backend. ChrisA
-- Mark Morgan Lloyd markMLl .AT. telemetry.co .DOT. uk [Opinions above are the author's, not those of his employers or colleagues] -- Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
[Postgresql Jobs] [Postgresql Admin] [Postgresql Performance] [Linux Clusters] [PHP Home] [PHP on Windows] [Programming PHP] [Kernel Newbies] [PHP Classes] [Find Someone Nice] [PHP Books] [PHP Databases] [Postgresql & PHP] [Yosemite]