Error when running the postgres exporter with postgres 17

[cipherself]

What's wrong?

postgres 17 removed the checkpoints_timed column from pg_stat_pgwriter causing the following error

alloy  | ts=2025-01-11T23:43:24.476671414Z level=error msg="collector failed" component_path=/ component_id=prometheus.exporter.postgres.dbname name=stat_bgwriter duration_seconds=0.005531275 err="pq: column \"checkpoints_timed\" does not exist

Apparently this has been fixed on the master branch of postgres-exporter prometheus-community/postgres_exporter#1072 but still hasn't been released.

Steps to reproduce

1. Run a postgres 17 database
2. Configure alloy to scrap metrics from it

System information

Linux 6.1.0-25-amd64

Software version

v1.5.1

Configuration

prometheus.exporter.postgres "testdb" {
  data_source_names = ["postgresql://monitoring:monitoring@db:5432/testdb?sslmode=disable"]
}

prometheus.scrape "testdb" {
  targets    = prometheus.exporter.postgres.testdb.targets
}

Logs

alloy  | ts=2025-01-11T23:43:24.476671414Z level=error msg="collector failed" component_path=/ component_id=prometheus.exporter.postgres.dbname name=stat_bgwriter duration_seconds=0.005531275 err="pq: column \"checkpoints_timed\" does not exist