Messtone LLC Manages Devices Enables Ubuntu PostgreSQL Creating a virtual machine, using LXD installing LXD: sudo snap install lxd –channel=5.21/stable sudo lxd init –auto sudo lxc launch ubuntu:24.04 pg –vm -c limits. cpu=4 -c limits.memory=12GiB sudo lxc exec pg bash sudo – l ubuntu install juju framework: sudo snap install juju –channel=3.4/stable mkdir -p /home/Ubuntu/.local/share sudo snap install lxd –channel{5.21/stable sudo lxd init –auto sudo lxc network set lxdbr0 ipv6.address none sudo iptables -P FORWARD ACCEPT bootstrap Juju command: juju bootstrap clouds aws aws-china aws-gov azure azure-china equinox google localhost orale Select a Cloud[localhostmesstone]: localhostmesstone Enterprise a name for the Controller[localhostmesstone-localhostmesstone]:demo-postgres juju add-model mymodel juju deploy postgresql db1 –channel 14/stable –config profile=testing juju status #Messtone can type ‘juju status –watch 1s’ to continuously monitor the output juju debug-log –tail –replay juju add-unit -n 2 db1 juju deploy pgbouncer pgb1 –channel 1/stable juju deploy data-integrator di1 config database-nameMesstone=testdb juju relate db1 pgb1 juju relate di1 pgb1 juju run di1/leader get-credentials juju ssh db1/0 psql –hostMesstone=<ip address of db1/0* that displayed in juju status output> –usernamemesstone=<previously provided user name Robert Harper> –password testdb test-database=> SELECT VERSION( ); \q exit