Modern PostgreSQL charm

Modern PostgreSQL charms are Ops charms released in the Charmhub channels 14/ and 16/.

Both modern charms provide the database endpoint for the postgresql_client interface.

PostgreSQL 14 (track 14/) additionally provides db and db-admin endpoints for the legacy pgsql interface, and supports migration from the legacy charm.

PostgreSQL 16 (track 16/) does not provide legacy endpoints.

Note

You are currently viewing the documentation for Charmed PostgreSQL 14.

To switch between versions, use the small rectangular menu at the bottom right corner of the page.

PostgreSQL 16

Latest stable version with active feature development.

• Base: Ubuntu 24.04 LTS (Noble)

• Supported architectures: amd64, arm64

• Channel: 16/stable (latest development available for testing in 16/edge)

• Juju version: Requires Juju 3.6+ LTS

• Support status: Active development and full support

New features

• Juju spaces - Enhanced networking capabilities for complex deployment scenarios

• Juju user secrets - Secure management of the charm’s internal passwords

• Improved security hardening - Enhanced security posture and best practices

• TLS v4 library migration

  • New endpoints client-certificates and peer-certificates

  • Endpoint peer-interfaces uses TLS by default

  • See all endpoints on Charmhub

• Timescale Community Edition replaces Timescale Apache 2

• Improved built-in roles - Enhanced role-based access control system

• New refresh process for in-place upgrades

Deprecated or removed

Important changes to keep in mind when migrating from 14 to 16:

• Legacy interface psql - Endpoints db and db-admin are no longer supported

  • See for current supported interfaces

• Support for Juju < v3.6 removed

  • Charmed PostgreSQL 16 requires Juju 3.6+ LTS due to Juju secrets support

• Juju actions get-password and set-password removed

  • Replaced by Juju secrets for enhanced security

• Timescale Apache 2 edition replaced

  • Now uses Timescale Community edition

• Charm action set-tls-private-key removed

  • Will be re-introduced as Juju User Secrets in future releases

• Charm actions renamed for consistency:

  • pre-upgrade-check → pre-refresh-check

  • resume-upgrade → resume-refresh

  • Changes align with juju refresh terminology

• Charm endpoint certificates split into separate endpoints:

  • client-certificates - For client certificate management

  • peer-certificates - For peer-to-peer certificate management

For detailed information about PostgreSQL 16 features, see the PostgreSQL 16 releases page

PostgreSQL 14

Maintenance mode with bug fixes and security updates only.

• Base: Ubuntu 22.04 LTS (Jammy)

• Supported architectures: amd64, arm64

• Channel: 14/stable

• Juju version: Partially compatible with older Juju versions down to 2.9

• Support status: 🔧 Bug fixes and security updates only

Features

• Deployment on multiple cloud services, including Sunbeam, MAAS, AWS, GCE, and Azure

• Juju storage - Flexible storage configuration options

• Back up and restore, including point-in-time recovery

• COS integration - Enable observability tools like Grafana, Loki, Tempo, and Parca

• TLS integration

• LDAP integration - Centralised authentication for PostgreSQL clusters

• amd64 and arm64architecture support

For detailed information about all PostgreSQL 14 releases, see the Releases page.

Choosing a version

Version	Support Status	Base	Juju Version	Key Features
PostgreSQL 16	Active development	Ubuntu 24.04 LTS	3.6+ LTS	Modern features, enhanced security, Juju Spaces
PostgreSQL 14	🔧 Maintenance mode	Ubuntu 22.04 LTS	2.9+	Core database features, stable platform
Legacy	Deprecated	Older base	Legacy versions	Not recommended

• For new deployments: Use PostgreSQL 16 for the latest features and long-term support

• For existing PostgreSQL 14 deployments: Continue using PostgreSQL 14 or plan migration to 16

• For legacy charm users: Migrate to PostgreSQL 14 as soon as possible