Creating a PostgreSQL Database for the Order Capture System

Create a PostgreSQL database for the Order Capture System by configuring and running the following script.

Procedure

  1. Open $OM_HOME/db/dbscripts/postgreSQL/ocs/bin/postgres_ocs_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_OCS_USER New OCS user
    PG_OCS_PASSWORD Password for the OCS user
    PG_OCS_DATABASE OCS database name
    PG_ADOCSDMIN_SCHEMA OCS schema
    PG_OCS_TABLESPACE OCS tablespace
    PG_OCS_TABLESPACE_LOCATION OCS tablespace location
    IS_CLOUD_PLATFORM Default value is false. You need to set it to true if the database is 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.
  2. Save and close the file.
  3. Run the $OM_HOME/db/dbscripts/postgreSQL/ocs/bin/db-setup.sh script.