I'd like to monitor postgresql using the metricbeat module. To this end I want to use a separate psql account from any other logins.
What permissions does this account need?
By looking at https://www.elastic.co/guide/en/beats/metricbeat/current/metricbeat-module-postgresql.html#_example_configuration_30, you will need to specify hosts and then if you have username/password to connect to postgres, then specify those in metricbeat postgresql configuration as well. Is that what you are looking for?