On Fri, Jul 27, 2012 at 6:27 PM, Mark Morgan Lloyd <markmll.pgsql-gene...@telemetry.co.uk> 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. 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 -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
