Migrate discourse to postgresql

1 files changed, 3 insertions, 1 deletions

diff --git a/nixops/modules/databases/default.nix b/nixops/modules/databases/default.nix
index d86373a..695069d 100644
--- 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