Creating a PostgreSQL database for Order User
- Procedure
- 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 - Save and close the file.
- Run the
$OM_HOME/db/dbscripts/postgreSQL/order/bin/db-setup.sh
script.