postgresql

Charmed PostgreSQL VM

Channel Revision Published Runs on
latest/stable 345 09 Nov 2023
Ubuntu 22.04 Ubuntu 20.04 Ubuntu 18.04 Ubuntu 16.04 Ubuntu 14.04
latest/stable 239 09 Feb 2022
Ubuntu 22.04 Ubuntu 20.04 Ubuntu 18.04 Ubuntu 16.04 Ubuntu 14.04
latest/stable 226 01 Apr 2021
Ubuntu 22.04 Ubuntu 20.04 Ubuntu 18.04 Ubuntu 16.04 Ubuntu 14.04
14/stable 553 04 Feb 2025
Ubuntu 22.04
14/stable 552 04 Feb 2025
Ubuntu 22.04
14/candidate 553 28 Jan 2025
Ubuntu 22.04
14/candidate 552 28 Jan 2025
Ubuntu 22.04
14/beta 553 28 Jan 2025
Ubuntu 22.04
14/beta 552 28 Jan 2025
Ubuntu 22.04
14/edge 567 Today
Ubuntu 22.04
14/edge 566 Today
Ubuntu 22.04
16/edge 527 27 Nov 2024
Ubuntu 24.04
16/edge 526 27 Nov 2024
Ubuntu 24.04
juju deploy postgresql --channel 14/stable
Show information

Platform:

Ubuntu
24.04 22.04 20.04 18.04 16.04 14.04

Upgrade

Currently, the charm supports PostgreSQL major version 14 only. Therefore, in-place upgrades/rollbacks are not possible for major versions.

Note: Canonical is not planning to support in-place upgrades for major version change. The new PostgreSQL charm will have to be installed nearby, and the data will be copied from the old to the new installation. After announcing the next PostgreSQL major version support, the appropriate documentation for data migration will be published.

For instructions on carrying out minor version upgrades, see the following guides:

  • Minor upgrade, e.g. PostgreSQL 14.8 → PostgreSQL 14.9
    (including charm revision bump 42 → 43).
  • Minor rollback, e.g. PostgreSQL 14.9 → PostgreSQL 14.8
    (including charm revision return 43 → 42).