Crunchy Postgres for Kubernetes 5.5.x Release notes

Release notes for each of the 5.5.x releases.

Component versions

Crunchy Postgres
for Kubernetes		PostgrespgBackRestpgbouncerPatronipgadmin
5.5.116.22.491.213.1.24.30, 7.8
5.5.016.12.471.213.1.14.30, 7.8

Postgres extension versions

Crunchy Postgres for Kubernetes versionPostGISpgRoutingpgauditpg_cronpg_partmanpgnodemxset_userwal2jsonTimescaleDBorafcepgvector
5.5.12.5.9 (earliest)
3.4.0 (latest)		2.6.3 (earliest)
3.4.2 (latest)		1.4.3 (earliest)
16.0 (latest)		1.6.25.0.11.64.0.12.52.13.04.9.10.6.0
5.5.02.4.10 (earliest)
3.4.0 (latest)		2.6.3 (earliest)
3.4.2 (latest)		1.3.4 (earliest)
16.0 (latest)		1.6.05.0.01.64.0.12.52.12.24.7.00.5.1

A bold version number indicates that the component version was updated in latest release.

5.5.1

Fixes

  • Only load datasource.pgbackrest.configuration when performing a cloud based restore.
  • Queue an event based on instance Patroni ‘master’ role change
  • The pgAdmin controller now owns any objects it creates
  • pgAdmin can now be accessed from Kubernetes networks by default
  • Allow numeric characters in pgAdmin config settings. Contributed by Roman Gherta (@rgherta).

Changes

  • PostgreSQL versions 16.2, 15.6, 14.11, 13.14, and 12.18 are now available.
  • pgBackRest is now at version 2.49.
  • patroni is now at version 3.1.2.
  • pgMonitor is now at version 4.11.
  • The orafce extension is now at version 4.9.1.
  • The pg_cron extension is now at version 1.6.2.
  • The pg_partman extension is now at version 5.0.1 for PG 16, 15 and 14.
  • The pgvector extension is now at version 0.6.0.
  • The TimescaleDB extension is now available for PG 16. The extension is at version 2.13.0 for PG 16, 15, 14, and 13.

5.5.0

Features

  • The monitoring stack has undergone a number of significant improvements in 5.5, including:
    • Transitioning the crunchy-postgres-exporter image into a component container, thereby decoupling it from the postgres-operator.
    • The ability to append custom exporter queries to the default queries provided by Crunchy Postgres for Kubernetes.
    • You can now monitor your standby clusters by editing the ccp_monitoring password.
    • Postgres 16 support!
  • We added a new API for pgAdmin 4, which allows you to create a single pgAdmin 4 to manage multiple clusters in a namespace! This new API also comes with a new image containing the latest version of pgAdmin 4.

Changes

  • When specified, the citus extension is loaded before other shared_preload_libraries.
  • You can reduce metrics to those provided by pgMonitor by setting the postgres-operator.crunchydata.com/postgres-exporter-collectors annotation to None.
  • PostgreSQL versions 16.1, 15.5, 14.10, 13.13, 12.17, and 11.22 are now available.
  • As of February, 2023, public builds will offer the latest PG 16 and 15.
  • pgBouncer is now at version 1.21.0.
  • The orafce extension is now at version 4.7.0.
  • The pg_partman extension is now at version 5.0.0 for PG 16, 15 and 14.
  • The pgAudit16 extension is now at version 16.0.
  • The pgvector extension is now at version 0.5.1.
  • The TimescaleDB extension now at version 2.12.2 for PG 15, 14 and 13, version 2.11.2 for PG 12 and version 2.3.1 for PG 11.
  • DNS names for the replica service have been added to the certificates generated for the PostgresCluster to facilitate TLS connections between pgBouncer and read replicas. Contributed by Scott Zelenka (@szelenka)