allow a user to see current_query in pg_stat_activity in 8.4

From: Greg Williamson <gwilliamson39(at)yahoo(dot)com>
To: "pgsql-admin(at)postgresql(dot)org" <pgsql-admin(at)postgresql(dot)org>
Subject: allow a user to see current_query in pg_stat_activity in 8.4
Date: 2012-12-14 02:59:27
Message-ID: 1355453967.41645.YahooMailNeo@web125905.mail.ne1.yahoo.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin

This seems like a question whose answer must be right in front of me, but I am not seeing it.

We want to create a role used by a monitor to check for "<IDLE> in Transaction" with the most restrictive permissions we can on a 8.4.13 instance.

The user has been granted connect privilege to the database and some limited permissions to user tabhles that need to be monitored. But pg_stat_activity shows only "<insufficient privilege>"

I've trolled the archives and postgres docs with no success.

Could some kind soul point me in the right direction ?

Thanks!

Greg Williamson

Responses

Browse pgsql-admin by date

  From Date Subject
Next Message Tom Lane 2012-12-14 03:16:36 Re: allow a user to see current_query in pg_stat_activity in 8.4
Previous Message Kevin Grittner 2012-12-13 16:06:07 Re: Confuse about the behaveior of PreparedStatement.executeBatch (jdbc)