v0.7.0 PG 17 & Pgbouncer 1.23

Changelog

• PostgreSQL 17 Metrics Support by @Vonng
• Pgbouncer 1.23 Metrics Support by @Vonng
• pg_exporter: predicate queries feature by @ringerc
• Do a clean build in the dockerfile by @ringerc by @ringerc
• pg_exporter: don't panic after "bind: address already in use" by @ringerc
• pg_exporter: fix /stat endpoint formatting by @ringerc
• pg_exporter: omit default query properties on yaml export by @ringerc
• Exclude template DBs from discovery and schema-qualify discovery query by @ringerc
• Fix some typos and some metric description mistakes by @ringerc
• Switch from unmaintained lib/pq driver to pgx with stdlib wrapper by @ringerc (Reverted)
• Increase Caller Skip Depth by One Layer by @ulysseskk

MD5 (pg-exporter_0.7.0_amd64.deb) = ea50a845ab73d1fc59093aa48db15c33
MD5 (pg-exporter_0.7.0_arm64.deb) = 5359ed0cd4b967dcb7f1f4bf294379ab
MD5 (pg_exporter-0.7.0-1.aarch64.rpm) = 9c82c4a785bcb6cb8c3284adcab368f7
MD5 (pg_exporter-0.7.0-1.x86_64.rpm) = 65f59ea66b105e8de6adafaa3a007e2e
MD5 (pg_exporter-v0.7.0.darwin-amd64.tar.gz) = d0b99e25d2b7369d9491133022a8f70b
MD5 (pg_exporter-v0.7.0.darwin-arm64.tar.gz) = 74a6b9e372f60e0cd8f3ed71ee370a13
MD5 (pg_exporter-v0.7.0.linux-amd64.tar.gz) = b6edd60e265cee0efa7c0eb076e53761
MD5 (pg_exporter-v0.7.0.linux-arm64.tar.gz) = a22c2c76a17393e03516ad5bed02d530

v0.6.1 Security FIX

• Bump golang.org/x/net from 0.10.0 to 0.17.0 #36
• Fix connect-timeout propagation #37 by mouchar
• Recognize the files with yml suffix in config directory #34 by japinli

Checksums:

MD5 (pg_exporter-v0.6.1.darwin-amd64.tar.gz) = 107a67ca74b1d6e7bbe773694a48f6ab
MD5 (pg_exporter-v0.6.1.darwin-arm64.tar.gz) = 75b57566838c38092a9c45531c031561
MD5 (pg_exporter-v0.6.1.linux-amd64.tar.gz) = 9e55128671b31dd28d6bca3d0429de8f
MD5 (pg_exporter-v0.6.1.linux-arm64.tar.gz) = 68a8b9537f6deb1773d8bea9182bd613
MD5 (pg-exporter_0.6.1_amd64.deb) = 0b0cd62c59cab6d1ab8772d820e599db
MD5 (pg-exporter_0.6.1_arm64.deb) = 947126150b71081d0592d7f1fce0aaac
MD5 (pg_exporter-0.6.1-1.aarch64.rpm) = 6a3608b965143441a5921d3017318146
MD5 (pg_exporter-0.6.1-1.x86_64.rpm) = b3c9f2edd28810cae81cd0edad9eae5d

v0.6.0 (pg16, TLS, arm64, deb)

• Security Enhancement: Fix security dependent bot issue
• Add pg16 collectors
• Add arm64 & aarch64 packages
• Remove the monitor schema requirement for pg_query collectors (you have to ensure it with search_path or just install pg_stat_statements in the default public schema)
• Recognize the files with yml suffix in config directory, thanks to @japinli
• Fix pgbouncer version parsing message level from info to debug
• Fix pg_table_10_12 collector missing relid issue.

v0.5.0 Release

Exporter Enhancement

• Build rpm & deb with nfpm
• Add column.default, replace when metric value is NULL
• Add column.scale, multiply scale factor when metric value is float/int (e.g µs to second)
• Fix /stat endpoint output
• Add docker container vonng/pg_exporter

Metrics Collector

• scale bgwriter & pg_wal time unit to second
• remove pg_class collector and move it to pg_table & pg_inex
• add pg_class metrics to pg_table
• add pg_class metrics to pg_index
• enable pg_table_size by default
• scale pg_query pg_db pg_bgwriter pg_ssl pgbouncer_stat time metrics to second

MD5 (pg_exporter-0.5.0.x86_64.rpm) = f9f3454803bd17d81b94c7c04a21601a
MD5 (pg_exporter_0.5.0_amd64.deb) = 08bd7674a089082cff38fcb55f496390
MD5 (pg_exporter_v0.5.0_darwin-amd64.tar.gz) = c0b5b26222950c66d888dc18cff49231
MD5 (pg_exporter_v0.5.0_linux-amd64.tar.gz) = 9865182fc12387a21775982ca59eef47

v0.4.1 Support pgbouncer v1.16

• update default collectors
  • omit citus & timescaledb schemas on object monitoring
  • avoid duplicate pg_statio tuples
  • support pgbouncer v1.16
  • bug fix: pg_repl collector overlap on pg 12
• new parameter: -T connect-timeout PG_EXPORTER_CONNECT_TIMEOUT
  this can be useful when monitoring remote postgres instance.
• now pg_exporter.yaml are renamed as pg_exporter.yml in rpm package.

v0.4.0 Released

• Add PG 14 support
• Default metrics configuration overhaul. (BUT you can still use old configuration)
• add auto-discovery , include-database and exclude-database option
• Add multiple database monitoring implementation (with auto-discovery = on)

v0.3.2 Fix Issues

• fix shadow DSN corner case
• fix typo
• fix document

v0.3.1 minor release

fix default configuration problems (especially for version lower than 13)

• setting primary_conninfo not exists until PG13
• add funcid label to pg_func to avoid func name duplicate label
• fix version string to pg_exporter

v0.3.0 PG 13 support

• Change default configuration, Support PostgreSQL 13 new metrics (pg_slru, pg_shmem, pg_query13,pg_backup, etc...)
• Add a series new REST API for health / recovery status check
• Add a dummy server with fake pg_up 0 metric which serve before PgExporter is initialized.
• Add sslmode=disable to URL if sslmode is not given
• fix typo and bugs

v0.2.0

- v0.2.0
- add yum package and linux service definition
- add a 'skip' flag into query config
- fix `pgbouncer_up` metrics
- add conf reload support