We monitor everything using Nagios.
So we have several VDP 5.5 and there is a tab named Reports where VDP indicates the backup usage and you know that when 80% or more VDP can get in troubles....
Monitoring the filesystems /data01, /data02, /data03 won't accomplish the same....I already tried creating some correlation between the % reported in the Reports Tab and the df -h command space....but the thing is
when you delete Backups or when you reduce the retention policy, Reports Tab says % usage has decreased but I don't see that using the df -h linux command
So my question is there a way to get that % from Reports Tab anywhere in the VDP Appliance config files or something ?
thanks a lot
I think Nagios can do a PostGres SQL query. If so what you can do is open the Postgres database on the VDP server up and run this query...
SELECT MAX(utilization) as percentage FROM v_node_space WHERE date_time = (SELECT MAX(date_time) FROM v_node_space);
To open up the postgres database you'll need to do the following...
1. Enable Remote SSH Login (Optional, but it makes my life easier)
permitRootLogin yes <--- Line 142 change to yes
service sshd restart
2. Edit postgressql.conf
listen_addresses='*' <--- uncomment line 56 and change localhost to *
host all all 0.0.0.0/0 trust <-- comment out line 69 and add a new line with this
3. Edit the firewall.base
# enable remote access to postgress db service
# add these lines to the bottom of the firewall.base file
iptables -I INPUT 1 -p tcp --dport 5555 -j ACCEPT
iptables -I INPUT 1 -p tcp --dport 5558 -j ACCEPT
4. Reboot the VDP appliance
5. You can now run the following query to find any backups that failed.
Postgres Username: viewuser
Postgres Password: viewuser
Query: SELECT MAX(utilization) as percentage FROM v_node_space WHERE date_time = (SELECT MAX(date_time) FROM v_node_space);