community: Increase postgres connections, tweak mem and buffers

[chef.git] / cookbooks / community / templates / default / data.yml.erb

diff --git a/cookbooks/community/templates/default/data.yml.erb b/cookbooks/community/templates/default/data.yml.erb
index f18668e3d9ddfee4d018093ef04c048e4e82d203..c5c59d2884cea75a777babf715a85126d582ed4e 100644 (file)
--- a/cookbooks/community/templates/default/data.yml.erb
+++ b/cookbooks/community/templates/default/data.yml.erb
@@ -3,21 +3,20 @@
 #
 
 templates:
 #
 
 templates:

-  - "templates/postgres.template.yml"
+  - "templates/postgres.13.template.yml" # NOTE UPDATE THE HOOK REPLACE FOR MAX CONNECTIONS BELOW

   - "templates/redis.template.yml"
 
 # any extra arguments for Docker?
 # docker_args:
 
 params:
   - "templates/redis.template.yml"
 
 # any extra arguments for Docker?
 # docker_args:
 
 params:

-  db_default_text_search_config: "pg_catalog.english"
-

   ## Set db_shared_buffers to a max of 25% of the total memory.
   ## will be set automatically by bootstrap based on detected RAM, or you can override
   ## Set db_shared_buffers to a max of 25% of the total memory.
   ## will be set automatically by bootstrap based on detected RAM, or you can override

-  db_shared_buffers: "4096MB"
+  db_shared_buffers: "8192MB"

 
   ## can improve sorting performance, but adds memory usage per-connection
 
   ## can improve sorting performance, but adds memory usage per-connection

-  #db_work_mem: "40MB"
+  db_work_mem: "40MB"
+  db_max_connections: "200"

 
 env:
   # ensure locale exists in container, you may need to install it
 
 env:
   # ensure locale exists in container, you may need to install it


@@ -42,3 +41,16 @@ hooks:
         cmd: su - postgres -c 'psql discourse'
 
         raise_on_fail: false
         cmd: su - postgres -c 'psql discourse'
 
         raise_on_fail: false

+    - file:
+        path: /var/spool/cron/crontabs/postgres
+        contents: |
+          # m h  dom mon dow   command
+          # MAILTO=?
+          0 4 * * * /var/lib/postgresql/take-database-backup
+
+run:
+  # Make sure this matches the postgresql version template above
+  - replace:
+      filename: "/etc/postgresql/13/main/postgresql.conf"
+      from: /#?max_connections *=.*/
+      to: "max_connections = $db_max_connections"