User Tools

Site Tools


postgres_queries

Postgres queries

For now you can monitor only one database on one postgresql server

Steps for monitoring PGSQL in Bijk:

1. Log-in to psql console (`su postgres -`, `psql`) and run this command (replace “{password}” with some secure password):

CREATE USER bijk WITH PASSWORD '{password}';

2. To file

/etc/postgresql/[version]/main/pg_hba.conf 

add this line before line starting with “local all all” (replace “{monitored_db_name}” with name of your monitored database):

local {monitored_db_name} bijk md5

3. Reload posgresql

/etc/init.d/postgresql-[version] reload

4. To file

 /etc/bijk/bijk-node-plugins.conf 

add those lines with access information:

PG_DB = {monitored_db_name}
PG_USER = bijk
PG_PASS = {password}

5. Restart Bijk deamon:

/etc/init.d/bijk-node restart

6. You can test access with this command (you will be prompted for password, after that you should be in psql console):

psql -WU bijk {monitored_db_name}
postgres_queries.txt · Last modified: 2010/05/18 09:26 by vladimir.kruzik