Creating a PostgreSQL Database for the Admin User

Create a PostgreSQL database for the Admin User and Default Tenant by configuring and running the following script:
$PSI_HOME/database-scripts/admin/postgreSQL/bin/db-setup.sh

Procedure

1. Open the $PSI_HOME/database-scripts/admin/postgreSQL/bin/postgres_admin_db.properties file in a suitable editor and update the following values in the script:

Property	Value
PG_HOME	C:/Program Files/PostgreSQL/11/bin
PG_HOST	PostgreSQL database host
PG_PORT	PostgreSQL port
PG_SUPER_USER_NAME	PostgreSQL superuser name
PG_SUPER_USER_PASSWORD	PostgreSQL superuser password
PG_SUPER_USER_DATABASE	PostgreSQL superuser database
PG_ADMIN_USER	New admin user
PG_ADMIN_PASSWORD	Password for the admin user
PG_ADMIN_DATABASE	admin database name
PG_ADMIN_SCHEMA	admin schema
PG_ADMIN_TABLESPACE_LOCATION	admin tablespace location
PG_ADMIN_TABLESPACE	admin tablespace
IS_CLOUD_PLATFORM	false
EXECUTE_DDL_DML_ONLY	false
BASE_INSTALLATION_SCRIPTS	database_ddl.sql (End user must not modify this value)

2. Save and close the file.

3. Run the db-setup.sh script.