PostgreSQL major versions¶

Charmed PostgreSQL is available in multiple versions to support different deployment requirements and lifecycle stages. It is shipped in the following tracks:

Charm name	Charmhub channel	Type	Status
PostgreSQL 16	`16/stable`	modern	Latest version - new features are released here
PostgreSQL 14	`14/stable`	modern	In maintenance mode - bug fixes and security updates only
Legacy PostgreSQL charm	`latest/stable`	legacy	Deprecated

Legacy vs. modern¶

There are two generations of charms stored under the same charm name postgresql. In these docs, we refer to them as “legacy” and “modern”.

Legacy charm (deprecated): Also known as a Reactive charm. Found in the Charmhub channel latest/stable.; Provided db and db-admin endpoints for the pgsql interface.
Modern charm: Also known as an Ops charm. Found in the Charmhub channels 14/stable and 16/stable.; 14/stable provides legacy endpoints and new database endpoint for the postgresql_client interface.; 16/stable does not provide legacy endpoints - only the new database database endpoint for the postgresql_client interface.