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 PostgreSQL .
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.
Â
Secure the connection
See Set up PostgreSQL in Certificate Manager.
Â
Copyright 2024 Technology Nexus Secured Business Solutions AB. All rights reserved.
Contact Nexus | https://www.nexusgroup.com | Disclaimer | Terms & Conditions