You can use the following procedure for base backups:
- Identify your master and standby nodes, and ensure that they have been configured according to the Replication best practices recipe.
- Configure replication security. Create or confirm the existence of the replication user on the master node:
CREATE USER repuser REPLICATION LOGIN CONNECTION LIMIT 2 ENCRYPTED PASSWORD 'changeme';
- Allow the replication user to authenticate. The following example allows access from any IP address using MD5-encrypted password authentication; you may wish to consider other options. Add the following line to pg_hba.conf:
host replication repuser 0.0.0.1/0 md5
- Set the logging options in postgresql.conf on both the master and the standby so that ...