Re: Monitor without superuser?

From: Greg Smith <greg(at)2ndQuadrant(dot)com>
To: pgsql-admin(at)postgresql(dot)org, jan(dot)sture(dot)nielsen(at)gmail(dot)com
Subject: Re: Monitor without superuser?
Date: 2012-02-28 16:44:04
Message-ID: 4F4D0454.2090507@2ndQuadrant.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin

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(at)2ndQuadrant(dot)com Baltimore, MD
PostgreSQL Training, Services, and 24x7 Support www.2ndQuadrant.com

In response to

Browse pgsql-admin by date

  From Date Subject
Next Message Brian Fehrle 2012-02-28 22:53:20 Hot standby having high requested checkpoints?
Previous Message Deepesh D 2012-02-28 12:05:27 Failover of a Hot standby setup with multiple standbys