Cluster chart's logical replication query is only valid on Postgres >= 17

[nkgilley]

If you use a Postgres version < 17 the logical replication query fails since the worker_type column was added to pg_stat_subscription in Postgres 17.

[dosubot]

This is a valid issue. The logical replication monitoring query in charts/cluster/templates/monitoring-logical-replication.yaml directly selects worker_type from pg_stat_subscription without any PostgreSQL version guard. That column was indeed added in PostgreSQL 17, so the query will fail on earlier versions.

Additionally, the query also references pg_stat_subscription_stats (introduced in PG 15) and apply_error_count/sync_error_count, which further narrows compatibility.

There's currently no version-conditional logic in the template. A fix could involve either:

• Adding a version check (e.g., using pg_catalog.version() or a Helm value) to conditionally include worker_type
• Splitting the query into version-specific variants gated by a template condition on the PostgreSQL major version

PR #829 addresses other pg_stat_subscription catalog issues in the logical replication runbooks but doesn't cover worker_type.

To reply, just mention @dosu.

---

Share context across your team and agents. Try Dosu.