Skip to main content

Your submission was sent successfully! Close

Thank you for signing up for our newsletter!
In these regular emails you will find the latest updates from Canonical and upcoming events where you can meet our team.Close

Thank you for contacting us. A member of our team will be in touch shortly. Close

Charm channels / PostgreSQL versions

Charmed PostgreSQL is being shipped using the following tracks with two major PostgreSQL versions 14 and 16 (matching Ubuntu versioning for PostgreSQL):

PostgreSQL 16

PostgreSQL 16 has been shipped in track 16 and available for testing in the channel 16/candidate. The main features are:

  • All features of PostgreSQL 14 (except the deprecation list below)
  • Noble based charm: 24.04
  • Multiple Juju Storages support (WIP)
  • Juju User Secrets support for system password rotation
  • Supports LDAP integration (also released to PG14)
  • Juju Spaces support (WIP)
  • Timescale Community edition support
  • Refresh v3 lib support (WIP VM)
  • Improved built-in Roles (WIP)
  • Released slim PostgreSQL SNAP
  • Extended COS with:
  • Improved hardening
  • PgBouncer/[email protected] included!
  • SoS report integrated (also supports PG14)
  • Recovery improvements (also released to PG14):
    • 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

See the detailed features list on the release notes page.

Deprecation:

  • PostgreSQL 16 does NOT support legacy interfaces pgsql (endpoints db and db-admin). Please migrate to the modern interface postgresql_client.
  • Juju 3.6+ LTS is required (as Juju 2.9 LTS does NOT support Juju Secrets).
  • For the improved security reasons, Charmed PostgreSQL 16+ does NOT ship get-password/set-password actions anymore. Please use Juju User Secrets instead.
  • Charmed PostgreSQL 16 ships Timescape Community edition only.

PostgreSQL 14

PostgreSQL 14 has been shipped in track 14 and available for production in the channel 14/stable. The main features are:

See the detailed features list on the release notes page.

Deprecation:

  • Charmed PostgreSQL 14 is in LTS mode therefor all new features are being added to PostgreSQL 16 charm only.
  • Charmed PostgreSQL 14 ships Timescape Apache 2 edition only.

Legacy PostgreSQL charm

Warning: the legacy charm in the track latest has been deprecated and not supported! It is still available here for the historical/backward comparability reasons only. Please use supported track of the modern charm.

Please read more about the legacy charm on the dedicated page.

Previous Releases Next System requirements

Last updated 2 hours ago. Help improve this document in the forum.