Exact permissions need PMM user on Postgresql?

Percona Monitoring and Management (PMM) PMM 2.x
,
1

Description:

The official Percona Monitoring and Management (PMM) documentation suggests creating a PMM user with WITH SUPERUSER permission. However, I prefer to avoid granting such extensive permissions. While the PMM agent operates smoothly with basic permissions, I encountered an issue with Query Analytics.

After executing GRANT SELECT ON pg_stat_statements TO pmm-user on all databases, I can observe query analytics on the ‘postgres’ system database, but not on other databases.

I’m seeking guidance on whether it’s possible to enable query analytics in PMM without granting superuser permissions to the user.

Version:

PMM Version: 2.40.0

2

Hi,

Take a look at the reference documentation regarding postgres specific roles that can be membered to user-defined accounts.

My personal favorite is pg_monitor.

Hope this helps.

1 Like