The DB user must have access to all databases you wish to monitor. The agent will only query system tables and views and make use of a few system functions in order to gather operational data.
User privileges required for the PostgreSQL agent:
- SUPERUSER (optional)
- CONNECT (on all databases)
- SELECT (on all databases)
The SUPERUSER privilege is required in order to make use of administration functions through the Foglight console. Usage of the functions is restricted to Foglight users who have been granted the “PostgreSQL Administrator” role.