Install postgresql-9.3-pgpool2
sudo -u postgres psql -c "CREATE USER replicator REPLICATION LOGIN ENCRYPTED PASSWORD 'replicator';"
create extension pgpool_regclass; CREATE EXTENSION pgpool_recovery; \df
listen_address = "*" wal_level = hot_standby max_wal_senders = 3 checkpoint_segments = 8 wal_keep_segments = 8
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