PostgreSQL replication 9.3+

Install postgresql-9.3-pgpool2

create_role.bash

sudo -u postgres psql -c "CREATE USER replicator REPLICATION LOGIN ENCRYPTED PASSWORD 'replicator';"

create extension pgpool_regclass;
CREATE EXTENSION pgpool_recovery;
\df 
 

postgresql.conf

listen_address = "*"
wal_level = hot_standby
max_wal_senders = 3
checkpoint_segments = 8    
wal_keep_segments = 8 

pg_hba.conf

hostssl replication     replicator      192.168.3.1/8           md5
# line below is for pgpool2
host all all 192.168.3.1/8 trust

wal_level = hot_standby
max_wal_senders = 3
checkpoint_segments = 8    
wal_keep_segments = 8 
hot_standby = on

sudo service postgresql stop
sudo -u postgres rm -rf /var/lib/postgresql/9.3/main
sudo -u postgres pg_basebackup -h 192.168.3.11 -D /var/lib/postgresql/9.3/main -U replicator -v -P
## Writing recovery.conf file
sudo -u postgres bash -c "cat > /var/lib/postgresql/9.3/main/recovery.conf <<- _EOF1_
  standby_mode = 'on'
  primary_conninfo = 'host=192.168.3.11 port=5432 user=replicator password=replicator sslmode=require'
  trigger_file = '/tmp/postgresql.trigger'
_EOF1_
"
sudo service postgresql start

install pgpool2 package