User manual

Antwerpsesteenweg 19 - 9080 Lochristi - Belgium - www.racktivity.com v 2014.5.14

- Type the following command to alter your created database to your created user. This action

needs to be performed for both databases.

ALTER DATABASE dcpmdb OWNER TO dcpm;

Again here “dcpmdb” is the name of your created database, “dcpm” is the name of your created

user.

Now the same needs to be done for your second created database. So in our example type:

ALTER DATABASE dcpmmon OWNER TO dcpm;

Again here “dcpmmon” is the name of your created database, “dcpm” is the name of your

created user.

Alter the bytea_output setting on the main database

NOTE: This is only required for a postgresql database with version starting from 9.0 and up.

ALTER DATABASE dcpmdb SET bytea_output = 'escape';

This action is only required on the main database.

Change your configuration files to have external access to your created

databases.

To have access to your created databases the user should change two conf files in postgres.

Go to the directory where the following postgres configuration files are stored.

- Postgresql.conf

- Pg_hba.conf

If you do not know the exact path of above files you can search them using the following

command in LinuxOS:

Find / -name pg_hba.conf

Above to search for the “pg_hba.conf” file.

in pg_hba.conf you should make sure that the DB listens to the correct network by having the

following:

host all all 192.168.14.0/24 md5

192.168.14.0/24 = an example of the network IP and mask

Now the user needs to check if the database is listening to the correct address. So look for the

postgresql.conf file:

Find / -name postgresql.conf

Above to search for the “postgresql.conf” file.

Make sure that in postgres.conf there is the following line:

listen_addresses = '*'

then RESTART postgres for the changes to take effect by typing the following command:

/etc/init.d/postgres restart

Nice to know: