https://it-arts.net/index.php?action=history&feed=atom&title=LibreNMS_-_snmp_extend_check_postgres
LibreNMS - snmp extend check postgres - Revision history
2026-05-02T18:46:11Z
Revision history for this page on the wiki
MediaWiki 1.44.2
https://it-arts.net/index.php?title=LibreNMS_-_snmp_extend_check_postgres&diff=1036&oldid=prev
Admin: Text replacement - "Category:Wiki" to "Category:Wiki
'''''[https://it-arts.net/index.php/Category:Wiki Return to Wiki Index]'''''
"
2026-01-17T08:21:24Z
<p>Text replacement - "<a href="/index.php/Category:Wiki" title="Category:Wiki">Category:Wiki</a>" to "<a href="/index.php/Category:Wiki" title="Category:Wiki">Category:Wiki</a> '''''[https://it-arts.net/index.php/Category:Wiki Return to Wiki Index]''''' "</p>
<table style="background-color: #fff; color: #202122;" data-mw="interface">
<col class="diff-marker" />
<col class="diff-content" />
<col class="diff-marker" />
<col class="diff-content" />
<tr class="diff-title" lang="en">
<td colspan="2" style="background-color: #fff; color: #202122; text-align: center;">← Older revision</td>
<td colspan="2" style="background-color: #fff; color: #202122; text-align: center;">Revision as of 08:21, 17 January 2026</td>
</tr><tr><td colspan="2" class="diff-lineno" id="mw-diff-left-l1">Line 1:</td>
<td colspan="2" class="diff-lineno">Line 1:</td></tr>
<tr><td class="diff-marker"></td><td style="background-color: #f8f9fa; color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #eaecf0; vertical-align: top; white-space: pre-wrap;"><div>[[Category:Wiki]]</div></td><td class="diff-marker"></td><td style="background-color: #f8f9fa; color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #eaecf0; vertical-align: top; white-space: pre-wrap;"><div>[[Category:Wiki]]</div></td></tr>
<tr><td colspan="2" class="diff-side-deleted"></td><td class="diff-marker" data-marker="+"></td><td style="color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #a3d3ff; vertical-align: top; white-space: pre-wrap;"><div><ins style="font-weight: bold; text-decoration: none;"></ins></div></td></tr>
<tr><td colspan="2" class="diff-side-deleted"></td><td class="diff-marker" data-marker="+"></td><td style="color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #a3d3ff; vertical-align: top; white-space: pre-wrap;"><div><ins style="font-weight: bold; text-decoration: none;">'''''[https://it-arts.net/index.php/Category:Wiki Return to Wiki Index]'''''</ins></div></td></tr>
<tr><td colspan="2" class="diff-side-deleted"></td><td class="diff-marker" data-marker="+"></td><td style="color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #a3d3ff; vertical-align: top; white-space: pre-wrap;"><div><ins style="font-weight: bold; text-decoration: none;"></ins></div></td></tr>
<tr><td class="diff-marker"></td><td style="background-color: #f8f9fa; color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #eaecf0; vertical-align: top; white-space: pre-wrap;"><br></td><td class="diff-marker"></td><td style="background-color: #f8f9fa; color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #eaecf0; vertical-align: top; white-space: pre-wrap;"><br></td></tr>
<tr><td class="diff-marker"></td><td style="background-color: #f8f9fa; color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #eaecf0; vertical-align: top; white-space: pre-wrap;"><br></td><td class="diff-marker"></td><td style="background-color: #f8f9fa; color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #eaecf0; vertical-align: top; white-space: pre-wrap;"><br></td></tr>
</table>
Admin
https://it-arts.net/index.php?title=LibreNMS_-_snmp_extend_check_postgres&diff=172&oldid=prev
Admin: Text replacement - "Category:Post-It" to "Category:Wiki"
2025-12-08T14:33:07Z
<p>Text replacement - "<a href="/index.php?title=Category:Post-It&action=edit&redlink=1" class="new" title="Category:Post-It (page does not exist)">Category:Post-It</a>" to "<a href="/index.php/Category:Wiki" title="Category:Wiki">Category:Wiki</a>"</p>
<table style="background-color: #fff; color: #202122;" data-mw="interface">
<col class="diff-marker" />
<col class="diff-content" />
<col class="diff-marker" />
<col class="diff-content" />
<tr class="diff-title" lang="en">
<td colspan="2" style="background-color: #fff; color: #202122; text-align: center;">← Older revision</td>
<td colspan="2" style="background-color: #fff; color: #202122; text-align: center;">Revision as of 14:33, 8 December 2025</td>
</tr><tr><td colspan="2" class="diff-lineno" id="mw-diff-left-l1">Line 1:</td>
<td colspan="2" class="diff-lineno">Line 1:</td></tr>
<tr><td class="diff-marker" data-marker="−"></td><td style="color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #ffe49c; vertical-align: top; white-space: pre-wrap;"><div>[[Category:<del style="font-weight: bold; text-decoration: none;">Post-It</del>]]</div></td><td class="diff-marker" data-marker="+"></td><td style="color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #a3d3ff; vertical-align: top; white-space: pre-wrap;"><div>[[Category:<ins style="font-weight: bold; text-decoration: none;">Wiki</ins>]]</div></td></tr>
<tr><td class="diff-marker"></td><td style="background-color: #f8f9fa; color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #eaecf0; vertical-align: top; white-space: pre-wrap;"><br></td><td class="diff-marker"></td><td style="background-color: #f8f9fa; color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #eaecf0; vertical-align: top; white-space: pre-wrap;"><br></td></tr>
<tr><td class="diff-marker"></td><td style="background-color: #f8f9fa; color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #eaecf0; vertical-align: top; white-space: pre-wrap;"><br></td><td class="diff-marker"></td><td style="background-color: #f8f9fa; color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #eaecf0; vertical-align: top; white-space: pre-wrap;"><br></td></tr>
</table>
Admin
https://it-arts.net/index.php?title=LibreNMS_-_snmp_extend_check_postgres&diff=31&oldid=prev
imported>Z at 07:17, 3 May 2020
2020-05-03T07:17:37Z
<p></p>
<p><b>New page</b></p><div>[[Category:Post-It]]<br />
<br />
<br />
<br />
= check_postgres.pl =<br />
<br />
Get the script:<br />
<nowiki><br />
wget https://github.com/bucardo/check_postgres/archive/master.zip</nowiki><br />
<br />
Unzip and copy it where you need. Make it executable.<br />
<br />
<br />
<br />
= LibreNMS script =<br />
<br />
Get the script and make it executable:<br />
<nowiki><br />
wget https://github.com/librenms/librenms-agent/raw/master/snmp/postgres -O /etc/snmp/postgres && chmod +x /etc/snmp/postgres</nowiki><br />
<br />
In case of bug on the user/service, adapt '''$cpg --dbservice=$DBuser --action dbstats | awk -F ' ' \''''<br />
<br />
'''Verify the path to check_postgres.pl in /etc/snmp/postgres is correct.'''<br />
<br />
<br />
<br />
= pg_service =<br />
<br />
Modify/create and adapt to your configuration ''/etc/postgresql-common/pg_service.conf'':<br />
<nowiki><br />
[yourServiceName]<br />
host=127.0.0.1<br />
port=5432<br />
user=your_adapted_user<br />
password=your_password<br />
dbname=your_db_name<br />
sslmode=require</nowiki><br />
<br />
Restart the service.<br />
<br />
<br />
<br />
= .pgpass =<br />
<br />
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).<br />
<br />
This file should contain lines of the following format:<br />
<nowiki><br />
hostname:port:database:username:password</nowiki><br />
<br />
= SNMP Configuration =<br />
<br />
Adapt your ''/etc/snmp/snmpd.conf'' with:<br />
<nowiki><br />
extend postgres /etc/snmp/postgres</nowiki><br />
<br />
Restart the service.<br />
<br />
<br />
<br />
= Check Command =<br />
<br />
Adapt the user and path to your configuration:<br />
<nowiki><br />
sudo -u Debian-snmp /etc/snmp/postgres</nowiki><br />
<br />
<br />
<br />
= Sources =<br />
<br />
* https://docs.librenms.org/Extensions/Applications/#postgres<br />
* https://github.com/bucardo/check_postgres<br />
* https://bucardo.org/check_postgres/<br />
* https://bucardo.org/check_postgres/check_postgres.pl.html<br />
* https://www.digitalocean.com/community/tutorials/how-to-monitor-your-managed-postgresql-database-using-nagios-core-on-ubuntu-18-04<br />
* https://docs.postgresql.fr/8.1/libpq-pgpass.html<br />
<br />
<br />
----</div>
imported>Z