Create CMS Database

To install the CMS system you need to create the CMS Alerts database. This database is used to store alerts and other related data. The database schema is defined in the create_alert_db.pgsql script and is used to create the database and the necessary tables, views, and functions.

MOPS 4.0 version 2.0 Alert Database Definition

This script should be invoked using a connection to the database server with a user that has permission to create new databases. Use the PostgreSQL command ‘psql’ to execute this script.

Complete Syntax:

psql --file create_alert_db.pgsql  postgres://{username}:{password}@{host}:{port}/{databasename}

See deployment package folder <package>/dbdef/alertdb/dirdb for the script create_alert_db.pgsql and other related files.

Remarks

The file variables.pgsql may be updated to customize the database setup. It allow changing database and schema name as well as the user to be created for the database.

Creating Directory Metadata

The directory service database contains metadata, display components, displays, and dashboards that are part of the distribution. This data may be updated in new releases. Run the following command to install or update metadata.

Complete Syntax:

psql --file seed_mops_eav_entities.pgsql postgres://{username}:{password}@{host}:{port}/{databasename}

Example:

psql --file seed_mops_eav_entities.pgsql postgres://postgres@localhost/dirdb

See deployment package folder <package>/dbdef/alertdb/directory for the script seed_mops_eav_entities.pgsql and other related files.