From e7cfad3ebfe5d251e3e9c9d5cc231ad2bd29e908 Mon Sep 17 00:00:00 2001 From: =?utf8?q?Felix=20D=C3=B6rre?= Date: Thu, 14 Dec 2017 22:46:14 +0100 Subject: [PATCH] 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 --- environments/production/manifests/postgres-primary.pp | 4 ++++ 1 file changed, 4 insertions(+) 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' + } } -- 2.39.2