Monitor without superuser?

[Jan Nielsen <jan.sture.nielsen@xxxxxxxxx>]

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. And I ran across this:

��http://blog.kimiensoftware.com/2011/05/querying-pg_stat_activity-and-insufficient-privilege-291

Specifically, I'd like to enable the dba_monitor users to use PGAdmin III Server Status tools which requires superuser and I would like this role to be able write queries like:

SELECT *�

FROM pg_locks�

� LEFT OUTER JOIN�pg_class � � � � � ON (pg_locks.relation = pg_class.oid)

� LEFT OUTER JOIN pg_namespace �ON (pg_namespace.oid = pg_class.relnamespace),

� pg_stat_activity

� WHERE

� � NOT pg_locks.pid=pg_backend_pid()

� � AND�pg_locks.pid=pg_stat_activity.procpid;

and be able to read all the contents, including the "current_query" which, it appears, requires superuser.

Is this achievable? Any way around this?

Cheers,

Jan