Charmed PostgreSQL How to | Deploy on LXD

charm
, ,
1

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

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.