Task #1668
closed
StatisticalManager DB: monitoring via nagios
100%
Description
The statisticalManager db should be monitored by nagios. it is a postgres db hosted on
db5.p.d4science.research-infrastructures.eu
Files
Updated by Pasquale Pagano over 9 years ago
- Tracker changed from Support to Task
- Priority changed from Normal to High
Updated by Tommaso Piccioli over 8 years ago
- Assignee changed from Tommaso Piccioli to _InfraScience Systems Engineer
Updated by Andrea Dell'Amico over 8 years ago
There are four databases on that server but only dataSpace seems to be in use:
aquamapsorgupdated | utente | UTF8 | en_US.UTF-8 | en_US.UTF-8 |
dataSpace | gcube | UTF8 | en_US.UTF-8 | en_US.UTF-8 |
postgres | postgres | UTF8 | en_US.UTF-8 | en_US.UTF-8 |
template0 | postgres | UTF8 | en_US.UTF-8 | en_US.UTF-8 | =c/postgres +
| | | | | postgres=CTc/postgres
template1 | postgres | UTF8 | en_US.UTF-8 | en_US.UTF-8 | postgres=CTc/postgres+
| | | | | =c/postgres
testdb | gcube | UTF8 | en_US.UTF-8 | en_US.UTF-8 |
timeseries | gcube | UTF8 | en_US.UTF-8 | en_US.UTF-8 |
Is it correct?
Updated by Andrea Dell'Amico over 8 years ago
- Status changed from New to In Progress
- % Done changed from 0 to 80
Updated by Andrea Dell'Amico over 8 years ago
- Status changed from In Progress to Feedback
The ganglia and nagios checks are in place. Please let me know about the various databases status.
Updated by Fabio Sinibaldi over 8 years ago
- File dbReport.txt dbReport.txt added
Wrote a routine that queries the IS and looks for database declarations in ServiceProfiles.
Checks are done by same dbName, same host (both checking hostname and resolved Ip).
The report in attachment shows also matching dbName but different host.
It seems to me that "dataspace" and "testdb" are used in production environments, while "aquamapsorgupdated" and "timeseries" are probably copied from development instances but are not used.
I skipped checking "postgres", "template0" and "template1".
Updated by Andrea Dell'Amico over 8 years ago
- Status changed from Feedback to Closed
OK, I've put under nagios all the existing databases.
