Charmed PostgreSQL K8s Reference | PostgreSQL versions

[avgomes (Andreia Velasco)]

PostgreSQL versions

Charmed PostgreSQL K8s 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 for K8s is shipped in track 16 and is available for testing in the channel 16/candidate.

Released alongside PgBouncer K8s and Data Integrator for Ubuntu 24.04

Base: Noble (Ubuntu 24.04)

Supported architectures: arm64 and amd64.

Supported features

• LDAP integration (also supported by PostgreSQL 14)

• Juju user secrets for internal charm password rotation

• Extended COS integration
  • Tracing via Tempo
• Improved security hardening

• (WIP) Improved built-in roles

Read more about Charmed PostgreSQL 16 features in the release notes.

Deprecated / removed

• 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.
• Timescale Apache 2 edition has been replaced by Timescale 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

Read more about Charmed PostgreSQL 14 features in the release notes.

Deprecated

• The track 14 is in bug-fixing/support mode. New Charmed PostgreSQL 16 features will NOT be backported to track 14.
• Charmed PostgreSQL 14 ships Timescale 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.