Deploy PgBouncer

Please follow the Tutorial to deploy the charm on LXD.

Short story for your Ubuntu 22.04 LTS:

sudo snap install multipass
multipass launch --cpus 4 --memory 8G --disk 30G --name my-vm charm-dev # tune CPU/RAM/HDD accordingly to your needs
multipass shell my-vm

juju add-model postgresql
juju deploy postgresql --channel 14/stable
juju deploy pgbouncer --channel 1/stable
juju integrate postgresql pgbouncer
juju status --watch 1s

The expected result:

Model        Controller  Cloud/Region         Version  SLA          Timestamp
welcome-lxd  lxd         localhost/localhost  3.1.6    unsupported  21:12:27+02:00

App         Version  Status   Scale  Charm       Channel    Rev  Exposed  Message
pgbouncer            unknown      0  pgbouncer   1/stable    76  no       
postgresql  14.9     active       1  postgresql  14/stable  336  no       

Unit            Workload  Agent  Machine  Public address  Ports     Message
postgresql/18*  active    idle   25       10.3.217.224    5432/tcp  

Machine  State    Address       Inst id         Base          AZ  Message
25       started  10.3.217.224  juju-d483b7-25  ubuntu@22.04      Running

Check the Testing reference to test your deployment.