Page 1 of 1
Configuring postgresql database server with Nagios
Posted: Sun Dec 27, 2015 2:44 pm
by pbankar
Hi,
Can you please assist to configuring postgresql database server with Nagios?
I would like to know, what configuration need to consider at PostgreSQL database server and at Nagios server.
E.g. Changes in postgres configuration file (postgresql.conf)- what changes?
Any other config file/environment variable?
Thanks in advance.
Pravin (
[email protected])
Re: Configuring postgresql database server with Nagios
Posted: Sun Dec 27, 2015 8:38 pm
by tmcdonald
If you are discussing Nagios XI, no changes should need to be made to a clean system. The postgres database is installed and configured automatically by our installer script. Installing Nagios XI on an existing system is not recommended.
Re: Configuring postgresql database server with Nagios
Posted: Mon Dec 28, 2015 1:59 am
by pbankar
Thanks for details.
We have postgres databases on one server whereas Nagios XI on other server and our aim is to configure the postgres database server in Nagios; so that we can monitor the postgres database server.
Both the servers are setup and ready that is postgres database server already in use and Nagios also setup on other server.
We are updating the postgres database server details in Nagios and just curious is there any configuration at postgres database server (Example: the postgres listener will need to allow connections from the Nagios server, etc.)
~ Pravin (
[email protected])
Re: Configuring postgresql database server with Nagios
Posted: Mon Dec 28, 2015 10:39 am
by hsmith
Have you tried to run the Postgres wizard? This will show you what you need in order to monitor it. I believe you just need a user that can see the data you are monitoring.
Re: Configuring postgresql database server with Nagios
Posted: Tue Dec 29, 2015 2:23 am
by pbankar
Thank you for details.
I haven't tried yet. I will get back to you when face any issue during configuration.
Thank you.
~ Pravin (
[email protected])
Re: Configuring postgresql database server with Nagios
Posted: Tue Dec 29, 2015 10:59 am
by hsmith
Let us know how it goes.