Postgres and Backup

[wiproltdwiv]

Dear Sir/Madam,

I need your urgent help!!!!!
1) how to monitor postgresql by using nagios.(Please provide any link if possible)

Parameters need to be monitor(provide plugins for the below) :

Database Status
postgreSQL Log file monitoring (pg_log file)
Disk Utilization (%)
ASM Diskgroup used space % - ASM
DR Sync Difference - Dataguard

2) how to monitor postgresql by using nagios.(Please provide any link if possible)

Parameters need to be monitor(provide plugins for the below) :
CPU Utilization
Memory Utilization
Storage Pool space utilizaiton
Availability of Scratch Media
Max. num of mount points
Drive Offline
Path Offline
Data backed up
Backup Failed
Backup Missed

[hsmith]

Have you ran any of the postgres wizards(under the configure menu) that we have built into Nagios XI? Inside of XI we have the following wizards:

Postgres Database:
Connection Status, Database Size, Table Sizes, Relation Sizes, Sequences.

Postgres Query:
Monitor a query of your choosing ran vs. the DB.

Postgres Server:
Connection Status, Backend Connections, WAL file count.

We also have a number of plugins on Nagios Exchange built for Postgres monitoring.

Hopefully this can help.

[wiproltdwiv]

thanks a lot ....

I have another Domain "Storage". How i will add this domain into NagiosXI.
Please find the below parameters which needs to be monitor:
Availability of Storage
SP Performance Charecterstics
Utilization (%)
Queue Length
Response Time (ms)
"Total Bandwidth
(MB/s)"
"Total Throughput
(I/O/sec)"

LUN Performance Charecterstics:

Utilization (%)
Queue Length
Response Time (ms)
"Total Bandwidth
(MB/s)"
"Total Throughput
(I/O/sec)"

DISK Performance Charecterstics:
Utilization (%)
Queue Length
Response Time (ms)
"Total Bandwidth
(MB/s)"
"Total Throughput
(I/O/sec)"

[scottwilkerson]

Are these Windows domains? You may be able to use check_disk_smart