From 609c29615905e2bc5628a164cea2c28ec70d5d35 Mon Sep 17 00:00:00 2001 From: =?UTF-8?q?Isma=C3=ABl=20Bouya?= Date: Wed, 6 Feb 2019 23:57:19 +0100 Subject: Migrate discourse to postgresql --- nixops/modules/databases/default.nix | 4 +++- 1 file changed, 3 insertions(+), 1 deletion(-) 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 -- cgit v1.2.3