PostgreSQL Connection Confirmation (Client)

Install the PostgreSQL Client

1. Log in to SIOS20-BASTION as SIOS20-AD\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 14.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 SIOS20-NODE1 or SIOS20-NODE2 as SIOS20-AD\lkadmin.

2. Launch the LifeKeeper GUI and verify that the resource hierarchy is active on SIOS20-NODE1.

3. Log in to SIOS20-BASTION as SIOS20-AD\lkadmin.

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

   > "C:\Program Files\PostgreSQL\14\bin\psql" -h 10.0.2.21 -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:
   

   > "C:\Program Files\PostgreSQL\14\bin\psql" -h 10.0.2.21 -p 5432 -U postgres
   

   
   Enter the password and run the following internal command:
   

   postgres=# SELECT inet_server_addr();
   

   
   The IP address used when executing the psql command will be displayed. It returns 10.0.2.21.
   

6. Using the LifeKeeper GUI, configure the PostgreSQL resources so that SIOS20-NODE2 is active.

7. Run the command again on SIOS20-BASTION. The IP address shown at the end is 10.0.2.21.
   

This completes the connection verification.