Postgres Pro
Downloads
Home   >   mailing lists

Re: Giving postgres roles 'sudo'-like access - Mailing list pgsql-admin

From Greg Smith
Subject Re: Giving postgres roles 'sudo'-like access
Date
Msg-id 4EF09268.6090305@2ndQuadrant.com
Whole thread Raw
In response to Giving postgres roles 'sudo'-like access  (Mario Splivalo <mario.splivalo@megafon.hr>)
List pgsql-admin
Tree view 
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@2ndQuadrant.com   Baltimore, MD
PostgreSQL Training, Services, and 24x7 Support  www.2ndQuadrant.us

pgsql-admin by date:

Previous
From: Mario Splivalo
Date:
Subject: Re: Giving postgres roles 'sudo'-like access
Next
From: Alexander Fortin
Date:
Subject: Can't get pg_upgrade work for 8.4