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:
$OPE_HOME/database-scripts/postgreSQL/admin/bin/db-setup.sh

Procedure

1. Open the postgres_admin_db.properties file in a suitable editor and update the following values in the script:

Property	Value
PG_HOST	PostgreSQL database host
PG_PORT	PostgreSQL port
PG_SUPER_USER_NAME	PostgreSQL superuser name
PG_SUPER_USER_PASSWORD	PostgreSQL superuser password
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	admin tablespace
PG_ADMIN_TABLESPACE_LOCATION	admin tablespace location
PG_HOME	C:/Program Files/PostgreSQL/11/bin
IS_CLOUD_PLATFORM	false
EXECUTE_DDL_DML_ONLY	false

2. Save and close the file.

3. Run the db-setup.sh script.

 

Top