PostgreSQL Protocol - PostgreSQL Database

Establish a connection to a PostgreSQL Database directly from your Vault

Overview

In this guide, you will learn how to configure a PostgreSQL Database on your PAM Database and configure the PostgreSQL protocol to successfully launch a zero-trust connection to the PostgreSQL Database — directly from your Keeper Vault. The same record can also launch in KeeperDB for visual database access.

Summary

For this setup, you need to do the following:

1. Enable the Connection Enforcement Policies

2. Install and Configure the Keeper Gateway

3. Create and configure the PAM Configuration File

4. Create the PAM Database and PAM User record types

5. Configure PAM Settings and the PostgreSQL Connection Protocol

After completing the above, you can launch zero-trust connections to the PostgreSQL Database directly from your Keeper Vault.

Step 1 - Enable Connection Enforcement Policies

From the Admin Console, enable the corresponding PAM Enforcement Policies for connections:

Policy	Definition	Commander CLI
Can configure connection settings	Allow users to configure Connection and Session Recordings settings on PAM Machine, PAM Directory, PAM Database and PAM Configuration Record Types	ALLOW_CONFIGURE_PAM_CLOUD_CONNECTION_SETTINGS
Can launch connections	Allow users to launch connections on PAM Machine, PAM Directory, PAM Database Record Types	ALLOW_LAUNCH_PAM_ON_CLOUD_CONNECTION
Can view session recordings	Allow users to view Session Recordings	ALLOW_VIEW_KCM_RECORDINGS

Step 2 - Install and configure the Keeper Gateway

Prior to creating the PAM Record types in your Vault, the Keeper Gateway needs to be installed in your infrastructure. Visit the following guides based on your needs:

• Windows Installation

• Linux Installation

• Docker Installation

Additionally, the Keeper Gateways needs to be configured with the Gateway token. For more information, visit this page.

Steps 3 and Step 4 can be automated with the Gateway Wizard. For more information, visit this page.

Step 3 - Configuring the PAM Configuration

The PAM Configuration contains critical information on your infrastructure, settings and associated Keeper Gateway. Visit the following pages for more details based on your target infrastructure:

• Setting up Local Environment on the PAM Configuration

• Setting up AWS Environment on the PAM Configuration

• Setting up Azure Environment on the PAM Configuration

Step 4 - Create and Configure PAM Database and PAM User(s) Records

After setting up your Gateway and PAM Configuration Record, the PostgreSQL Database and its users need to be configured on PAM Record types in your Vault:

• PAM Database - The PostgreSQL Database is configured on this record type

• PAM User - The PostgreSQL Database User is configured on this record type

Refer to this example on how to configure PostgreSQL Database on a PAM Database record type:

Example: PostgreSQL Database

Step 5 - Configuring PAM Settings and PostgreSQL Protocol

The PAM Database record type contains the necessary information required for the Keeper Gateway to locate and establish a connection with the database, while the PAM User record type contains the necessary information to authenticate the connection.

The PAM Settings need to be configured to enable connections or tunnels on the target defined on the PAM Database Record. To configure the PostgreSQL protocol, visit the following page:

PostgreSQL Connections

Launching Connections

Once you have configured the PostgreSQL Protocol connection on your PAM Database Record, your record will contain the following connection banner with the "Launch" Button:

In the above image, a PostgreSQL Database has been configured on the PAM Database Record. When clicking launch, the Vault Client will render a window with the established connection protocol to the specified target. Supported PostgreSQL database records can also open in KeeperDB for visual access and monitoring.

Sharing PAM Database Records

PAM Database records can be shared with other Keeper users within your organization. However, the recipient must have the appropriate PAM enforcement policies in place to utilize KeeperPAM features on the shared PAM records.

When sharing a PAM Database record, the linked admin credentials will not be shared. For example, if the PAM Database is configured with a PostgreSQL Database, the recipient can connect to the PostgreSQL Database on the PAM Database record without having direct access to the linked credentials.