Re: pg_monitor role description

2021-05-22 Thread Pavel Luzanov
On 20.05.2021 21:25, Pavel Luzanov wrote: I'm totally confused. I'm taking timeout to think about it. I got it! It wasn't my day.)) This wording worked for me: The pg_monitor role is a member of the pg_read_all_settings role, which allows its privileges to be used. Therefore, pg_monitor can

Re: pg_monitor role description

2021-05-20 Thread Pavel Luzanov
On 20.05.2021 21:10, Tom Lane wrote: Pavel Luzanov writes: So, is it correct to change description of pg_monitor role from: "Read/execute various monitoring views and functions. This role is a member of|pg_read_all_settings|,|pg_read_all_stats| and|pg_stat_scan_tables|." to "Read/execute va

Re: pg_monitor role description

2021-05-20 Thread Tom Lane
Pavel Luzanov writes: > So, is it correct to change description of pg_monitor role from: > "Read/execute various monitoring views and functions. This role is a member > of|pg_read_all_settings|,|pg_read_all_stats| and|pg_stat_scan_tables|." > to > "Read/execute various monitoring views and funct

Re: pg_monitor role description

2021-05-20 Thread Pavel Luzanov
Hello, On 20.05.2021 20:27, Pavel Luzanov wrote: So, is it correct to change description of pg_monitor role from: "Read/execute various monitoring views and functions. This role is a member of|pg_read_all_settings|,|pg_read_all_stats| and|pg_stat_scan_tables|." to "Read/execute various monitor

Re: pg_monitor role description

2021-05-20 Thread Pavel Luzanov
Hello, On 20.05.2021 19:03, Tom Lane wrote: Pavel Luzanov writes: Let me try one more time. What is correct from the English language point of view: 1. Julien Rouhaud is a member of PostgreSQL Community. or 2. PostgreSQL Community is a member of Julien Rouhaud, Michael Paquier. Or both forms

Re: pg_monitor role description

2021-05-20 Thread Laurenz Albe
On Thu, 2021-05-20 at 12:03 -0400, Tom Lane wrote: > List of roles > Role name | Attributes | Member of > ---+--+- > bob | | {sysadmins} > joe | | {sysadmins} > sysadmins | Cannot login | {} > > and I think

Re: pg_monitor role description

2021-05-20 Thread Tom Lane
Pavel Luzanov writes: > Let me try one more time. > What is correct from the English language point of view: > 1. Julien Rouhaud is a member of PostgreSQL Community. > or > 2. PostgreSQL Community is a member of Julien Rouhaud, Michael Paquier. > Or both forms are correct? > I think that 1 is corr

Re: pg_monitor role description

2021-05-20 Thread Pavel Luzanov
On 20.05.2021 11:54, Julien Rouhaud wrote: On Thu, May 20, 2021 at 3:01 PM Michael Paquier wrote: On Thu, May 20, 2021 at 06:11:40AM +, PG Doc comments form wrote: "This role is a member of pg_read_all_settings, pg_read_all_stats and pg_stat_scan_tables." Is it correct sentence? It seems

Re: pg_monitor role description

2021-05-20 Thread Julien Rouhaud
On Thu, May 20, 2021 at 3:01 PM Michael Paquier wrote: > > On Thu, May 20, 2021 at 06:11:40AM +, PG Doc comments form wrote: > > "This role is a member of pg_read_all_settings, pg_read_all_stats and > > pg_stat_scan_tables." > > Is it correct sentence? > > It seems for me that pg_read_all_stat

Re: pg_monitor role description

2021-05-20 Thread Michael Paquier
On Thu, May 20, 2021 at 06:11:40AM +, PG Doc comments form wrote: > "This role is a member of pg_read_all_settings, pg_read_all_stats and > pg_stat_scan_tables." > Is it correct sentence? > It seems for me that pg_read_all_stats is a member of pg_monitor. But not > vice versa. Here is what I a

pg_monitor role description

2021-05-19 Thread PG Doc comments form
The following documentation comment has been logged on the website: Page: https://www.postgresql.org/docs/13/default-roles.html Description: "This role is a member of pg_read_all_settings, pg_read_all_stats and pg_stat_scan_tables." Is it correct sentence? It seems for me that pg_read_all_stats i