Requirements:
1. Zabbix 3.0 Server
2. Zabbix agent installed Centos 7 Server
3. PostgresSQL DBUser for Monitoring.
4. Add permissions in pg_hba.conf and pg_ident.conf Files.
Install from source
For PostgresSQL :
1.
Download and install the libpq development
headers (typically libpq-dev or postgresql-devel)
Download the latest libzbxpgsql source tarball
from the downloads page
URL :
http://cdn.cavaliercoder.com/libzbxpgsql/yum/zabbix30/rhel/7/x86_64/libzbxpgsql-1.1.0-1.el7.x86_64.rpm
2.
Extract, configure and compile the sources with:
$ tar -xzf libzbxpgsql-*.tar.gz
$ cd libzbxpgsql-*/
$ ./configure --with-zabbix=/usr/src/zabbix
$ make && sudo make install
The module will be installed
to /usr/local/lib/libzbxpgsql.so
Copy or link the module into your Zabbix
agent LoadModulePath directory
(typically /var/lib/zabbix/modules)
$ sudo mkdir /var/lib/zabbix/modules
$ sudo ln -s /usr/local/lib/libzbxpgsql.so
/var/lib/zabbix/modules/libzbxpgsql.so
3.
Add the module to your zabbix_agentd.conf file
with:
LoadModule=libzbxpgsql.so
4.
Restart the Zabbix agent with
Validate installation
:
If the module is loaded correctly, you will see the
following line in your Zabbix agent log file
(/var/log/zabbix/zabbix_agentd.log):
loaded modules: libzbxpgsql.so
Check the installed version with:
$ zabbix_agentd -t pg.modver
pg.modver
[s|libzbxpgsql 1.0.0, compiled for Zabbix 3.0.2]
Add Template to Host
:
Link for template for Zabbix 3.0
Configure connection
macros:
{$PG_CONN} - libpq compatible connection string. This
includes the hostname, port, username, etc. required to connect to PostgreSQL
{$PG_CONN} => host=pgdb.local port=5432 user=zabbix
connect_timeout=10
{$PG_DB} - database to connect to.
{$PG_DB} => postgres
Below Applications are
monitoried by using this :
PostgreSQL Backend Connections
|
PostgreSQL Background Writer
|
PostgreSQL Configuration
|
PostgreSQL Database Backend Connections
|
PostgreSQL Database Capacity
|
PostgreSQL Database Disk IO
|
PostgreSQL Database Errors
|
PostgreSQL Database Performance
|
PostgreSQL Database Temp File Utilization
|
PostgreSQL Index Statistics
|
PostgreSQL MVCC
|
PostgreSQL Prepared Transactions
|
PostgreSQL Server
|
PostgreSQL Tablespace Statistics
|
PostgreSQL Table Statistics
|
Comments
Post a Comment