Re: [PERFORM] [ADMIN] Monitoring tool for Postgres Database

[Ashish Tiwari]

Hi Ravi,

We use the nagios to monitor the Postgresql Database . Nagios provide the
dedicated API for Postgresql and you can customize the same.

Thanks.

On May 26, 2017 1:19 AM, "Ravi Tammineni" 
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
>

Re: [PERFORM] [ADMIN] Monitoring tool for Postgres Database

[Tatsuo Ishii]

> We use Zabbix.

There's a Zabbix template for PostgreSQL called "pg_monz".

http://pg-monz.github.io/pg_monz/index-en.html

Best regards,
--
Tatsuo Ishii
SRA OSS, Inc. Japan
English: http://www.sraoss.co.jp/index_en.php
Japanese:http://www.sraoss.co.jp


-- 
Sent via pgsql-performance mailing list (pgsql-performance@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-performance

Re: [PERFORM] [ADMIN] Monitoring tool for Postgres Database

[Joshua D. Drake]

On 05/25/2017 07:15 PM, Scott Mead wrote:


Thanks

ravi



We use Zabbix.

JD









--
Command Prompt, Inc.  http://the.postgres.company/
+1-503-667-4564
PostgreSQL Centered full stack support, consulting and development.
Everyone appreciates your honesty, until you are honest with them.


--
Sent via pgsql-performance mailing list (pgsql-performance@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-performance

Re: [PERFORM] [ADMIN] Monitoring tool for Postgres Database

[Scott Mead]

On Thu, May 25, 2017 at 9:20 PM, Steven Chang 
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 :
>
>> 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 
>> 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. <(512)%20834->
>> 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

Re: [PERFORM] [ADMIN] Monitoring tool for Postgres Database

[Steven Chang]

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 :

> 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.
>
> On May 25, 2017 2:50 PM, Ravi Tammineni 
> 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. <(512)%20834->
> 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/
>

Re: [PERFORM] [ADMIN] Monitoring tool for Postgres Database

[Scott Whitney]

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.

On May 25, 2017 2:50 PM, Ravi Tammineni  
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.
f 512-834-8858

Do you receive our promotional emails? You can subscribe or unsubscribe to 
those emails at http://go.journyx.com/emailPreference/e/4932/714/