From: | zurich(at)nym(dot)hush(dot)com |
---|---|
To: | "postgann2020 s" <postgann2020(at)gmail(dot)com> |
Cc: | "pgsql-admin" <pgsql-admin(at)postgresql(dot)org>, "pgsql-general" <pgsql-general(at)postgresql(dot)org> |
Subject: | Re: Suggestion to Monitoring Tool |
Date: | 2020-05-27 17:59:49 |
Message-ID: | 20200527175950.2B44FC054B@smtp.hushmail.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-admin pgsql-general |
Hi
I also suggest Nagios (for immediate monitoring) layered with OPM (longer term and historical analysis), followed by PGBadger for stats snapshots (if your logging format policy permits), and also PG_activity for the Operations team (if security policies 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(dot)bhandary(at)hotmail(dot)com> wrote:
>
>You can try nagios
>
>Sent from my iPhone
>
>> On 27-May-2020, at 10:16 PM, postgann2020 s
><postgann2020(at)gmail(dot)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.
From | Date | Subject | |
---|---|---|---|
Next Message | Adrian Klaver | 2020-05-27 19:10:00 | Re: Suggest the Schedular for activities |
Previous Message | soumitra bhandary | 2020-05-27 17:36:57 | Re: suggestion the process to sync the data from PROD DB to Staging environment |
From | Date | Subject | |
---|---|---|---|
Next Message | James Lucas | 2020-05-27 18:12:24 | Changing wal segment size on existing database cluster |
Previous Message | soumitra bhandary | 2020-05-27 17:36:57 | Re: suggestion the process to sync the data from PROD DB to Staging environment |