From: Felix Dörre Date: Thu, 14 Dec 2017 21:46:14 +0000 (+0100) Subject: fix: replication needs max_wal_senders X-Git-Url: https://code.wpia.club/?p=infra.git;a=commitdiff_plain;h=e7cfad3ebfe5d251e3e9c9d5cc231ad2bd29e908 fix: replication needs max_wal_senders This is necessary for the initial backup (using pg_basebackup), which connects to the postgres server and receives the Write-Ahead Log while it is created, so the server needs to have at least one session available for this. See also the pg_basebackup documentation [1]. [1]: https://www.postgresql.org/docs/9.6/static/app-pgbasebackup.html Change-Id: I953e2731df2f5b7dc71ae27191cd20318e36b84a --- diff --git a/environments/production/manifests/postgres-primary.pp b/environments/production/manifests/postgres-primary.pp index 9d28846..f4e7635 100644 --- a/environments/production/manifests/postgres-primary.pp +++ b/environments/production/manifests/postgres-primary.pp @@ -81,4 +81,8 @@ node postgres-primary { target => '/etc/postgresql/9.6/main/postgresql.conf', value => 'replica' } + postgresql_conf{'max_wal_senders': + target => '/etc/postgresql/9.6/main/postgresql.conf', + value => '2' + } }