v1.14.0

Warning

🚨pgwatch2 is in maintenance mode, accepting only bug fixes.
Check out the pgwatch v3 for new features and enhancements!

What's Changed

• [+] bump go.mod dependencies by @pashagolub in #828
• [+] bump shirou/gopsutil/v3 from 3.24.4 to 3.24.5 by @dependabot in #791
• [+] bump prometheus/client_golang from 1.20.3 to 1.20.5 by @dependabot in #824
• [+] bump prometheus/client_golang from 1.20.1 to 1.20.3 by @dependabot in #815
• [+] bump prometheus/client_golang from 1.20.0 to 1.20.1 by @dependabot in #810
• [+] bump prometheus/client_golang from 1.19.1 to 1.20.0 by @dependabot in #809
• [+] bump jessevdk/go-flags from 1.5.0 to 1.6.1 by @dependabot in #795
• [+] bump hashicorp/consul/api from 1.29.2 to 1.30.0 by @dependabot in #825
• [+] bump hashicorp/consul/api from 1.29.1 to 1.29.2 by @dependabot in #802
• [+] bump hashicorp/consul/api from 1.28.3 to 1.29.1 by @dependabot in #789
• [+] bump goreleaser/goreleaser-action from 5 to 6 by @dependabot in #793
• [+] bump golang.org/x/crypto from 0.26.0 to 0.27.0 by @dependabot in #816
• [+] bump golang.org/x/crypto from 0.25.0 to 0.26.0 by @dependabot in #807
• [+] bump golang.org/x/crypto from 0.24.0 to 0.25.0 by @dependabot in #800
• [+] bump golang.org/x/crypto from 0.23.0 to 0.24.0 by @dependabot in #792
• [+] bump go.etcd.io/etcd/client/v2 from 2.305.14 to 2.305.15 by @dependabot in #806
• [+] bump go.etcd.io/etcd/client/v2 from 2.305.13 to 2.305.14 by @dependabot in #790
• [*] update preparing_databases.rst by @MichalBartos in #803

New Contributors

• @MichalBartos made their first contribution in #803

Full Changelog: v1.13.0...v1.14.0

v1.13.0

What's Changed

• [!] bump Go to v1.22 by @pashagolub in #787
• [+] bump shopspring/decimal from 1.3.1 to 1.4.0 by @dependabot in #765
• [+] bump shirou/gopsutil/v3 from 3.23.11 to 3.24.4 by @dependabot in #730 #737 #747 #762 #773
• [+] bump prometheus/client_golang from 1.18.0 to 1.19.1 by @dependabot in #745 #777
• [+] bump jmoiron/sqlx from 1.3.5 to 1.4.0 by @dependabot in #767
• [+] bump hashicorp/consul/api from 1.26.1 to 1.28.3 by @dependabot in #734 #780 #748 #746
• [+] bump google.golang.org/protobuf from 1.32.0 to 1.33.0 by @dependabot in #753
• [+] bump golang.org/x/crypto from 0.17.0 to 0.23.0 by @dependabot in #731 #775 #763 #749 #743 #740
• [+] bump go.etcd.io/etcd/client/v2 from 2.305.11 to 2.305.13 by @dependabot in #736 #761
• [+] allow setting arbitrary configs to the webui pod by @alexmozejko in #754
• [+] add usename to replication metric, closes #751 by @pashagolub in #778
• [+] add pgwatch2-scalefield Docker image by @yanchenko-igor in #732
• [+] add pgbouncer_clients metric by @AndrewJackson2020 in #774
• [*] optimize Scalefield image and enable async mode for prometheus by @ermajn in #785
• [*] move chart templates to cybertec-postgresql/pgwatch2-charts by @pashagolub in #756
• [*] move ansible playbooks to cybertec-postgresql/pgwatch2-charts by @pashagolub in #758
• [*] change nasty warning into debug message, closes #764 by @pashagolub in #784
• [-] fix warning about yaml.load() is deprecated, closes #738 by @AndrewJackson2020 in #739
• [-] fix typo in documentation by @AndrewJackson2020 in #744
• [-] fix replication slots metrics for replica instances by @marcelorauldiaz in #768
• [-] fix FREEZE age for partitioned tables in table_stats, fixes #760 by @pashagolub in #783
• [-] fix broken logo links in Grafana dashboards, fixes #770 by @pashagolub in #779
• [-] fix readthedocs deployment by @pashagolub in #757
• [-] change StatActivity dashboard identifier value to null, closes #741 by @jcarnu in #742

