Crunchy Postgres for Kubernetes 5.6.x Release notes

Release notes for each of the 5.6.x releases.

Component versions

Postgres extension versions

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

5.6.4

Changes

• Continue when Postgres restore intentionally exits early multiple times
• Always pass a --jobs argument to pg_upgrade
• Patroni is now at version 3.3.5.
• pgBackrest is now at version 2.54.0
• pgAdmin is now at version 8.14.
• orafce is now at version 4.14.0.
• pgvector is now at version 0.8.0.
• The Timescaledb extension is at version 2.17.2 for PG 17, 16, 15, and 14.

5.6.3

Features

• The operator emits a warning event when a postgrescluster is using a major version of Postgres that is no longer receiving updates

Changes

• PostgreSQL versions 16.6, 15.10, 14.15, 13.18, and 12.22 are now available.
• Patroni is now at version 3.3.4.

Fixes

• The CrunchyBridgeCluster.spec.secret field is now required.

5.6.2

Features

• You can now easily enable or disable CPK feature gates via values.yaml settings when installing CPK via Helm. Contributed by Daniel Holmes (@jaitaiwan)

Changes

• PostGIS version 3.4.3 is now available.
• Patroni is now at version 3.3.3.
• pgBackrest is now at version 2.53.1.
• pgBouncer is now at version 1.23.1.
• pgMonitor is now at version 5.1.1.
• pgAdmin is now at version 8.12.
• The pg_cron extension is now at version 1.6.4.
• The pgvector extension is now at version 0.7.4.
• The pgnodemx extension is now at version 1.7.
• The TimescaleDB extension is at version 2.17.0 for PG 17, 16, 15, and 14.
• pgAdmin and pgBackRest images have tar as required by the kubectl cp command.
• The AutoCreateUserSchema feature gate now defaults to true.

Fixes

• The externalTrafficPolicy is now properly configured for the primary, replica, PgBouncer and pgAdmin Services.
• Standalone pgAdmin failed in certain ARM environments

5.6.1

Features

• Use the postgres-operator.crunchydata.com/autoCreateUserSchema=true annotation to automatically create a schema for any Postgres users defined via spec.users.  With this setting enabled, CPK creates a writable schema for each user (avoiding the PUBLIC schema, which Postgres 15 secured against unintended writes).

Changes

• PostgreSQL versions 16.4, 15.8, 14.13, 13.16, and 12.20 are now available.
• The pgvector extension is now at version 0.7.3.
• The orafce extension is now at version 4.10.3.
• The TimescaleDB extension is at version 2.15.3 for PG 16, 15, and 14.
  • When migrating from Timescale DB 2.14.x, you must run this SQL script after you run ALTER EXTENSION. For more details, see the following pull request #6797.

5.6.0

Features

• Configure your PostgresCluster to automatically expand Postgres data volume when additional database storage is needed.
• pgAdmin updates
  • Enable TLS for pgAdmin deployments using custom TLS certificates.
  • Use Postgres as the backend for pgAdmin deployments.
  • Have PGO reconcile a pgAdmin Service by defining a service name in your PGAdmin spec.
  • Select a PostgresCluster by name in your PGAdmin spec.
  • Manage pgAdmin users via the PGAdmin spec
• Set passwords declaratively for users defined under spec.user.
• Configure the service type for the Postgres replica service.
• Provision Crunchy Bridge clusters using the new CrunchyBridgeCluster API.

Changes

• SeccompProfile is now set to RuntimeDefault in all Pods.
• The PGAdmin API now utilizes Gunicorn as the web server for any pgAdmin deployments.
• Attempts to use the PASSWORD option in spec.users.options will be rejected.

Fixes

• StatefulSets (pgAdmin and pgBackRest repo hosts) will now recover from a bad rollout.
• Various spelling fixes. Contributed by Josh Soref (@jsoref)