The Postgres database was introduced in 6.1. It has two instances in version 6.6. The Central Postgres DB, also called repl, and the Alerts/HIS Postgres DB, also called data, are two separate database instances under the database called vcopsdb.
The central DB exists only on the master and the master replica nodes when HA is enabled. It is accessible via port 5433 and it is located in /storage/db/vcops/vpostgres/repl.
Currently, the database stores the Resources inventory.
You can connect to the central 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 ...
