Reference > Release Notes > All revisions > Revision 517/518

Revision 517/518

Canonical’s newest Charmed PostgreSQL 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
  • Integration tests
  • Packaging

Highlights

• Timeline Management (PR #629) (DPE-5561)
• Add pgAudit (PR #612) (DPE-5248)
• postgresql.conf hardening (PR #621) (DPE-5512)
• Integrate with Tempo HA + relay tracing traffic through grafana-agent (PR #640)
• polish cos dashboard (PR #646)
• Update COS alert rules (PR #651) (DPE-5658)
• S3 Improvements (PR #642)

Features and improvements

• Split PITR backup test in AWS and GCP (PR #605) (DPE-5181)
• Remove patching of private ops class. (PR #617)
• [MISC] Use more meaningful group naming for multi-group tests (PR #625)
• Ignore alias error in case alias is already existing (PR #637)
• Stop tracking channel for held snaps (PR #638)
• tf module on charm (PR #643)
• Add pgBackRest logrotate configuration (PR #645) (DPE-5601)
• Grants priviledges to non-public schemas (PR #647) (DPE-5387)
• add tls and tls-ca fields to databag (PR #666)
• Merge update_tls_flag into update_endpoints (PR #669)
• Quote tox.ini repository paths (PR #678) (DPE-6042)
• Add microceph (local backup) integration test + bump snap version (PR #633) (DPE-5386)

Bugfixes and maintenance

• Add warning logs to Patroni reinitialisation (PR #660)

• Fix lib check (PR #627)

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 281
	rev 279
	rev 280
	rev 278
data-integrator	rev 41
	rev 40
nextcloud	rev 26
s3-integrator	rev 77
	rev 78
tls-certificates-operator	rev 22
self-signed-certificates	rev 155
	rev 205
mailman3-core	rev 18
landscape-client	rev 70
ubuntu-advantage	rev 137
	rev 139

See the /lib/charms directory on GitHub for details about all supported libraries.

See the metadata.yaml file on GitHub for a full list of supported interfaces.

Packaging

This charm is based on the Charmed PostgreSQL [snap Revision ]. 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