May 2018
Intermediate to advanced
576 pages
30h 25m
English
Hot Standby is usable with the following:
For the first two replication mechanisms, you will need to configure replication as described in earlier recipes. In addition, you will need to configure the following parameters:
On the master, set the following in postgresql.conf:
wal_level = ‘replica’ # PostgreSQL 9.6 and above, else hot_standby
On the standby, set the following in postgresql.conf:
hot_standby = on
Both of those settings are now the default in PostgreSQL 10. In earlier versions you will need to make these changes. You will need to do a clean restart of the database server on the master. ...