Hi Team,
I want to setup monitoring of postgreSQL in nagiosxi. I can see wizard for Postgress in nagiosxi. I would like to know what are the configurations/changes/modifications I need to ask db guy to do on postgreSQL database end.
Can some one let me know on this information.
Regards,
Mohan Gandhi
Prerequisites for PostgreSQL database monitoring
Re: Prerequisites for PostgreSQL database monitoring
There shouldn't be any special requirements in order to monitor PostgreSQL database. The only thing you need to do is allow remote connection to the PostgreSQL database (allow connection from the Nagios XI server's IP address), and modify the firewall rules (open port 5432).
On the PostgreSQL server, you would need to modify the /var/lib/pgsql/data/postgresql.conf and /var/lib/pgsql/data/pg_hba.conf files in order to allow remote access.
Once you have remote access set up, just run the "Postgres Database" wizard, providing valid IP address, port, username/password, and database name in Step 1. Let us know if you have any further questions.
On the PostgreSQL server, you would need to modify the /var/lib/pgsql/data/postgresql.conf and /var/lib/pgsql/data/pg_hba.conf files in order to allow remote access.
Once you have remote access set up, just run the "Postgres Database" wizard, providing valid IP address, port, username/password, and database name in Step 1. Let us know if you have any further questions.
Be sure to check out our Knowledgebase for helpful articles and solutions!