Charmed PostgreSQL VM
- Canonical
- Databases
Channel | Revision | Published | Runs on |
---|---|---|---|
latest/stable | 345 | 09 Nov 2023 | |
latest/stable | 239 | 09 Feb 2022 | |
latest/stable | 226 | 01 Apr 2021 | |
14/stable | 468 | 11 Sep 2024 | |
14/stable | 467 | 11 Sep 2024 | |
14/candidate | 468 | 02 Sep 2024 | |
14/candidate | 467 | 02 Sep 2024 | |
14/beta | 516 | 19 Nov 2024 | |
14/beta | 515 | 19 Nov 2024 | |
14/edge | 520 | 22 Nov 2024 | |
14/edge | 519 | 22 Nov 2024 |
juju deploy postgresql --channel 14/stable
Deploy universal operators easily with Juju, the Universal Operator Lifecycle Manager.
Platform:
22.04
20.04
18.04
16.04
14.04
How to deploy on LXD
This guide assumes you have a running Juju and LXD environment.
For a detailed walkthrough of setting up an environment and deploying the charm on LXD, refer to the Tutorial.
Prerequisites
- Canonical LXD 5.12+
- Fulfil the general system requirements
Bootstrap a juju controller and create a model if you haven’t already:
juju bootstrap localhost <controller name>
juju add-model <model name>
Deploy PostgreSQL:
juju deploy postgresql
See the
juju deploy
documentation for all available options at deploy time.See the Configurations tab for specific PostgreSQL parameters.
Sample output of juju status --watch 1s
:
Model Controller Cloud/Region Version SLA Timestamp
postgresql overlord localhost/localhost 2.9.42 unsupported 09:41:53+01:00
App Version Status Scale Charm Channel Rev Exposed Message
postgresql active 1 postgresql 14/stable 281 no
Unit Workload Agent Machine Public address Ports Message
postgresql/0* active idle 0 10.89.49.129
Machine State Address Inst id Series AZ Message
0 started 10.89.49.129 juju-a8a31d-0 jammy Running
If you expect having several concurrent connections frequently, it is highly recommended to deploy PgBouncer alongside PostgreSQL. For more information, read our explanation about Connection pooling.