Creating an OMS PostgreSQL Database for the Admin User and Default Tenant

Create a PostgreSQL database for the admin user and default tenant user by configuring and executing the $AF_HOME/db/postgreSQL/oms/setup.sh script.

1. 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 superuser name
   pg_super_user_password	PostgreSQL superuser password
   Note: Based on the following details, two new database users, schemas, databases and tablespaces will be 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 OMS admin user Note: This is not the administrator user. This is a OMS user which would hold tables related to the cluster administration.
   pg_admin_password	Password for the OMS admin user
   pg_admin_database	OMS admin database name
   pg_admin_schema	OMS admin schema
   pg_admin_tablespace	OMS admin tablespace
   pg_admin_tablespace_location	OMS admin tablespace location

2. Save and close the file.
3. Execute the setup.sh script.