IBM Security Identity Governance and Intelligence, Version 5.2.3.1

Recovering from a Postgres database failure

If the master Postgres database fails, use this failover procedure to recover your system.

About this task

Although you can promote the slave Postgres database on a secondary node to the role of master, you cannot perform the master database management functions. You must either restore master Postgres database on the primary node or promote the secondary node to primary to use these management functions.

Procedure

Promote the slave database to be the master database.
1. Ensure that the master database is stopped on the primary node.
2. On the secondary node, click Configure > Postgres Management.
3. Select the slave database and click Manage > Promote.
4. Click Yes to confirm that you want to promote the database to master.
The role of the Postgres database on the secondary node is now master and the role of the database on the primary node is slave. Both databases are started as well as replication.
Restore the master database on the primary node.
1. On the secondary node, click Configure > Postgres Management.
2. Select the master database and click Stop.
3. On the primary node, click Configure > Postgres Management.
4. Select the slave database and click Manage > Promote.
5. Click Yes to confirm that you want to promote the database to master.
The role of the Postgres database on the primary node is now master and the role of the database on the secondary node is slave. Both databases are started as well as replication.

Results

The master Postgres database is restored on the primary server and the appropriate Manage options are active.