Set up PostgreSQL in Certificate Manager using Podman
This article is new for Certificate Manager 8.10.4.
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.zip\cmdb-install-tool-8.X.Y.zip\install\PostgreSQL, from the server containerization zip file.
Step-by-step instruction
Edit settings on the PostgreSQL server
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
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.Check the log file.
Run the script for creating the cmdb tables:
psql -d cmdb -U lcmreq -f create_cmdb.sql >create_cmdb.log
Check the log file.
Run the script for creating the bootca:
psql -d cmdb -U lcmreq -f add_bootca.sql >add_bootca.log
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.