New Contributors

• @AndrewJackson2020 made their first contribution in #739
• @jcarnu made their first contribution in #742
• @alexmozejko made their first contribution in #754
• @ermajn made their first contribution in #785

Full Changelog: v1.12.0...v1.13.0

v1.12.0

What's Changed

• [!] bump Go to v1.21 by @pashagolub in #729
• [!] update "Biggest relations treemap" dashboard plugin, fixes #579 #496 #293 #197 by @pashagolub in #727
• [+] add sent_lag and confirmed_flush_lsn_lag fields to replication metrics by @bukem in #700
• [+] add new metrics for invalid and unused indexes by @kmoppel-cognite in #691
• [+] bump actions/checkout from 3 to 4 by @dependabot in #680
• [+] bump actions/setup-go from 4 to 5 by @dependabot in #721
• [+] bump actions/stale from 8 to 9 by @dependabot in #723
• [+] bump docker/setup-buildx-action from 2 to 3 by @dependabot in #684
• [+] bump docker/setup-qemu-action from 2 to 3 by @dependabot in #683
• [+] bump github/codeql-action from 2 to 3 by @dependabot in #724
• [+] bump go.etcd.io/etcd/client/v2 from 2.305.9 to 2.305.11 by @dependabot in #704 #722
• [+] bump golang.org/x/crypto from 0.12.0 to 0.17.0 by @dependabot in #681 #697 #708 #715 #726
• [+] bump goreleaser/goreleaser-action from 4 to 5 by @dependabot in #685
• [+] bump hashicorp/consul/api from 1.24.0 to 1.26.1 by @dependabot in #686 #688 #706
• [+] bump prometheus/client_golang from 1.16.0 to 1.18.0 by @dependabot in #692 #728
• [+] bump shirou/gopsutil/v3 from 3.23.7 to 3.23.11 by @dependabot in #678 #693 #705 #718

New Contributors

• @bukem made their first contribution in #700

Full Changelog: v1.11.0...v1.12.0

v1.11.0

What's Changed

• [!] bump PostgreSQL to v15, Grafana to v8.5.20, Go to v1.20 in Docker images by @pashagolub in #601
• [!] add metrics for PostgreSQL 16 by @kmoppel-cognite in #669
• [+] add support for Goreleaser v1.20 by @pashagolub in #676
• [+] update README.md to show support of PG15 by @kdaveid in #664
• [+] bump Go to v1.20 by @pashagolub in #605
• [+] bump shirou/gopsutil/v3 from 3.22.12 to 3.23.7 by @dependabot in #667 #662 #648 #635 #615 #593
• [+] bump prometheus/client_golang from 1.14.0 to 1.16.0 by @dependabot in #654 #636 #627
• [+] bump lib/pq from 1.10.7 to 1.10.9 by @dependabot in #633 #628
• [+] bump hashicorp/consul/api from 1.18.0 to 1.24.0 by @dependabot in #670 #666 #661 #651 #617 #609
• [+] bump golang.org/x/crypto from 0.5.0 to 0.12.0 by @dependabot in #671 #663 #653 #638 #624 #616 #596
• [+] bump go.etcd.io/etcd/client/v2 from 2.305.7 to 2.305.9 by @dependabot in #640 #626 #591
• [+] bump actions/stale from 7 to 8 by @dependabot in #619
• [+] bump actions/setup-go from 3 to 4 by @dependabot in #618
• [+] allow to specify multi-host connection string for configDB with target_session_attrs by @krisavi in #647
• [+] allow .pgpass lookup for web UI by @krisavi in #646
• [+] add lag in milliseconds to replication metrics by @kmoppel-cognite in #607
• [+] add Docker GHA workflow to update "latest" images, closes #602 by @pashagolub in #603
• [+] add "prerequisite extensions" support for metric definitions by @kmoppel-cognite in #643
• [*] fix cert_key to key_file on host_config by @krisavi in #608
• [-] fix timeline ID conversion in wal metric from hexadecimal to decimal by @slardiere in #604
• [-] fix invalid target_session_attrs value in WebUI URI, fixes #674 by @pashagolub in #675
• [-] fix helm chart affinity, toleration, nodeSelector and extraVolumes for daemon container by @pmpetit in #631
• [-] fix grafana v8 invalid url parameter panelId with new viewPanel by @FireEmerald in #620
• [-] fix dashboard typos by @AlicjaKucharczyk in #668
• [-] fix connection string parsing for postgres-continuous-discovery, closes #584 by @chromko in #585
• [-] fix pgwatch2-postgres Docker image by @frastr in #606
• [-] fix "invalid command 'BEGIN READ WRITE'" error when '--conn-pooling' option is on by @IlyaTsoi in #586
• [-] ensure bootstrap of a timescale metrics db includes necessary metric-time function by @dtmdl in #592
• [-] add pgwatch2-webui target to the Release GHA workflow, fixes #597 by @pashagolub in #598

