Re: [ADMIN] Monitoring tool for Postgres Database

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 




On Thu, May 25, 2017 at 9:20 PM, Steven Chang <stevenchang1213@xxxxxxxxx> 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@xxxxxxxxxxx>:
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@partner.aligntech.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

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

[Postgresql General]     [Postgresql PHP]     [PHP Users]     [PHP Home]     [PHP on Windows]     [Kernel Newbies]     [PHP Classes]     [PHP Books]     [PHP Databases]     [Yosemite]

  Powered by Linux