Charmed PostgreSQL Reference | Requirements

System requirements

The following are the minimum software and hardware requirements to run Charmed PostgreSQL on VM.

Software

  • Ubuntu 22.04 (Jammy) or later.

Juju

The charm supports several Juju releases from 2.9 LTS onwards. The table below shows which minor versions of each major Juju release are supported by the stable Charmhub releases of PostgreSQL.

Juju major release Supported minor versions Compatible charm revisions Comment
3.6 LTS 3.6.1+ 552+ 3.6.0 is not recommended, while 3.6.1+ works excellent. Recommended for production!
3.5 3.5.1+ 363+ Known Juju issue in 3.5.0
3.4 3.4.3+ 363+ Know Juju issues with previous minor versions
3.3 3.3.0+ from 363 to 430 No known issues
3.2 3.2.0+ from 363 to 430 No known issues
3.1 3.1.7+ from 336 to 430 Juju secrets were stabilized in 3.1.7
2.9 LTS 2.9.49+ 288+
2.9.32+ from 288 to 430 No tests for older Juju versions.

Hardware

Make sure your machine meets the following requirements:

  • 8GB of RAM.
  • 2 CPU threads.
  • At least 20GB of available storage.

The charm is based on the charmed-postgresql snap. It currently supports:

  • amd64
  • arm64 (from revision 396+)

Contact us if you are interested in a new architecture!

Networking

  • Access to the internet is required for downloading required snaps and charms
  • Only IPv4 is supported at the moment

hi, just confirming it doesn’t work with juju 3.6.2

ubuntu@jolly:~$ juju --version 3.6.2-genericlinux-amd64

juju deploy postgresql --channel 14/stable --to 38 ERROR Charm feature requirements cannot be met:

  • charm requires at least one of the following:
    • charm requires all of the following:
      • charm requires feature “juju” (version < 3.0.0) but model currently supports version 3.5.0
    • charm requires all of the following:
      • charm requires feature “juju” (version < 3.5.0) but model currently supports version 3.5.0
    • charm requires all of the following:
      • charm requires feature “juju” (version >= 3.5.1) but model currently supports version 3.5.0

Feature descriptions:

  • “juju”: the version of Juju used by the model

For additional information please see: https://juju.is/docs/olm/supported-features ERROR failed to deploy charm “postgresql”

Dear @macchese ,

Can you please check/share the Juju Controller and Model versions?

The juju --version reports you Juju CLI version. It looks correct/latest 3.6.2.

The latest Charmed PostgreSQL revision 553 should be well deployable to Juju 3.6.2! (Just re-checked it on my side):

> juju --version
3.6.2-genericlinux-amd64

> juju controllers
Controller  Model  User   Access     Cloud/Region         Models  Nodes    HA  Version
lxd*        test   admin  superuser  localhost/localhost       2      1  none  3.6.2  

> juju add-model macchese
Added 'macchese' model on localhost/localhost with credential 'localhost' for user 'admin'

> juju deploy postgresql --channel 14/stable
Deployed "postgresql" from charm-hub charm "postgresql", revision 553 in channel 14/stable on ubuntu@22.04/stable

> juju status
Model     Controller  Cloud/Region         Version  SLA          Timestamp
macchese  lxd         localhost/localhost  3.6.2    unsupported  16:50:34+01:00

App         Version  Status  Scale  Charm       Channel    Rev  Exposed  Message
postgresql  14.15    active      1  postgresql  14/stable  553  no       Primary

Unit           Workload  Agent      Machine  Public address  Ports     Message
postgresql/0*  active    executing  0        10.142.152.28   5432/tcp  Primary

Machine  State    Address        Inst id        Base          AZ  Message
0        started  10.142.152.28  juju-a329e7-0  ubuntu@22.04      Running

BTW, feel free to contact us in Matrix to have faster conversation in the chat mode.

I have a manual cloud working with a mysql cluster, so I tried to have a postgres one.

juju controllers --refresh

Controller Model User Access Cloud/Region Models Nodes HA Version

invalsi* hub admin superuser 3 13 3 3.5.0

and model here https://paste.ubuntu.com/p/SHKgXYmht3/

So, your controller and model version are 3.5.0 which has known issue indicated in this document:

Known Juju issue in 3.5.0

The current behavior is expected: postgresql-operator/metadata.yaml at main · canonical/postgresql-operator · GitHub

Please consider to refresh on Juju 3.6.1+, as it is an LTS and a way more stable, plus a bit faster.

@avgomes please consider to improve the documentation wording here. Tnx!

thank you a lot, how can I update controller and model to 3.6.1+? could you give me some link?

Hi @macchese ,

I’d recommend starting with this upgrade guide in the Juju docs. :slight_smile:

thank you a lot, I’m thinking to create a new controller and migrate my existing models to it

2 Likes