PostgreSQL DB / EDB Monitoring
Consider usage of our brand new full-stack infrastructure monitoring tool XorMon Next Generation as LPAR2RRD replacement.
It brings a new level of infrastructure monitoring by relying on a modern technology stack.
In particular, reporting, exporting, alerting and presentation capabilities are unique on the market.
host all lpar2rrd monitoring machine IP/hostname md5Running this command on your DB can help you locate pg_hba.conf
SHOW hba_file;After you complete this step restart the PostgresSQL service
$ rpm -q perl-DBI perl-DBD-Pg perl-DBI-1.627-4.el7.x86_64 perl-DBD-Pg-2.19.3-4.el7.x86_64
# yum install perl-DBD-Pg
# apt-get install libdbd-pg-perl
# yum install postgresql-libs # rpm -i perl-DBI-1.623-1.aix5.1.ppc.rpm # rpm -i perl-DBD-Pg-3.7-4.ppc.rpm
$ perl /home/lpar2rrd/lpar2rrd/bin/conntest.pl 192.168.1.1 5432 Connection to "192.168.1.1" on port "5432" is ok
CREATE ROLE lpar2rrd WITH PASSWORD 'your_passw0rd' LOGIN; GRANT SELECT ON TABLE pg_stat_bgwriter TO lpar2rrd; GRANT SELECT ON TABLE pg_stat_database TO lpar2rrd; GRANT SELECT ON TABLE pg_stat_activity TO lpar2rrd; GRANT SELECT ON TABLE pg_locks TO lpar2rrd; GRANT SELECT ON TABLE pg_cursors TO lpar2rrd; GRANT SELECT ON TABLE pg_stat_progress_vacuum TO lpar2rrd; GRANT SELECT ON TABLE pg_stat_replication TO lpar2rrd; GRANT SELECT ON TABLE pg_stat_wal_receiver TO lpar2rrd;
$ crontab -l | grep "load_postgres.sh" $
$ crontab -e # PostgreSQL support 0,5,10,15,20,25,30,35,40,45,50,55 * * * * /home/lpar2rrd/lpar2rrd/load_postgres.sh > /home/lpar2rrd/lpar2rrd/load_postgres.out 2>&1
# su - lpar2rrd $ tar xvf lpar2rrd-7.XX.tar $ cd lpar2rrd-7.XX $ ./install.sh $ cd /home/lpar2rrd/lpar2rrd
cd /home/lpar2rrd/lpar2rrd . etc/lpar2rrd.cfg; $PERL bin/perl_modules_check.plIf there is missing "LWP::Protocol::https" then check this docu to fix it
su - lpar2rrd umask 022 cd /home/lpar2rrd/lpar2rrd cp html/.htaccess www cp html/.htaccess lpar2rrd-cgi
$ crontab -l | grep load.sh $
$ crontab -e # LPAR2RRD UI 0,30 * * * * /home/lpar2rrd/lpar2rrd/load.sh > /home/lpar2rrd/lpar2rrd/load.out 2>&1Assure there is just one such entry in crontab.
# echo "lpar2rrd" >> /etc/cron.allow
$ crontab -l | grep "load_postgres.sh" $
$ crontab -e # PostgreSQL support 0,5,10,15,20,25,30,35,40,45,50,55 * * * * /home/lpar2rrd/lpar2rrd/load_postgres.sh > /home/lpar2rrd/lpar2rrd/load_postgres.out 2>&1
$ cd /home/lpar2rrd/lpar2rrd $ ./load.sh
tail /var/log/httpd/error_log # Apache error log tail /var/log/httpd/access_log # Apache access log tail /var/tmp/lpar2rrd-realt-error.log # STOR2RRD CGI-BIN log tail /var/tmp/systemd-private*/tmp/lpar2rrd-realt-error.log # STOR2RRD CGI-BIN log when Linux has enabled private temp
umask 022 cd /home/lpar2rrd/lpar2rrd/ cp bin/test-healthcheck-cgi.sh lpar2rrd-cgi/go to the web browser: http://<your web server>/lpar2rrd/test.html