Setting up hot streaming replication

In this recipe, we are going to set up a master/slave streaming replication.

Getting ready

For this exercise, you need two Linux machines each with the latest version of PostgreSQL 9.6 installed. We will be using the following IP addresses for master and slave servers:

• Master IP address: 192.168.0.4

• Slave IP address: 192.168.0.5

How to do it...

The following steps show you how to set up master/slave streaming replication:

1. Set up password-less authentication between master and slave for the Postgres user.

2. First, we are going to create a user ID on the master, which will be used by the slave server to connect to the PostgreSQL database on the master server:

           psql -c "CREATE USER repuser REPLICATION LOGIN ENCRYPTED 
           PASSWORD 'charlie';"
   

3. The next step is to allow the replication user that was created in the previous step to allow access to the master Postgresql server.

   This is done by making the necessary changes as in the pg_hba.conf file:

     ...