Ready only user to operate PMM for Postgresql

siddharth0204 · February 4, 2025, 10:00am

hello,

We are using PMM for monitoring our Postgresql Production instances.
WE would like to know if it should be enough to create read only user to login to PMM and provide necessary grants like pg_monitor?
Documentation asks us to create a Super User and it is conflicting with our compliance

Please help us understand

Thanks and Regards,
Siddharth

nurlan · February 4, 2025, 1:47pm

Hi, theoretically it should be ok.
Just some features like explain, advisors and pt-postgres-summary might not work.

Topic		Replies	Views
Minimum grant that PMM requires for monitoring postgres with pg_stat_monitor pg_stat_monitor	3	370	February 3, 2025
Exact permissions need PMM user on Postgresql? PMM 2.x postgres , postgresql	1	511	February 6, 2024
PostgreSQL DB account role and privilege PostgreSQL pmm	3	1066	November 21, 2022
Super privileges for pmm user PMM 1.x	1	2128	January 17, 2019
What grants need Qan postgresql pgstatements agent? PostgreSQL	3	978	July 12, 2023

Ready only user to operate PMM for Postgresql

Related topics