For this demonstration, we will need another server or virtual machine to receive a copy of our database. Have one ready to follow along. We will also be using a PostgreSQL tool named pg_basebackup. Check the PostgreSQL documentation regarding this utility for more information.
If the donor server is configured as described in the Configuration - getting it right the first time recipe, modify its pg_hba.conf file and add the following line:
host replication rep_user 0/0 md5
Then, create a user to control replication with this SQL query issued as a superuser:
CREATE USER rep_user WITH PASSWORD 'rep_test' REPLICATION;
Then, reload the server to activate the configuration line. If you are attempting this in a real production ...
