Creating a PostgreSQL Database for the Admin User and Default Tenant

Create a PostgreSQL database by configuring and running the following script: $OM_HOME/db/postgreSQL/oms/setup.sh

Procedure

Open setup.sh in a suitable editor and update the following values in the script:

Property	Update the Value for
`PG_HOST`	PostgreSQL database host
`PGPORT`	PostgreSQL port
`pg_super_user_name`	PostgreSQL super user name
`pg_super_user_password`	PostgreSQL super user password
Note: Based on the following details, two new database users, schemas, databases and tablespaces is created.
`pg_oms_user`	New default tenant user
`pg_oms_password`	Password for the default tenant
`pg_oms_database`	Default tenant database name
`pg_oms_schema`	Default tenant schema
`pg_oms_tablespace`	Default tenant tablespace
`pg_oms_tablespace_location`	Default tenant tablespace location
`pg_admin_user`	New Order Management Server admin user Note: This is not the administrator user. This is an Order Management Server user, which holds tables related to the cluster administration.
`pg_admin_password`	Password for the Order Management Server admin user
`pg_admin_database`	Order Management Server admin database name
`pg_admin_schema`	Order Management Server admin schema
`pg_admin_tablespace`	Order Management Server admin tablespace
`pg_admin_tablespace_location`	Order Management Server admin tablespace location