Date: Thu, 20 May 2021 16:00:29 +0900
From: Michael Paquier <michael@paquier.xyz>
To: pluzanov@postgrespro.ru, pgsql-docs@lists.postgresql.org
Subject: Re: pg_monitor role description
Message-ID: <YKYJDXxnQ4hcUVYd@paquier.xyz>
References: <162149110071.26171.15811576640435665698@wrigleys.postgresql.org>
MIME-Version: 1.0
Content-Type: multipart/signed; micalg=pgp-sha512;
	protocol="application/pgp-signature"; boundary="miWU6i+QoEmBS7Hu"
Content-Disposition: inline
In-Reply-To: <162149110071.26171.15811576640435665698@wrigleys.postgresql.org>
Archived-At: 
 <https://www.postgresql.org/message-id/YKYJDXxnQ4hcUVYd%40paquier.xyz>
Precedence: bulk


--miWU6i+QoEmBS7Hu
Content-Type: text/plain; charset=us-ascii
Content-Disposition: inline

On Thu, May 20, 2021 at 06:11:40AM +0000, 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 am getting:
=# \dgS pg_monitor
                                      List of roles
 Role name  |  Attributes  |                         Member of
------------+--------------+--------------------------------------------------------------
 pg_monitor | Cannot login | {pg_read_all_settings,pg_read_all_stats,pg_stat_scan_tables}

=# \dgS pg_read_all_data
                List of roles

    Role name     |  Attributes  | Member of
------------------+--------------+-----------
 pg_read_all_data | Cannot login | {}

So the docs look correct to me.
--
Michael

--miWU6i+QoEmBS7Hu
Content-Type: application/pgp-signature; name="signature.asc"

-----BEGIN PGP SIGNATURE-----

iQIzBAABCgAdFiEEG72nH6vTowiyblFKnvQgOdbyQH0FAmCmCQ0ACgkQnvQgOdby
QH3Igw/9HUFYNuqAl41JUfZ5RdfnDcu09YpmfBMj1fUAoyPwdUEiPAtY1+E0uc84
JIEp3HjI25Ucc6tkMSY/XyDVSC2VoxVZnkPW2yD7J9xovnXQeEBFEWAmMxd/luTW
9McndW3h3/2hH1JPR1peOHBRdyJVH12d5dPgaljaGSdZCQcoxDVfFyYUtRae2/W5
978JhSO6RLdCBfbttR1d5gh5r4FvrHkWUTczjA7KoEpZdsSW84yEhsx7rzUrl+E/
QJYGzIOlo7zmFuCwHUABN7QTelfq3nReA4BCPx5LV1HT7n7zci+1I0kgCDTsDvdk
kuNbeXomIZ/rrFxOQN4f6LLDrBE/MTE0aXZdxBnAuqDX0ry+SxFDbiA5ULtgshJL
rmfl1JXFeXzjTnEAdqQvEdqLXN5aIPiyqRhZqX5V+FPCCc0F4fXzo7WLaQy5qReV
uMPiWvstTXgjqGBSXMK5w+8sEn/gCVqpg1LHtOiHWUklDPLbISqgl2J9yde3zJCJ
Mc+ogLJQWciWIfKpwPN+J4IgsILBuWdK5Qr+W2WdOzg+FTvCZYzxXMzchxAgEqqG
BcTrh+lMKbDLdSxY0BNPRPjs4Un1MxdyYGQ4p5qXLN7BLsSBfo2XSDCp5tuLVC3y
b8YgKqDP2F/qVox12defRuXM7RfVDlCZ1+rRFqpZlgOc8cAJImk=
=D6Tk
-----END PGP SIGNATURE-----

--miWU6i+QoEmBS7Hu--