Reference > Release Notes > All revisions > Revision 462/463

Revision 462/463

Canonical’s newest Charmed PostgreSQL K8s operator has been published in the [14/stable channel].

Due to the newly added support for arm64 architecture, the PostgreSQL charm now releases multiple revisions simultaneously:

• Revision is built for amd64 on Ubuntu 22.04 LTS
• Revision is built for arm64 on Ubuntu 22.04 LTS

See also: How to perform a minor upgrade

Contents

• Highlights
• Features and improvements
• Bugfixes and maintenance
• Known limitations
• Requirements and compatibility
  • Packaging

Highlights

• Timeline Management (PR #716) (DPE-5581)
• Add pgAudit (PR #688) (DPE-5116)
• postgresql.conf hardening (PR #702) (DPE-5511)
• Integrate with Tempo HA + test relay support of tracing traffic through grafana-agent-k8s (PR #725)
• Polish COS dashboard (PR #733) (DPE-4469)
• Update COS alert rules (PR #727) (DPE-5658)
• S3 improvements (PR #750)

Features and improvements

• Remove patching of private ops class. (PR #692)
• Add check for low storage space on pgdata volume (PR #685) (DPE-5301)
• Re-enable log forwarding (PR #671)
• Avoid replication slot deletion (PR #680) (DPE-3887)
• CC006 compliance (PR #737) (DPE-5627)
• Add pgBackRest logrotate configuration (PR #722) (DPE-5600)
• Grants priviledges to non-public schemas (PR #742) (DPE-5387)
• Add TLS flag + CA to relation databag (PR #719) (DPE-5484)
• Add warning logs to Patroni reinitialisation (PR #753) (DPE-5712)
• Reduce pgdate permissions (PR #759) (DPE-5915)
• Split off new interface client app tests (PR #761)
• Temporarily disable log forwarding (PR #757)
• Change owner of functions, procedures and aggregates (PR #773)
• Only update tls flags on leader (PR #770)
• Preload shared libs on normal PG start (PR #774) (DPE-6033)

Bugfixes and maintenance

• Fixes for PITR backup test instabilities (PR #690)
• Early exit on missing s3 rel (PR #762) (DPE-5934)
• Fix connection rejection rule in pg_hba.conf (PR #751) (DPE-5689)

Known limitations

…

Requirements and compatibility

This charm revision features the following changes in dependencies: …

See the system requirements for more details about Juju versions and other software and hardware prerequisites.

Integration tests

Below are some of the charm integrations tested with this revision on different Juju environments and architectures:

• Juju v.2.9.51 on amd64
• Juju v.3.4.6 on amd64 and arm64

Software	Revision	Tested on
postgresql-test-app	rev 279
	rev 278
data-integrator	rev 41
	rev 40
s3-integrator	rev 77
	rev 78
tls-certificates-operator	rev 22
self-signed-certificates	rev 155
	rev 205
mattermost-k8s	rev 27
indico	rev 233
redis-k8s	rev 7
	rev 38
discourse-k8s	rev 173

Packaging

This charm is based on the Charmed PostgreSQL K8s [ROCK ]. It packages:

• postgresql v.14.13
• pgbouncer v.1.21
• patroni v.3.1.2
• pgBackRest v.2.53
• prometheus-postgres-exporter v.0.12.1