New Contributors

• @krisavi made their first contribution in #608
• @chromko made their first contribution in #585
• @FireEmerald made their first contribution in #620
• @kdaveid made their first contribution in #664
• @AlicjaKucharczyk made their first contribution in #668

Full Changelog: v1.10.0...v1.11.0

v1.10.0

What's Changed

• [!] add Postgres v15 support by @kmoppel-cognite in #489
• [!] bump Go packages versions by @pashagolub in #570
• [!] bump Golang to 1.19, closes #538 by @pashagolub in #539
• [!] provide ARM docker images, closes #502 by @pashagolub in #534
• [*] allow only local repo PRs test docker builds by @pashagolub in #530
• [*] change output message in helpers functions, closes #553 by @pmpetit in #572
• [*] deprecate Influx docker images in Release GHA workflow, closes #544 by @pashagolub in #558
• [*] metrics: add "wal.timeline" column to be able to detect failovers by @kmoppel-cognite in #488
• [*] remove trailing space for SQL commands for non-Postgres DB types by @slardiere in #571
• [*] use ENV var in GHA instead of deprecated set-output command, fixes #522 by @pashagolub in #533
• [*] сleanup pgbackrest helper function by @ants in #512
• [+] add GHA workflow to build Docker image for each PR, closes #528 by @pashagolub in #529
• [+] add helm chart by @yanchenko-igor in #490
• [+] add helm chart first version by @yanchenko-igor in #477
• [+] add metric and dashboard for bloated indexes and tables by @marcelorauldiaz in #518
• [+] add new stat activity grid report by @pmpetit in #521
• [+] bump actions/stale from 4 to 6 by @dependabot in #562
• [+] bump elgohr/Publish-Docker-Github-Action from 4 to 5 by @dependabot in #561
• [+] bump github/codeql-action from 1 to 2 by @dependabot in #559
• [+] bump goreleaser/goreleaser-action from 3 to 4 by @dependabot in #560
• [+] make unique dbname maintenance less costly for multi-daemon setups, fixes #525 by @kmoppel-cognite in #573
• [+] postgres backend implemented by @yanchenko-igor in #483
• [+] some fixes and improvements for helm chart by @yanchenko-igor in #486
• [+] use predefined Grafana dashboards uid, fixes #474 by @pashagolub in #480
• [-] check Docker user name for PR images by @pashagolub in #531
• [-] fix Invalid command SET lock_timeout... error, fixes #507 by @IlyaTsoi in #527
• [-] fix PW2_DATASTORE environment variable in pgwatch2-webui.service by @jsoler in #484
• [-] fix table_bloat_approx_summary_sql when tblpages = 0, closes #491 by @dtmdl in #547
• [-] fix tag_semver in the Release workflow, closes #471 by @pashagolub in #472
• [-] fix executing queries on standby databases with pooling, fixes #520 by @pashagolub in #551
• [-] fix goreleaser "field empty_folders not found..." error, closes #541 by @pashagolub #542
• [-] fix pgpool dbtype monitoring failure for multi statement queries, fixes #498 by @palmalcheg in #499
• [-] fix pgpool mode to execute only "non empty" queries by @palmalcheg in #501
• [-] fix typo error by @frastr in #519
• [-] typo fixed by @yanchenko-igor in #548

