Mastering PostgreSQL 12 - Third Edition

Configuring the pg_hba.conf file

Now that the postgresql.conf file has been configured successfully, it is necessary to configure the pg_hba.conf file for streaming. Note that this is only necessary if we are planning to use pg_basebackup, which is the state-of-the-art tool for creating base backups.

Basically, the options we have in the pg_hba.conf file are the same ones that we already saw in Chapter 8, Managing PostgreSQL Security. There is just one major issue to keep in mind:

# Allow replication connections from localhost, by a user with the# replication privilege.local   replication   postgres                  trusthost    replication   postgres   127.0.0.1/32   trusthost    replication   postgres   ::1/128        trust

We can define standard pg_hba.conf file rules. The important ...