Thread: Suggestion to Monitoring Tool
Hi Team,
Thanks for your support.
Environment Details:
Thanks for your support.
Environment Details:
OS: RHEL 7.2
Postgres: 9.5.15
Master-Slave with Streaming replication
We are planning to implement the monitoring tool for our environment.
Could someone please suggest the Monitoring Tool based on your experience.
We are looking to cover the below areas.
1. Monitoring metrics and alerting.
2. Monitoring events and alerting.
3. Consolidate all the PROD DB logs and provide insights on log data.
4. logging explain plan and insights on explain plans. (Something like store explain plan and compare plans and send alerts on deviations)
5. Logging audit data and insights from audit data.
Thanks & Regards,
Postgann.
We are planning to implement the monitoring tool for our environment.
Could someone please suggest the Monitoring Tool based on your experience.
We are looking to cover the below areas.
1. Monitoring metrics and alerting.
2. Monitoring events and alerting.
3. Consolidate all the PROD DB logs and provide insights on log data.
4. logging explain plan and insights on explain plans. (Something like store explain plan and compare plans and send alerts on deviations)
5. Logging audit data and insights from audit data.
Thanks & Regards,
Postgann.
Hi I also suggest Nagios (for immediate monitoring) layered with OPM (longer term and historical analysis), followed by PGBadgerfor stats snapshots (if your logging format policy permits), and also PG_activity for the Operations team (if securitypolicies permit), the latter is great when handling locking amongst other things. Cheers Peter Goodwin On 5/27/2020 at 6:35 PM, "soumitra bhandary" <soumitra.bhandary@hotmail.com> wrote: > >You can try nagios > >Sent from my iPhone > >> On 27-May-2020, at 10:16 PM, postgann2020 s ><postgann2020@gmail.com> wrote: >> >> >> Hi Team, >> >> Thanks for your support. >> >> Environment Details: >> OS: RHEL 7.2 >> Postgres: 9.5.15 >> Master-Slave with Streaming replication >> >> We are planning to implement the monitoring tool for our >environment. >> >> Could someone please suggest the Monitoring Tool based on your >experience. >> >> We are looking to cover the below areas. >> >> 1. Monitoring metrics and alerting. >> 2. Monitoring events and alerting. >> 3. Consolidate all the PROD DB logs and provide insights on log >data. >> 4. logging explain plan and insights on explain plans. >(Something like store explain plan and compare plans and send >alerts on deviations) >> 5. Logging audit data and insights from audit data. >> >> >> Thanks & Regards, >> Postgann.
Hi I also suggest Nagios (for immediate monitoring) layered with OPM (longer term and historical analysis), followed by PGBadgerfor stats snapshots (if your logging format policy permits), and also PG_activity for the Operations team (if securitypolicies permit), the latter is great when handling locking amongst other things. Cheers Peter Goodwin On 5/27/2020 at 6:35 PM, "soumitra bhandary" <soumitra.bhandary@hotmail.com> wrote: > >You can try nagios > >Sent from my iPhone > >> On 27-May-2020, at 10:16 PM, postgann2020 s ><postgann2020@gmail.com> wrote: >> >> >> Hi Team, >> >> Thanks for your support. >> >> Environment Details: >> OS: RHEL 7.2 >> Postgres: 9.5.15 >> Master-Slave with Streaming replication >> >> We are planning to implement the monitoring tool for our >environment. >> >> Could someone please suggest the Monitoring Tool based on your >experience. >> >> We are looking to cover the below areas. >> >> 1. Monitoring metrics and alerting. >> 2. Monitoring events and alerting. >> 3. Consolidate all the PROD DB logs and provide insights on log >data. >> 4. logging explain plan and insights on explain plans. >(Something like store explain plan and compare plans and send >alerts on deviations) >> 5. Logging audit data and insights from audit data. >> >> >> Thanks & Regards, >> Postgann.