Failed to fetch metric data

[AnDBAIdewe]

After upgrading a db from PG14 to 15, I get the following error in PgWatch:
2023/08/07 07:51:55 ERRO MetricGathererLoop: Failed to fetch metric data for [an_dev_an_dev:db_stats]: pq: function pg_backup_start_time() does not exist

DB is PostgreSQL 15.2
pgwatch-t01 ~]# docker ps -a
IMAGE
cybertec/pgwatch2:1.10.0

According to the doc, this version should work for PG15? It looks like the PG14 metrics are still being used.

[pashagolub]

According to the PostgreSQL chagelog:

Remove long-deprecated exclusive backup mode (David Steele, Nathan Bossart)
If the database server stops abruptly while in this mode, the server could fail to start. The non-exclusive backup mode is considered superior for all purposes. Functions pg_start_backup()/pg_stop_backup() have been renamed to pg_backup_start()/pg_backup_stop(), and the functions pg_backup_start_time() and pg_is_in_backup() have been removed.

You need to update your metrics definition as well.

[AnDBAIdewe]

Thanks! Works now. System engineer who did the upgrade forgot to read the full doc ;-)

[pashagolub]

Haha! Classic! :-D