Thread: Question on Open PostgreSQL Monitoring

Question on Open PostgreSQL Monitoring

From
"Lu, Dan"
Date:

Hello,

 

I am not sure if this is the right email group to ask about Open PostgreSQL Monitoring (https://opm.readthedocs.io/opm-core/index.html).  It appears there is no update to this tool since at least 2019. 

 

Since members from this email group has lots of expertise on PostgreSQL, I thought I ask if anyone knows of a better tool to replace OPM for PG? 

 

Thanks for your feedback in advance.


Dan




IMPORTANT: The information contained in this email and/or its attachments is confidential. If you are not the intended recipient, please notify the sender immediately by reply and immediately delete this message and all its attachments. Any review, use, reproduction, disclosure or dissemination of this message or any attachment by an unintended recipient is strictly prohibited. Neither this message nor any attachment is intended as or should be construed as an offer, solicitation or recommendation to buy or sell any security or other financial instrument. Neither the sender, his or her employer nor any of their respective affiliates makes any warranties as to the completeness or accuracy of any of the information contained herein or that this message or any of its attachments is free of viruses.

Re: Question on Open PostgreSQL Monitoring

From
Julien Rouhaud
Date:
Hi,

On Thu, Feb 17, 2022 at 03:52:54PM +0000, Lu, Dan wrote:
> 
> I am not sure if this is the right email group to ask about Open PostgreSQL
> Monitoring (https://opm.readthedocs.io/opm-core/index.html).

The correct place to ask question is one the github repositories, per
https://opm.readthedocs.io/developers/development_information.html.

> It appears there is no update to this tool since at least 2019.

The extensions and UI didn't have update since 2020, and that's because there
was no need.  Those are responsible for storing whatever perfdata is generated
by Nagios or similar and graphing them.  All the postgres-specific logic is in
the probe (https://github.com/OPMDG/check_pgactivity) which is actively
developed.

That being said, you can use a different UI on top of the extension if you
want, and multiple people had success building grafana dashboards quite easily.

> Since members from this email group has lots of expertise on PostgreSQL, I
> thought I ask if anyone knows of a better tool to replace OPM for PG?

A lot of tools are gathered at https://wiki.postgresql.org/wiki/Monitoring.
There isn't a single killer tool that's better than everything else, and you
should probably pick something that can easily be integrated in whatever
monitoring / alerting solution you're already using.