PostgreSQL 12 High Availability Cookbook - Third Edition

How to do it...

Assuming 192.168.1.10 is our donor server, follow these steps to create a copy:

1. Connect to the new server as the postgres user.
2. Issue the following command to copy data from the donor system:

pg_basebackup -U rep_user -h 192.168.1.10 -D /path/to/database

3. If using PostgreSQL 11 or earlier, create a file named recovery.conf in /path/to/database with the following content:

standby_mode = 'on' 
primary_conninfo = 'host=192.168.1.10 port=5432 user=rep_user' 

4. For PostgreSQL 12 or later, create a file named standby.signal in /path/to/database, and then add the following line to postgresql.conf directly:

primary_conninfo = 'host=192.168.1.10 port=5432 user=rep_user' 

5. Create a file named .pgpass in the home directory of the ...