On 12/19/2011 07:46 PM, Craig James wrote:
Backend Postgres processes run as the Postgres user, so they have
permission to kill each other. You write an add-on function that just
kills a process:
select my_kill_backend(pid);
Naturally, this is very dangerous. There are all sorts of
On 12/19/2011 01:04 PM, Mario Splivalo wrote:
I need to have postgres role to be able to cancel queries run by that
same role.
This feature is close to commit as a new one for PostgreSQL 9.2:
http://archives.postgresql.org/message-id/4eeb3a2b.8090...@2ndquadrant.com
I need to have postgres role to be able to cancel queries run by that
same role.
I know that I can kill the client connection that started the query, but
I also need to have that role connect to postgres and kill some of it's
running queries.
It's on postgres 9.1.1, running on Debian Squeeze.
On 12/19/11 10:04 AM, Mario Splivalo wrote:
I need to have postgres role to be able to cancel queries run by that
same role.
I know that I can kill the client connection that started the query, but
I also need to have that role connect to postgres and kill some of it's
running queries.
It's on