Merge ~silverdrake11/landscape-bundles:scalable_stable_update_postgres into landscape-bundles:scalable-stable

[Kevin Nasto]

Updated stable bundle to latest revision most notable postgres

Manual testing instructions:

juju add-model testbundle
charmcraft pack
juju deploy ./landscape-scalable.zip

juju status
Then go to the haproxy ip address and make sure landscape is working properly

[Spencer Runde (spencerrunde)]

Why are we dropping the `options` section? I can see that the config values default to 100 and 0 in the postgres unit for max_connections and max_prepared_transactions, at least.

If you'd like to verify:

juju ssh postgresql/0
sudo vim /var/snap/charmed-postgresql/common/var/lib/postgresql/postgresql.conf

review: Needs Information

[Kevin Nasto (silverdrake11)]

The new postgres charm doesn't support those options

[Spencer Runde (spencerrunde)]

Ah ok. Looks like the postgres charm is doing HA management with patroni... Can't say I'm terribly familiar with it, but my main concern was that setting max_prepared_transactions to 0 would disable them, which would disable two-phase commit and therefore HA/multiple databases. Patroni seems to be dedicated to simplifying HA, so I trust that this config is taken care of as the units scale.

LGTM

review: Approve

diff --git a/bundle.yaml b/bundle.yaml
index 6742acc..4ca2a29 100644
--- a/bundle.yaml
+++ b/bundle.yaml
@@ -5,7 +5,7 @@ docs: https://discourse.charmhub.io/t/landscape-charm-bundles/10638
 applications:
   haproxy:
     charm: ch:haproxy
-    channel: stable
+    channel: latest/stable
     revision: 75
     num_units: 1
     expose: true
@@ -16,19 +16,17 @@ applications:
       ssl_cert: SELFSIGNED
   landscape-server:
     charm: ch:landscape-server
-    channel: stable
-    revision: 107
+    channel: latest/stable
+    revision: 111
     num_units: 1
     constraints: mem=4096
+    options:
+      landscape_ppa: ppa:landscape/self-hosted-24.04
   postgresql:
     charm: ch:postgresql
-    channel: latest/stable
-    revision: 345
+    channel: 14/stable
+    revision: 363
     num_units: 1
-    options:
-      extra_packages: python*-apt postgresql-contrib postgresql-.*-debversion postgresql-plpython.*
-      max_connections: 500
-      max_prepared_transactions: 500
     constraints: mem=2048
   rabbitmq-server:
     charm: ch:rabbitmq-server