Configuring postgresql database server with Nagios

[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])

[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.

[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])

[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.

[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])

[hsmith]

Let us know how it goes.