From: zurich@nym.hush.com
To: postgann2020 s <postgann2020@gmail.com>
Cc: pgsql-admin <pgsql-admin@postgresql.org>
Cc: pgsql-general <pgsql-general@postgresql.org>
Subject: Re: Suggestion to Monitoring Tool
Date: Wed, 27 May 2020 18:59:49 +0100
Message-ID: <20200527175950.2B44FC054B@smtp.hushmail.com> (raw)
In-Reply-To: <20200527173518.77E2EE012D@smtp3.hushmail.com>
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.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.
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-admin@postgresql.org
Cc: zurich@nym.hush.com, postgann2020@gmail.com, pgsql-general@postgresql.org
Subject: Re: Suggestion to Monitoring Tool
In-Reply-To: <20200527175950.2B44FC054B@smtp.hushmail.com>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox