Creating a PostgreSQL Database for the Admin User

Procedure
1. Open $OM_HOME/db/dbscripts/postgreSQL/admin/bin/postgres_admin_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_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	Default value is false. You need to set it to true if the user wants to create a database on a cloud platform.
   EXECUTE_DDL_DML_ONLY	Default value is false. You need to set it to true if you want to execute only DDL/DML.
   BASE_INSTALLATION_SCRIPTS	database_ddl.sql, proc_app_properties_change.sql, proc_get_timestamp.sql
   5.1.0_TO_6.0.0HF0_SCRIPTS	upgrade_5.1.0_to_6.0_ddl.sql, proc_app_properties_change.sql, proc_get_timestamp.sql

2. Save and close the file.
3. Run the $OM_HOME/db/dbscripts/postgreSQL/admin/bin/db-setup.sh script.