New Contributors

• @jsoler made their first contribution in #484
• @palmalcheg made their first contribution in #499
• @frastr made their first contribution in #519
• @marcelorauldiaz made their first contribution in #518
• @ants made their first contribution in #512
• @IlyaTsoi made their first contribution in #527
• @dtmdl made their first contribution in #547
• @dependabot made their first contribution in #561

Full Changelog: v1.9.0...v1.10.0

v1.9.0

What's Changed

• upgrade to Go 1.17, closes #440 by @pashagolub in #441
• Grafana updated to the latest version by @yanchenko-igor in #428
• bigger upstream merge batch by @kmoppel-cognite in #431
• Prometheus mode optimization by @kmoppel-cognite in #401
• metrics: add new metrics for the upcoming Postgres v14 release. by @kmoppel-cognite in #399
• metrics: also skip tables just waiting for AccessExclusiveLock by @eshkinkot in #404
• fix file descriptors leak, fix race conditions in opening and closing database pool by @eshkinkot in #411
• gatherer: improve variable expansion in YAML configs by @kmoppel-cognite in #414
• gatherer: add a new --min-db-size-mb flag to ignore empty DBs by @kmoppel-cognite in #402
• gatherer: full redesign of connection pooling, relying on sqlx.DB by @kmoppel-cognite in #418
• daemon: introduce a 5s connect timeout on opening Postgres connections by @kmoppel-cognite in #419
• add Aiven as a cloud provider offering managed PostgreSQL by @carobme in #421
• give possibility to add an extra container by @pmpetit in #429
• add release GitHub Action by @pashagolub in #437
• fix incorrect conversion between integer types, fixes #438 by @pashagolub in #439
• add docker job to the Release workflow, closes #446 by @pashagolub in #448
• improve release action for beta versions by @pashagolub in #450
• Gatherer: remove unused port parameter from StartPrometheusExporter(), fixes #407 by @pashagolub in #455
• add action to close Stale Issues and PRs by @pashagolub in #456
• make stale label lower cased by @pashagolub in #457
• fix CVE-2021-3121: "improper Input Validation in GoGo Protobuf" by @pashagolub in #467
• fix get_table_bloat_approx_sql() when tblpages = 0, closes #464 by @pashagolub in #468
• bump elgohr/Publish-Docker-Github-Action to v4, closes #469 by @pashagolub in #470

New Contributors

• @kmoppel-cognite made their first contribution in #401
• @carobme made their first contribution in #421
• @yanchenko-igor made their first contribution in #428

Full Changelog: v1.8.5...v1.9.0

v1.8.5

See the list of major changes here.

NB! No schema migration diffs to be applied for older Config DB based installations.

NB2! For file-based DEB / RPM installations starting from this release also metric definitions are considered as config files to avoid transparently overriding custom metric changes done by user. Thus when upgrading you might get quite many annoying confirmation dialogs. If you're sure that you have not changed anything then one can bypass them by: a) using some force flag like --force-confnew with dpkg b) purging the older package version c) deleting the /etc/pgwatch2/metrics/ contents. In the first two cases make sure though to back up the monitored instances configuration file, located at /etc/pgwatch2/config/instances.yaml by default.

v1.8.4

See list of major changes here.

v1.8.3

There is only 1 change in this minor release compared to the previous v1.8.2, fixing hopefully finally the issue with unnecessary internal worker restarts, causing much higher storage usage on the metrics DB.

NB! Please do not use the v1.8.2 version!!!

v1.8.2

See list of major changes here.

This release added 1 SQL diff to be applied to Config DB based setups to support the new optional Patroni "namespace discovery" feature.

Also it is always highly recommended to refresh the metric definitions separately if using a config DB based setup.