User manual

© 2011 Racktivity NV 19/160
Antwerpsesteenweg 19 - 9080 Lochristi - Belgium - www.racktivity.com v 2014.5.14
Install DCPM Database
Type the following command as root using the command line in the terminal:
su- postgres (Debian)
sudo su postgres (Ubuntu)
Type now psql
Above commands take you in the psql (command line) to create your database.
Create 2 different databases
- Type the following command to create your main database
CREATE DATABASE dcpmdb;
With the above command you create the main database called “dcpmdb”. You can use any
desired name for this.
- Type the following command to create the monitoring database
CREATE DATABASE dcpmmon;
With the above command you create the monitoring database called “dcpmmon”. Again you can
change the name to your desired database name.
Create a user to access the database
- Type the following command to create a user and password
CREATE USER dcpm WITH PASSWORD ‘1234’;
With the above command you have created a user “dcpm” and a password ”1234”, username
and password can be chosen by the user. The defined user should be the database owner.
Grant access for the created user to the created databases
- Type the following command to grand the user access to the main database
GRANT ALL ON DATABASE dcpmdb TO dcpm;
Above command allows your created user “dcpm” to have access to your created database
called “dcpmdb”.
- Type the following command to grant the user access to the monitoring database
GRANT ALL ON DATABASE dcpmmon TO dcpm;
Above command allows your created user “dcpm” to have access to your created database
called “dcpmmon”.
Alter database to the DCPM user