Set up PostgreSQL in Certificate Manager using Podman

This article includes updates for Certificate Manager 8.13.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.

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

CODE

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

For Postgressql version 15 and above

CODE

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

For Postgressql version 14 and below

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.

CODE

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

Check the log file.
Run the script for creating the bootca with DataBase_User as (lcmreq or postgres ): psql -d cmdb -U <DataBase_User> -f add_bootca.sql >add_bootca.log
Check the log file.

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