Utilising a master/slave (hot-standby) setup to provide a resilience layer at database level can be easy. The following assumes you have 2 PgSQL hosts at 10.10.50.1 and 10.10.50.2, both running Ubuntu 14.04 LTS and PostgreSQL 9.4 (9.4.5).
1. On the master 10.10.50.1, edit the following in postgresql.conf:
listen_addresses = '*'
wal_level = hot_standby
max_wal_senders = 3
listen_addresses can also be scoped down to single or multiple server bound IP addresses, for added security/best practice
Read On… ->