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 9d28846af48431ffd362b705c3bcd12c6e605fda..f4e7635f2a05b96e328b70e1ad458a12b0644e57 100644 (file)
--- 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'
+  }
 }