Charmed PostgreSQL Reference | Charm channels / PostgreSQL versions

[taurus (Alex Lutay)]

PostgreSQL major versions

Charmed PostgreSQL is shipped in following tracks:

• PostgreSQL 16 (channel 16/candidate)
• PostgreSQL 14 (channel 14/stable)
• Legacy PostgreSQL charm (channel latest/stable) → deprecated

This includes two major PostgreSQL versions, 14 and 16, matching Ubuntu versioning for PostgreSQL.

PostgreSQL 16

PostgreSQL 16 is shipped in track 16 and is available for testing in the channel 16/candidate.

It is built for Noble (Ubuntu 24.04) on arm64 and amd64.

Supported features

• LDAP integration (also supported by PostgreSQL 14)
• SoS report integration (also supported by PostgreSQL 14)
• Recovery improvements (also supported by PostgreSQL 14)
  • All members are sync nodes now
  • Switchover to dedicated unit via promote-to-primary
  • Raft re-init helper: juju run ... promote-to-primary scope=unit force=yes
• Juju user secrets for system password rotation
• Timescale Community Edition
• Extended COS integration
  • Profiling via Parca
  • Tracing via Tempo
• Improved security hardening
• (WIP) Multiple Juju storages support
• (WIP) Juju Spaces
• (WIP) Refresh v3 lib support
• (WIP) Improved built-in roles

See the detailed features list on the release notes page.

Deprecated

• Legacy interface psql (endpoints db and db-admin).
  • See more about supported interfaces in Interfaces and endpoints.
• Support for Juju < v3.6
  • Charmed PostgreSQL 16 requires Juju 3.6+ LTS due to Juju secrets support.
• Juju actions get-password and set-password.
  • For security reasons, these actions are replaced by Juju secrets.
• Timescape Apache 2 edition has been replaced by Timescape Community edition

PostgreSQL 14

PostgreSQL 14 is shipped in track 14 and available for production in the channel 14/stable.

Base: Jammy (Ubuntu 22.04)

Supported architectures: arm64 and amd64.

Supported features

• Deployment on multiple cloud services
• Backup and restore
  • Including point-in-time recovery (PITR)
• COS integration
• TLS integration
• LDAP integration
• arm64 architecture

See the detailed features list on the release notes page.

Deprecated

• Features that are new to Charmed PostgreSQL 16 are not backwards compatible with 14
• Charmed PostgreSQL 14 ships Timescape Apache 2 edition only.

Legacy PostgreSQL charm

The legacy charm in the track latest has been deprecated and is not supported. It is still available here for the historical and comparative reasons only.

Please use the supported tracks of the modern charm: 14/ and 16/.

Learn more in the legacy charm explanation page.