Re: [HACKERS] pg_monitor role

2017-02-22 Thread Stephen Frost
Dave, all, * Stephen Frost (sfr...@snowman.net) wrote: > * Dave Page (dp...@pgadmin.org) wrote: > > What modules should be included? > > On a quick review of all of the modules, excluding those that are just > testing or examples or which can already be used by non-superusers by > default, and

Re: [HACKERS] pg_monitor role

2017-02-22 Thread Stephen Frost
Dave, * Dave Page (dp...@pgadmin.org) wrote: > On Wed, Feb 22, 2017 at 4:52 PM, Stephen Frost wrote: > >> > > And what about the diagnostic tools such as pageinspect and > >> > > pgstattuple? > >> > > >> > I think external/contrib modules should not be included. To install >

Re: [HACKERS] pg_monitor role

2017-02-22 Thread Dave Page
Hi On Wed, Feb 22, 2017 at 4:52 PM, Stephen Frost wrote: >> > > What about granting to the role to read other statistic views such as >> > > pg_stat_replication and pg_stat_wal_receiver? Since these informations >> > > can only be seen by superuser the for example monitoring

Re: [HACKERS] pg_monitor role

2017-02-22 Thread Stephen Frost
All, * Magnus Hagander (mag...@hagander.net) wrote: > On Wed, Feb 22, 2017 at 1:47 PM, Dave Page wrote: > > On Tue, Feb 21, 2017 at 5:40 PM, Masahiko Sawada > > wrote: > > > On Mon, Feb 20, 2017 at 8:48 PM, Dave Page wrote: > > >>

Re: [HACKERS] pg_monitor role

2017-02-22 Thread Magnus Hagander
On Wed, Feb 22, 2017 at 1:47 PM, Dave Page wrote: > > On Tue, Feb 21, 2017 at 5:40 PM, Masahiko Sawada > wrote: > > On Mon, Feb 20, 2017 at 8:48 PM, Dave Page wrote: > >> Further to the patch I just submitted > >>

Re: [HACKERS] pg_monitor role

2017-02-22 Thread Dave Page
Hi On Tue, Feb 21, 2017 at 5:40 PM, Masahiko Sawada wrote: > On Mon, Feb 20, 2017 at 8:48 PM, Dave Page wrote: >> Further to the patch I just submitted >>

Re: [HACKERS] pg_monitor role

2017-02-21 Thread Masahiko Sawada
On Mon, Feb 20, 2017 at 8:48 PM, Dave Page wrote: > Further to the patch I just submitted > (https://www.postgresql.org/message-id/CA%2BOCxow-X%3DD2fWdKy%2BHP%2BvQ1LtrgbsYQ%3DCshzZBqyFT5jOYrFw%40mail.gmail.com) > I'd like to propose the addition of a default role, pg_monitor. >

Re: [HACKERS] pg_monitor role

2017-02-21 Thread Thomas Reiss
Le 20/02/2017 à 12:48, Dave Page a écrit : > Further to the patch I just submitted > (https://www.postgresql.org/message-id/CA%2BOCxow-X%3DD2fWdKy%2BHP%2BvQ1LtrgbsYQ%3DCshzZBqyFT5jOYrFw%40mail.gmail.com) > I'd like to propose the addition of a default role, pg_monitor. > > The intent is to make

[HACKERS] pg_monitor role

2017-02-20 Thread Dave Page
Further to the patch I just submitted (https://www.postgresql.org/message-id/CA%2BOCxow-X%3DD2fWdKy%2BHP%2BvQ1LtrgbsYQ%3DCshzZBqyFT5jOYrFw%40mail.gmail.com) I'd like to propose the addition of a default role, pg_monitor. The intent is to make it easy for users to setup a role for fully monitoring