Secondary node configuration files

Edit the configuration files on the Secondary server, as required. To edit the postgresql.conf file:

1. Go to C:\Program Files\PostgreSQL\14\data, and open the postgresql.conf file.
2. In the file, edit the following configuration parameters:
   • wal_keep_segments = 3000
   • hot_standby = on

To edit recovery.conf file:

1. Go to C:\Program Files\PostgreSQL\14\data, and create a new recovery.conf file.
2. In the file, edit the following recovery configuration parameter:
   • standby_mode = 'on'
   • primary_conninfo = 'host = <Primary node ip> port = 5432 user = postgres password = <password>
   • recovery_target_timeline = 'latest'
   • trigger_file = 'C:\temp\primary_down.txt'