Skip to main content

Local PostgreSQL Database Setup

This section provides instructions for setting up a local PostgreSQL database on the primary Key Manager Server. The instructions in this section are to be performed on the primary Key Manager Server, which is the first Key Manager Server you set up for the Key Manager deployment. These instructions are to be performed after installing the sshmgr rpm package, and before running Key Manager Server setup ssh-mgr-setup.

For more information about when you should run this command, see the Key Manager Server installation instructions, Setting Up Key Manager.

To set up a local PostgreSQL database for Key Manager use:

  1. Run the setup-pgsql utility to configure and initialize a local PostgreSQL database:

    # /opt/sshmgr/bin/setup-pgsql

    The setup-pgsql utility creates a database with the name keymanagerdb and user keymanager. Enter a password for the keymanager user. Remember the name of the database and the credentials of its user. You will have to input these later during Key Manager Server setup.

  2. If you plan on having additional Key Manager Servers as part of the deployment, open the PostgreSQL port 5432 on the firewall. This allows additional servers to connect to the database.

You should now have a functioning local PostgreSQL database on the primary Key Manager Server. Now you can complete Key Manager setup by running ssh-mgr-setup.