Recovery from Primary failure

If the Primary server fails, execute the following steps on the Standby node:

1. Take standby Postgres service down. (Postgresql-X64-14).
2. On Standby Node – Move C:\Program Files\Postgresql\14\Data\Postgresql.conf, Pg_Hba.conf, Recovery.conf to C:\Program Files\Postgresql\14\Standby_Bkp.
3. Copy C:\Program Files\Postgresql\14\Primary_Bkp\Postgres.Sql, Pg_Hba files From Primary_Bkp folder which are backup file from Primary Node.
4. Start Standby Node Postgresql-X64-14 Service.
5. Check recovery Status: Select pg_is _in_recovery. If it is “t” it is in read-only mode and if it is “f” it is in read-write mode. It should show status “f”.
6. Start ActiveMQ service on secondary server.
7. Start Tomcat service on secondary server and agents of DR site.
8. Assign all workflows to respective agents.