Postgres Pro
Downloads
Home   >   mailing lists

Re: Monitor without superuser? - Mailing list pgsql-admin

From Greg Smith
Subject Re: Monitor without superuser?
Date
Msg-id 4F4D0454.2090507@2ndQuadrant.com
Whole thread Raw
In response to Monitor without superuser?  (Jan Nielsen <jan.sture.nielsen@gmail.com>)
List pgsql-admin
Tree view 
On 02/17/2012 10:37 AM, Jan Nielsen wrote:
> I would like to create a role "dba_monitor" for a portion of my PG 9.1
> user-base to be able to monitor PG but without granting superuser.

You want to create a security definer function for this:
http://www.postgresql.org/docs/9.1/static/sql-createfunction.html

--
Greg Smith   2ndQuadrant US    greg@2ndQuadrant.com   Baltimore, MD
PostgreSQL Training, Services, and 24x7 Support www.2ndQuadrant.com

pgsql-admin by date:

Previous
From: Deepesh D
Date:
Subject: Failover of a Hot standby setup with multiple standbys
Next
From: Brian Fehrle
Date:
Subject: Hot standby having high requested checkpoints?