PostgreSQL Connection Confirmation (Client)

Install the PostgreSQL Client

1. Log in to sios20lkclient as SIOS20\lkadmin.
2. Download the PostgreSQL (Windows x86-64) installation image from the following site, place it anywhere, and double-click it to open it. Version 11.7 is used here. This installation image is identical to the one for the PostgreSQL server.

https://www.enterprisedb.com/downloads/postgres-postgresql-downloads

3. Select only the Command Line Tools for installation.
   
   Then follow the prompts to install by default.

Verifying PostgreSQL Client Connectivity

1. Log in to sios20lknode01 or sios20lknode02 as sios20\lkadmin
2. Launch the LifeKeeper GUI and verify that the resource hierarchy is active on sios20lknode01.
   

3. Log in to sios20lkclient as sios20\lkadmin.

4. Open the command prompt and run the following command:

• “\Program Files\PostgreSQL\11\bin\psql” -h 10.20.1.200 -p 5432 -U postgres -l

If you enter your password and see the list of databases, this means everything is working correctly.

5. Then run the following command:

• “\Program Files\PostgreSQL\11\bin\psql” -h 10.20.1.200 -p 5432 -U postgres

Enter the password and run the following internal command:

SELECT inet_server_addr();

The IP address of the server on which PostgreSQL is running will be displayed. It returns 10.20.1.200.

6. Using the LifeKeeper GUI, configure the PostgreSQL resources (as seen below) so that sios20lknode02 is active.

7. Run the command again on sios20lkclient. The IP address shown at the end is 10.20.1.200.

This completes the connection verification.