Set up PostgreSQL in Certificate Manager using Podman

This article includes updates for Certificate Manager 8.11.0-1.

This article describes how to install and set up the PostgreSQL database, used in Smart ID Certificate Manager (CM).

For detailed information about how to install PostgreSQL, see the documentation available at http://www.postgresql.org/ .

Prerequisites

• Install the PostgreSQL database according to the instructions for the downloaded PostgreSQL installation package.

• Extract the PostgreSQL database scripts create_db_and_role.sql, create_cmdb.sql, add_bootca.sql, located at certificate-manager-8.X.Y-Z\install\PostgreSQL, from the server containerization zip file.

Step-by-step instruction

Edit settings on the PostgreSQL server

1. Run the script, that creates the lcmreq user and the cmdb database, as database superuser:

psql -d postgres -U postgres -f create_db_and_role.sql >create_cmdb.log

2. Change the password for the lcmreq user, created by the script. The default password is REQreq01. The database name and user name should be in lower case,
   since they are case sensitive.

3. Check the log file.

4. Run the script for creating the cmdb tables:

psql -d cmdb -U lcmreq -f create_cmdb.sql >create_cmdb.log

5. Check the log file.

6. Run the script for creating the bootca: psql -d cmdb -U lcmreq -f add_bootca.sql >add_bootca.log

7. Check the log file.

Edit settings on the CM server

Navigate to the volume hosting the cm server config directory and update the database parameters in cm.conf:

• Database.name

• Database.user

• Database.password

Secure the connection

See Set up PostgreSQL in Certificate Manager.