Обсуждение: Suggestion to Monitoring Tool

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
alertson deviations)
 
> 5. Logging audit data and insights from audit data.
> 
> 
> Thanks & Regards,
> Postgann.

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
alertson deviations)
 
> 5. Logging audit data and insights from audit data.
> 
> 
> Thanks & Regards,
> Postgann.

Hi !

Le mer. 27 mai, vers 22:15, postgann2020 s exprimait :
> 
> 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.

Last year, i setup prometheus with :
- postgres exporter for generic metrics
- some custom queries via postgres exporter to compute replication lag
  and few other things
- script exporter to explore logs and other things
- node exporter for disk filling.
- alertmanager to send slack notifications
- grafana dashboards for a nice view
- kibana / sentry manage logs and used as datasource for prometheus.

Regards,
-- 
Stéphane KANSCHINE - https://www.hexack.fr./ - https://www.nuajik.io./
＠ stephane@hexack.fr
  +33 6 64 31 72 52

Hi !

Le mer. 27 mai, vers 22:15, postgann2020 s exprimait :
> 
> 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.

Last year, i setup prometheus with :
- postgres exporter for generic metrics
- some custom queries via postgres exporter to compute replication lag
  and few other things
- script exporter to explore logs and other things
- node exporter for disk filling.
- alertmanager to send slack notifications
- grafana dashboards for a nice view
- kibana / sentry manage logs and used as datasource for prometheus.

Regards,
-- 
Stéphane KANSCHINE - https://www.hexack.fr./ - https://www.nuajik.io./
＠ stephane@hexack.fr
  +33 6 64 31 72 52