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
- Open the
$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
The default value is false. You need to set it to true if the database is on a cloud platform. EXECUTE_DDL_DML_ONLY
The default value is false. You need to set it to true if you want to execute only DDL/DML. - Save and close the file.
- Run the
$OM_HOME/db/dbscripts/postgreSQL/ocs/bin/db-setup.sh
script.