Re: Giving postgres roles 'sudo'-like access

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



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@xxxxxxxxxxxxxxx
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@xxxxxxxxxxxxxxx   Baltimore, MD
PostgreSQL Training, Services, and 24x7 Support  www.2ndQuadrant.us


--
Sent via pgsql-admin mailing list (pgsql-admin@xxxxxxxxxxxxxx)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-admin


[Index of Archives]     [KVM ARM]     [KVM ia64]     [KVM ppc]     [Virtualization Tools]     [Spice Development]     [Libvirt]     [Libvirt Users]     [Linux USB Devel]     [Linux Audio Users]     [Yosemite Questions]     [Linux Kernel]     [Linux SCSI]     [XFree86]

  Powered by Linux