[Content Bug] Edit page "Export metrics to Prometheus"

[jkoria]

Use this template for reporting bugs in the docs.

Describe the bug

We need to grant the pg_monitor role to the monitoring user to avoid the error while selecting on pg_ls_waldir():

ERROR: permission denied for function pg_ls_waldir

What should the docs say?

c. Grant pg_monitor to the monitoring user:

grant pg_monitor to monitoring;

Page affected

Export metrics to Prometheus

Contributing to documentation

We welcome documentation contributions!

• For information about how to propose a change, see the contributing guide in our GitHub repository.
• For information on style and word usage, see the style guide

[atovpeko]

Hi @jkoria,
pg_read_all_stats should be sufficient according to the Postgres exporter documentation:

To be able to collect metrics from pg_stat* views as non-superuser in PostgreSQL server versions >= 10 you can grant the pg_monitor or pg_read_all_stats built-in roles to the user.

Are you getting some sort of error when not granting pg_monitor specifically?

[jkoria]

Hi @atovpeko - as I mentioned:

We need to grant the pg_monitor role to the monitoring user to avoid the error while selecting on pg_ls_waldir():
ERROR: permission denied for function pg_ls_waldir

We have a customer who reported this error, and it was fixed by:

grant pg_monitor to monitoring;

Thank!!