Creating a PostgreSQL database for Order User

    Procedure
  1. Open $OM_HOME/db/dbscripts/postgreSQL/order/bin/postgres_order_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_DATABASEs PostgreSQL superuser database
    PG_ORDER_USER New Order user
    PG_ORDER_PASSWORD Password for the Order user
    PG_ORDER_DATABASE Order database name
    PG_ORDER_SCHEMA Order schema
    PG_ORDER_TABLESPACE Order tablespace
    PG_ORDER_TABLESPACE_LOCATION Order tablespace location
    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.
    DEFAULT_TENANT TIBCO
    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 order_ds_ddl.sql,oms_seed_orderlock.sql,order_ds_dml.sql
    5.1.0_TO_6.0.0HF0_SCRIPTS upgrade_5.1.0hf7_to_6.0_ddl.sql
  2. Save and close the file.
  3. Run the $OM_HOME/db/dbscripts/postgreSQL/order/bin/db-setup.sh script.