-
Notifications
You must be signed in to change notification settings - Fork 14
Description
Hi,
I installed pgbouncer_exporter ver=0.1.4 with yum in CentOS. My config file /etc/sysconfig/pgbouncer-exporter looks:
OPTIONS="--web.listen-address ':9127'"
DATABASE_URL="postgres://postgres:mypassword@127.0.0.1:6432/pgbouncer?sslmode=disable"
pgbouncer-exporter.service is active (running):
pgbouncer-exporter.service - PgBouncer Exporter
Loaded: loaded (/usr/lib/systemd/system/pgbouncer-exporter.service; enabled; vendor preset: disabled)
Active: active (running) since Wed 2020-03-25 11:31:26 CET; 1s ago
Main PID: 25603 (pgbouncer_expor)
CGroup: /system.slice/pgbouncer-exporter.service
└─25603 /usr/sbin/pgbouncer_exporter --web.listen-address :9127 server
Started PgBouncer Exporter.
But I'm getting error message in logs:
level=error msg="unable to get store result: unable to get stats: missing destination name total_xact_count in *[]store.stat" source="exporter.go:229"
It's interesting, because I able connect to pgbouncer:
psql -U postgres -h 127.0.0.1 -p 6432 pgbouncer
Password for user postgres:
psql (12.2, server 1.12.0/bouncer)
Type "help" for help.
Command "show stats" display for me stats and I see total_xact_count
pgbouncer=# show stats;
database | total_xact_count | total_query_count | total_received | total_sent | total_xact_time | total_query_time | total_wait_time | avg_xact_count | avg_query_count | avg_recv | avg_sent | avg_xact_time | avg_query_time | avg_wait_time
-----------+------------------+-------------------+----------------+------------+-----------------+------------------+-----------------+----------------+-----------------+----------+----------+---------------+----------------+---------------
pgbouncer | 3 | 3 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
(1 row)
Where is the problem? Why pgbouncer_exporter can't get stats?
Thanks.