Creating a PostgreSQL User Database
Note: Only when the identityProviderType=POSTGRES, the PostgreSQL user database is needed.
- Procedure
- Open the
$OM_HOME/db/dbscripts/postgreSQL/user/bin/postgres_user_db.properties
file in a suitable editor and update the following values:Property Update the Value for PG_HOME
PostgreSQL database home 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_USER
New database user PG_PASSWORD
Database user password PG_USER_DATABASE
User database PG_USER_SCHEMA
User schema PG_USER_TABLESPACE_LOCATION
User tablespace location PG_USER_TABLESPACE
User tablespace IS_CLOUD_PLATFORM
The default value is false. Set it to true if creating a database on a cloud platform. EXECUTE_DDL_DML_ONLY
The default value is false. Set it to true if you run only DDL/DML. - Save and close the file.
- Run the
$OM_HOME/db/dbscripts/postgreSQL/user/bin/db-setup.sh
script.