search

prometheus-community / postgres_exporter

A PostgreSQL metric exporter for Prometheus
Apache License 2.0
2.64k stars 712 forks source link

probe not read parameters from env and config #808

Open vvp1983 opened 1 year ago

vvp1983 commented 1 year ago

When i try get metrics from probe - apllication not read parameters

sudo docker run --rm --name=pg -p9187:9187 -e DATA_SOURCE_NAME="postgresql://postgres_exporter:password@192.168.0.109:5432/postgres?sslmode=disable,postgresql://postgres:mysecretpassword@192.168.0.109:5433/postgres?sslmode=disable" quay.io/prometheuscommunity/postgres-exporter

ts=2023-06-08T19:04:18.539Z caller=main.go:86 level=error msg="Error loading config" err="Error opening config file \"postgres_exporter.yml\": open postgres_exporter.yml: no such file or directory"
ts=2023-06-08T19:04:18.539Z caller=proc.go:250 msg="Excluded databases" databases=[]
ts=2023-06-08T19:04:18.539Z caller=tls_config.go:232 level=info msg="Listening on" address=[::]:9187
ts=2023-06-08T19:04:18.539Z caller=tls_config.go:235 level=info msg="TLS is disabled." http2=false address=[::]:9187
ts=2023-06-08T19:04:21.555Z caller=server.go:74 level=info msg="Established new database connection" fingerprint=192.168.0.109:5432
ts=2023-06-08T19:04:21.565Z caller=postgres_exporter.go:647 level=info msg="Semantic version changed" server=192.168.0.109:5432 from=0.0.0 to=15.2.0

When http://192.168.0.109:9187/probe?target=192.168.0.109 so i get 

ts=2023-06-08T19:05:08.821Z caller=probe.go:41 level=info msg="no auth_module specified, using default"
ts=2023-06-08T19:05:08.822Z caller=server.go:74 level=info msg="Established new database connection" fingerprint=192.168.0.109:5432
ts=2023-06-08T19:05:08.825Z caller=collector.go:194 level=error target=192.168.0.109 msg="collector failed" name=bgwriter duration_seconds=0.002975554 err="pq: SSL is not enabled on the server"
ts=2023-06-08T19:05:08.830Z caller=collector.go:194 level=error target=192.168.0.109 msg="collector failed" name=replication_slot duration_seconds=0.008109047 err="pq: SSL is not enabled on the server"
ts=2023-06-08T19:05:08.832Z caller=collector.go:194 level=error target=192.168.0.109 msg="collector failed" name=database duration_seconds=0.010163484 err="pq: SSL is not enabled on the server"
ts=2023-06-08T19:05:09.825Z caller=postgres_exporter.go:716 level=error err="Error opening connection to database (postgresql://192.168.0.109): pq: SSL is not enabled on the server"

but http://192.168.0.109:9187/metrics work and return metrics

# HELP pg_locks_count Number of locks
# TYPE pg_locks_count gauge
pg_locks_count{datname="postgres",mode="accessexclusivelock",server="192.168.0.109:5432"} 0
pg_locks_count{datname="postgres",mode="accessexclusivelock",server="192.168.0.109:5433"} 0
pg_locks_count{datname="postgres",mode="accesssharelock",server="192.168.0.109:5432"} 1
vvp1983 commented 1 year ago

My mistake. http://192.168.0.109:9187/probe?target=192.168.0.109:5433&auth_module=test working well