Migrate discourse to postgresql

diff --git a/nixops/modules/databases/default.nix b/nixops/modules/databases/default.nix
index d86373ade13f9fe71d02db895856ca2125ba8842..695069d1a2a83564fc2cfd78a4f36df07728f973 100644 (file)
--- a/nixops/modules/databases/default.nix
+++ b/nixops/modules/databases/default.nix
@@ -105,7 +105,8 @@ in {
       extraConfig = ''
         max_connections = 100
         wal_level = logical
-        shared_buffers = 128MB
+        shared_buffers = 512MB
+        work_mem = 10MB
         max_wal_size = 1GB
         min_wal_size = 80MB
         log_timezone = 'Europe/Paris'
@@ -123,6 +124,7 @@ in {
       authentication = ''
         local  all     postgres                                ident
         local  all     all                                     md5
+        hostssl        discourse       discourse       all                             md5
         hostssl        all     all             all                     pam
         hostssl        replication     backup-1        2001:41d0:302:1100::9:e5a9/128  pam pamservice=postgresql_replication
         hostssl        replication     backup-1        54.37.151.137/32                pam pamservice=postgresql_replication