Hello,
I’m using pmm2-client-2.0.1-5.el7.x86_64 under CentOS Linux release 7.6
When using pmm-admin to add a PostgreSQL Service, I execute:
pmm-admin add postgresql --username=dod_pmm --password=xxxxx pmm_config_test 127.0.0.1:6600
and this sets my postgres_exporter to a ‘running’ state and qan-postgresql-pgstatements-agent in ‘waiting’ state.
The problem is that, at the same time, I see in my PG log file messages like this:
[DB:dod_pmm] FATAL: database “dod_pmm” does not exist
Why is this? Does the postgres_exporter try to connect to a default database with the name of the pmm user (which I don’t have)? Shouldn’t just use postgres instead or let us specify a database in the ‘pmm-admin add’ command line?
Thanks