Creating PostgreSQL Tables
A script has been added for creating Postgres tables.
Procedure
-
Create a table space for the OCS database by running the following script:
$AF_HOME/db/postgreSQL/oms/dbscripts/create_tablespace.sql.
-
Create the database user for OCS by running the following script:
$AF_HOME/db/postgreSQL/oms/dbscripts/create_user.sql.
-
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.