Re: Monitoring tool for Postgres Database

On Thu, May 25, 2017 at 9:20 PM, Steven Chang <stevenchang1213(at)gmail(dot)com>
wrote:

> Hello Scott,
>
> Nagios is an alert system, I guess the check_postgres module is in
> use.
> EM Grid is a management console whose functions are not just alert ,
> but also remote control, etc.
>
> Hello Ravi,
>
> From a open source standing, I propose pgcluu. But it doesn't include
> remote control .
>
> Best Regards,
> Steven
>
> 2017-05-26 4:00 GMT+08:00 Scott Whitney <scott(at)journyx(dot)com>:
>
>> Personally I push those off to my network monitor. Nagios in my case.
>>
>> I find a single integrated alert and escalation framework is better than
>> individual tools, but that's just me.
>>
>> If you're using Nagios, let me know, and I can pop you several stub
>> scripts to help.
>>
>
Personally, I'm a huge fan of grafana and collectd It's definitely not a
pre-packaged solution, but it's simple, easy to use and very, VERY fast.
Alerts with nagios work, but, nagios is awful with history and trending,
but, it beats most others for just alerts

>
>> On May 25, 2017 2:50 PM, Ravi Tammineni <rtammineni(at)partner(dot)aligntech(dot)com>
>> wrote:
>>
>> Hi,
>>
>>
>>
>> What is the best monitoring tool for Postgres database? Something like
>> Oracle Enterprise Manager.
>>
>>
>>
>> Specifically I am interested in tools to help:
>>
>>
>>
>> Alert DBAs to problems with both configuration and performance issues
>>
>> Deadlocks, Long running queries etc.,
>>
>> Monitoring of overall system performance
>>
>> General performance tuning
>>
>> Storage/Disk latencies
>>
>>
>>
>>
>>
>> Thanks
>>
>> ravi
>>
>>
>>
>>
>> Journyx, Inc.
>> 7600 Burnet Road #300
>> Austin, TX 78757
>> www.journyx.com
>>
>> p 512.834.8888 <(512)%20834-8888>
>> f 512-834-8858 <(512)%20834-8858>
>>
>> Do you receive our promotional emails? You can subscribe or unsubscribe
>> to those emails at http://go.journyx.com/emailPreference/e/4932/714/
>>
>
>

--
--
Scott Mead
Sr. Architect
*OpenSCG <http://openscg.com>*
http://openscg.com