Check pgsql - NRPE PostgreSQL check - Revision history

Tykling at 01:20, 26 February 2010

2010-02-26T01:20:02Z

@@ Line 20: / Line 20: @@
 Add the following line to <code>/usr/local/etc/nrpe.cfg</code>:
 <pre>
-command[check_pgsql]=/usr/local/libexec/nagios/check_pgsql -H 10.16.255.64
+command[check_pgsql]=/usr/local/libexec/nagios/check_pgsql -H 10.16.255.65
 </pre>
-Replacing <code>10.16.255.64</code> with the IP address the PostgreSQL server is listening on.
+Replacing <code>10.16.255.65</code> with the IP address the PostgreSQL server is listening on.
 Remember to restart NRPE after changing the config:
 <pre>
 sudo /usr/local/etc/rc.d/nrpe2 restart
 </pre>

Tykling at 00:59, 26 February 2010

2010-02-26T00:59:47Z

← Older revision		Revision as of 00:59, 26 February 2010
Line 1:		Line 1:
	{{DISPLAYTITLE:check_pgsql - NRPE PostgreSQL check}}		{{DISPLAYTITLE:check_pgsql - NRPE PostgreSQL check}}
	[[category:nagios]]		[[category:nagios]]
			[[category:postgres]]
	By default NRPE includes a plugin (you need to enable it in the <code>make config</code> screen when installing <code>net-mgmt/nagios-plugins</code>) to check a PostgreSQL server. Follow the instructions on this page to enable it.		By default NRPE includes a plugin (you need to enable it in the <code>make config</code> screen when installing <code>net-mgmt/nagios-plugins</code>) to check a PostgreSQL server. Follow the instructions on this page to enable it.

Tykling at 00:59, 26 February 2010

2010-02-26T00:59:29Z

← Older revision		Revision as of 00:59, 26 February 2010
Line 1:		Line 1:
			{{DISPLAYTITLE:check_pgsql - NRPE PostgreSQL check}}
			[[category:nagios]]

	By default NRPE includes a plugin (you need to enable it in the <code>make config</code> screen when installing <code>net-mgmt/nagios-plugins</code>) to check a PostgreSQL server. Follow the instructions on this page to enable it.		By default NRPE includes a plugin (you need to enable it in the <code>make config</code> screen when installing <code>net-mgmt/nagios-plugins</code>) to check a PostgreSQL server. Follow the instructions on this page to enable it.

Tykling at 00:58, 26 February 2010

2010-02-26T00:58:36Z

← Older revision		Revision as of 00:58, 26 February 2010
Line 1:		Line 1:
	By default NRPE includes a plugin to check a PostgreSQL server. Follow the instructions on this page to enable it.		By default NRPE includes a plugin (you need to enable it in the <code>make config</code> screen when installing <code>net-mgmt/nagios-plugins</code>) to check a PostgreSQL server. Follow the instructions on this page to enable it.

	== Configuring Nagios ==		== Configuring Nagios ==

Tykling: Created page with 'By default NRPE includes a plugin to check a PostgreSQL server. Follow the instructions on this page to enable it. == Configuring Nagios == Define a new service on the Nagios se…'

2010-02-26T00:54:13Z

Created page with 'By default NRPE includes a plugin to check a PostgreSQL server. Follow the instructions on this page to enable it. == Configuring Nagios == Define a new service on the Nagios se…'

New page

By default NRPE includes a plugin to check a PostgreSQL server. Follow the instructions on this page to enable it.

== Configuring Nagios ==
Define a new service on the Nagios server, in <code>/usr/local/etc/nagios/objects/services.cfg</code>:
<pre>
define service{
use generic-service
hostgroup_name postgresql-servers
service_description nrpe_check_pgsql
check_command check_nrpe2!check_pgsql
}
</pre>

The FreeBSD servers I monitor that has PostgreSQL installed are all members of the hostgroup <code>postgresql-servers</code>.

== Configuring NRPE ==
Add the following line to <code>/usr/local/etc/nrpe.cfg</code>:
<pre>
command[check_pgsql]=/usr/local/libexec/nagios/check_pgsql -H 10.16.255.64
</pre>

Replacing <code>10.16.255.64</code> with the IP address the PostgreSQL server is listening on.

Remember to restart NRPE after changing the config:
<pre>
sudo /usr/local/etc/rc.d/nrpe2 restart
</pre>