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.
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.