The Alerts DB is called data on all the data nodes including the master and master replica node.
It was again introduced in 6.1. Starting from 6.2, the Historical Inventory Service xDB was merged with the Alerts DB. It is accessible via port 5432 and it is located in /storage/db/vcops/vpostgres/data.
Currently, the database stores:
- Alerts and alarm history
- History of resource property data
- History of resource relationship
You can connect to the Alerts DB from the command line (SSH). Log in on the analytic node you wish to connect to and run:
su - postgres
The command should not prompt for a password if ran as root.
Once logged in, connect to the database instance by running:
/opt/vmware/vpostgres/current/bin/psql -d vcopsdb -p 5432
The service command to start the Alerts DB from the command line (SSH) is:
service vpostgres start