X-Git-Url: https://git.immae.eu/?a=blobdiff_plain;f=nixops%2Fmodules%2Fdatabases%2Fdefault.nix;fp=nixops%2Fmodules%2Fdatabases%2Fdefault.nix;h=695069d1a2a83564fc2cfd78a4f36df07728f973;hb=609c29615905e2bc5628a164cea2c28ec70d5d35;hp=d86373ade13f9fe71d02db895856ca2125ba8842;hpb=9d8d1425de8a3ff6c1a275e74667c6fdaf9fa626;p=perso%2FImmae%2FConfig%2FNix.git 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