Creating an OCS PostgreSQL Database

Create a PostgreSQL table space and execute the $AF_HOME/db/postgreSQL/ocs/ocs_schema_ddl.sql script.

1. Create a table space for the OCS database by running the following script: $AF_HOME/db/postgreSQL/oms/dbscripts/create_tablespace.sql.
2. Create the database user for OCS by running the following script: $AF_HOME/db/postgreSQL/oms/dbscripts/create_user.sql.
3. Run the following script: $AF_HOME/db/PostgreSQL/ocs/ocs_schema_ddl.sql.

   Or you can copy ocs_schema_ddl.sql to $AF_HOME/db/postgreSQL/oms/dbscripts and run setup.sh or setup.cmd from $AF_HOME/db/postgreSQL/oms/.

Copyright © Cloud Software Group, Inc. All rights reserved.