Re: Suggestion to Monitoring Tool

[soumitra bhandary]

You can try nagios 

Sent from my iPhone

> On 27-May-2020, at 10:16 PM, postgann2020 s  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.

Re: suggestion the process to sync the data from PROD DB to Staging environment

[soumitra bhandary]

If possible you can connect staging server as asynchronous slave node to one of 
the asynchronous node already in production

Sent from my iPhone

On 27-May-2020, at 9:26 PM, postgann2020 s  wrote:


Hi Team,

Thanks for your support.

Could someone please suggest the process to sync the data from PROD DB to the 
Staging environment with minimal manual intervention or automatically.

Thanks & Regards,
Postgann.