Re: [SQL] Remote monitoring of Postgres w/minimal grants

2010-03-11 Thread Tony Wasson
On Wed, Mar 10, 2010 at 12:26 AM, Bryce Nesbitt wrote: > I'm setting up remote monitoring of postgres, but running into an > uncomfortable situation with permissions. > Basically it seems hard to set up a secure "read only" role, yet also allow > proper monitoring. > > A brief writeup of that is h

[SQL] Remote monitoring of Postgres w/minimal grants

2010-03-09 Thread Bryce Nesbitt
I'm setting up remote monitoring of postgres, but running into an uncomfortable situation with permissions. Basically it seems hard to set up a secure "read only" role, yet also allow proper monitoring. A brief writeup of that is here: http://help.logicmonitor.com/installation-getting-started/n