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

[Kevin Nasto]

Removed pgbouncer, added postgres plugins, updated ppa to 24.04

Manual testing instructions:

(Note this is the one with pgbouncer removed)

Make sure landscape server runs and new dashboard

Connect a client to it and make sure things look good

Take a look at the landscape logs and make sure no max connections errors

The postgres logs are here /var/snap/charmed-postgresql/common/var/log/postgresql

Try any tests to try to break things

c7b5535... by Kevin Nasto on 2024-07-16

Added back postgresql relation

08c1b52... by Kevin Nasto on 2024-07-16

Fix bad rev

[Mitch Burton (mitchburton)]

review: Approve

Unmerged commits

08c1b52... by Kevin Nasto on 2024-07-16

Fix bad rev

c7b5535... by Kevin Nasto on 2024-07-16

Added back postgresql relation

44aff91... by Kevin Nasto on 2024-07-16

Updated postgres charm but removed pgbouncer

ec35d0c... by Kevin Nasto on 2024-07-15

Fixed issues with charm bundle

b676f1e... by Kevin Nasto on 2024-07-12

Added pgbouncer, added postgres plugins, updated ppa to 24.04

diff --git a/bundle.yaml b/bundle.yaml
index 9be28db..68ff865 100644
--- a/bundle.yaml
+++ b/bundle.yaml
@@ -17,18 +17,23 @@ applications:
   landscape-server:
     charm: ch:landscape-server
     channel: stable
-    revision: 107
+    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: 429
     num_units: 1
     options:
-      extra_packages: python*-apt postgresql-contrib postgresql-.*-debversion postgresql-plpython.*
-      max_connections: 500
-      max_prepared_transactions: 500
+      plugin_plpython3u_enable: true
+      plugin_ltree_enable: true
+      plugin_intarray_enable: true
+      plugin_debversion_enable: true
+      plugin_pg_trgm_enable: true
+      experimental_max_connections: 500
     constraints: mem=2048
   rabbitmq-server:
     charm: ch:rabbitmq-server