View source for LibreNMS - snmp extend check postgres

[[Category:Wiki]]



= check_postgres.pl =

Get the script:
 <nowiki>
wget https://github.com/bucardo/check_postgres/archive/master.zip</nowiki>

Unzip and copy it where you need. Make it executable.



= LibreNMS script =

Get the script and make it executable:
 <nowiki>
wget https://github.com/librenms/librenms-agent/raw/master/snmp/postgres -O /etc/snmp/postgres && chmod +x /etc/snmp/postgres</nowiki>

In case of bug on the user/service, adapt '''$cpg --dbservice=$DBuser --action dbstats | awk -F ' ' \''''

'''Verify the path to check_postgres.pl in /etc/snmp/postgres is correct.'''



= pg_service =

Modify/create and adapt to your configuration ''/etc/postgresql-common/pg_service.conf'':
 <nowiki>
[yourServiceName]
host=127.0.0.1
port=5432
user=your_adapted_user
password=your_password
dbname=your_db_name
sslmode=require</nowiki>

Restart the service.



= .pgpass =

The file .pgpass in a user's home directory or the file referenced by PGPASSFILE can contain passwords to be used if the connection requires a password (and no password has been specified otherwise).

This file should contain lines of the following format:
 <nowiki>
hostname:port:database:username:password</nowiki>

= SNMP Configuration =

Adapt your ''/etc/snmp/snmpd.conf'' with:
 <nowiki>
extend postgres /etc/snmp/postgres</nowiki>

Restart the service.



= Check Command =

Adapt the user and path to your configuration:
 <nowiki>
sudo -u Debian-snmp /etc/snmp/postgres</nowiki>



= Sources =

* https://docs.librenms.org/Extensions/Applications/#postgres
* https://github.com/bucardo/check_postgres
* https://bucardo.org/check_postgres/
* https://bucardo.org/check_postgres/check_postgres.pl.html
* https://www.digitalocean.com/community/tutorials/how-to-monitor-your-managed-postgresql-database-using-nagios-core-on-ubuntu-18-04
* https://docs.postgresql.fr/8.1/libpq-pgpass.html


----