Protecting a PostgreSQL Database (Active Node)

Create a PostgreSQL Resource Hierarchy

It is assumed that the PostgreSQL service has stopped on both the active and the standby node at the beginning of this section. (It should be stopped when the previous section is completed.)

1. Log in to the active node (SIOS20-NODE1) with SIOS20-AD\lkadmin.

2. Launch the LifeKeeper GUI and login with SIOS20-AD\lkadmin.

3. Make all resources active on SIOS20-NODE1.

4. Start the PowerShell for administrators and execute the following command to start the PostgreSQL service.
   Check the service.
   

   PS > Get-Service postgre*
   

   
   Stop the service.
   

   PS > Start-Service -Name <postgre_service_name>
   

5. From the menu bar, click Edit > Server > Create Resource Hierarchy and follow the prompts to enter the details following tables.

Create PostgreSQL Resource Dependencies

1. Log in to the Windows OS on the active node (SIOS20-NODE1) as SIOS20-AD\lkadmin.

2. Launch the LifeKeeper GUI and log in as SIOS20-AD\lkadmin.

3. Generate dependencies on the PostgreSQL resource and the IP resource. From the menu bar, click Edit > Resource > Add Dependency and follow the prompts to enter the details following the table.

4. The resource hierarchy has been created as follows. Note that the IP address and volume resources are children of the parent resource “pgsql-5432”.
   

Creating Dependency between LB Health Check Resource and PostgreSQL Resource

1. Log in to the Windows OS on the active node (SIOS20-NODE1) as SIOS20-AD\lkadmin.

2. Launch the LifeKeeper GUI and log in as SIOS20-AD\lkadmin.

3. Generate dependencies on Gen-LB and pgsql-5432. From the menu bar, click Edit > Resource > Add Dependency and follow the prompts to enter the details following the table.

4. The resource hierarchy has been created as follows.