When configuring Certificate Hub, you must provide an external, empty database that meets the following requirements.

DBMS version

The external Certificate Hub database must be hosted on the following Database Management System (DBMS).

DBMS

Version

​PostgreSQL

15 or higher​

Database storage

Calculate the required database storage based on the expected certificates and reports. For example, a 1G storage is enough for 25,000 certs and a few weeks of reports.

Data

Quantity

Bytes/Item

Total

Certificates

25,000 certificates

20 KB/certificate

500 MB

Reports

200 reports

1 MB/report

200 MB


700 MB

Database permissions

To create an external database user with sufficient permissions, connect to PSQL using the default PostgreSQL user and execute the following commands.

CREATE USER ${POSTGRES_USER} WITH NOSUPERUSER CREATEDB ENCRYPTED PASSWORD '${POSTGRES_PWD}';
\c postgres ${POSTGRES_USER}
CREATE DATABASE certhub;
\c certhub ${POSTGRES_USER}
CREATE EXTENSION IF NOT EXISTS pg_trgm;

Where: