We are running metricbeat-7.6.0 on a RedHat 7 system. The basic Metricbeat app is running and connecting with ES. However, the postgresql module is not connecting to the local database. The password, shown here as "redacted" works otherwise. It appears to be using the username as the database name when trying to connect:
Feb 25 13:46:30 bnlbox04 metricbeat: 2020-02-25T13:46:30.884-0500#011INFO#011module/wrapper.go:252#011Error fetching data for metricset postgresql.bgwriter: error in QueryStats: failed to obtain a connection with the database: pq: database "redacted" does not exist
Hi @thealy What's your postgres version? It might be some version mismatch. I'm not sure if I understood correctly but did you use username AND password to connect? (even if it's an empty password).
I agree that it seems like it's using the username as the database to connect and that's totally unexpected
Hi Mario-
OK, I just tried that variation and the result is the same:
Error fetching data for metricset postgresql.activity: error in QueryStats: failed to obtain a connection with the database: pq: database "bnlboxread" does not exist
-Terry
Apache, Apache Lucene, Apache Hadoop, Hadoop, HDFS and the yellow elephant
logo are trademarks of the
Apache Software Foundation
in the United States and/or other countries.