Creating database objects for PostgreSQL

Database prerequisites

• The database cluster must already exist.

• This procedure must be performed by a DBA user.

Create database objects

To create database objects for PostgreSQL, it is recommended to use the automatic procedure described in this section.

1. Run the il dataonedb.cfg file as detailed on the dataonedb.cfg-reference page.

2. Run this command: ./dataonedbmgr.sh -sqlrun -install

Manually launch the scripts

Manually launching the scripts is not suggested. If you are aware of what you are doing and know how to get out of it in case of unwanted results, follow these steps to access the scripts:

• Copy the DOIM_HOME/pkg-repo/pkg-base/db/ghibli-distro-db-<version>.tar.gz to the database host or to a client that can connect to the database.

• Extract the package ghibli-distro-db-<version>.tar.gz.

• Run the scripts and compile as needed.

PostgreSQL script parameters vs DMCFG parameters

Some of the scripts require parameters whose value must be the same as the value specified in the Domain Master Configuration Reference (DMCFG). Here is a quick cross-reference between the two sets of parameters:

PostgreSQL script parameter	DMCFG parameter
ADMIN_USER	NONE. This is an arbitrary user that will be created by the scripts and will be granted full administrative rights on both CEMAN Core schema (ceman_db_schema in DMCFG) and CEMAN IAM schema (KEYCLOAK_DB_SCHEMA in DMCFG).
APP_USER	CEMAN_DB_USR
APP_PASS	CEMAN_DB_PSW
KEYCLOAK_DB_SCHEMA	KEYCLOAK_DB_SCHEMA
CEMAN_DB_SCHEMA	ceman_db_schema