Re: Giving postgres roles 'sudo'-like access

From: Greg Smith <greg(at)2ndQuadrant(dot)com>
To: pgsql-admin(at)postgresql(dot)org
Subject: Re: Giving postgres roles 'sudo'-like access
Date: 2011-12-20 13:49:28
Message-ID: 4EF09268.6090305@2ndQuadrant.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin

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.8090102@2ndQuadrant.com
http://archives.postgresql.org/pgsql-hackers/2011-12/msg00822.php

You might use some of that code and make your own pg_cancel_backend-like
function that loads into the database.

--
Greg Smith 2ndQuadrant US greg(at)2ndQuadrant(dot)com Baltimore, MD
PostgreSQL Training, Services, and 24x7 Support www.2ndQuadrant.us

In response to

Browse pgsql-admin by date

  From Date Subject
Next Message Alexander Fortin 2011-12-20 15:11:23 Can't get pg_upgrade work for 8.4
Previous Message Mario Splivalo 2011-12-20 08:14:25 Re: Giving postgres roles 'sudo'-like access