Creating a PostgreSQL database for Orch in case of Redis

Create a PostgreSQL database for the Orch by running the provided scripts.

Procedure

Open $OM_HOME/db/dbscripts/postgreSQL/orch/bin/postgres_orch_db.properties file in a suitable editor and update the following values:

Property	Update the Value for
`PG_HOST`	PostgreSQL database host
`PG_PORT`	PostgreSQL port
`PG_SUPER_USER_NAME`	PostgreSQL superuser name
`PG_SUPER_USER_PASSWORD`	PostgreSQL superuser password
`PG_ORCH_USER`	New Orchestrator user
`PG_ORCH_PASSWORD`	Password for the Orchestrator user
`PG_ORCH_DATABASE`	Orchestrator database name
`PG_ORCH_SCHEMA`	Orchestrator schema
`PG_ORCH_TABLESPACE`	Orchestrator tablespace
`PG_ORCH_TABLESPACE_LOCATION`	Orchestrator 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.