Configuring replication and recovery settings

1. In the replica's postgresql.conf file, add details for communicating with the primary server. If you are using streaming replication, the application_name in primary_conninfo should be the same as the name used in the primary's synchronous_standby_names settings:

2. Add details to mirror the configuration of the primary database. If you are using asynchronous replication, use these settings:

The hot_standby parameter must be set to on to allow read-only queries on the replica. In Postgres 10 and later, this setting is on by default.

1. Restart Postgres to pick up the changes.