Обсуждение: Best open source monitoring tools for PostgreSQL?

Поиск
Список
Период
Сортировка

Best open source monitoring tools for PostgreSQL?

От
Sbob
Дата:
All;


I'm wanting to find a good open source monitoring & alerting tool for 
PostgreSQL, it needs to have near real time alerting so tools like PG 
Badger / PGCLUU are out.  What are you all using?


Thanks in advance for any suggestions






Re: Best open source monitoring tools for PostgreSQL?

От
Mani Sankar
Дата:
Hi Sbob,

Maybe you can check tools like grafana, nagios, postgres_check, PMM etc.

Regards,
Mani.

On Fri, Oct 14, 2022 at 7:44 PM Sbob <sbob@quadratum-braccas.com> wrote:
All;


I'm wanting to find a good open source monitoring & alerting tool for
PostgreSQL, it needs to have near real time alerting so tools like PG
Badger / PGCLUU are out.  What are you all using?


Thanks in advance for any suggestions





Re: Best open source monitoring tools for PostgreSQL?

От
Keith Fiske
Дата:
Take a look at pgMonitor. It uses all open source components (Prometheus/Grafana) and is fully customizable to monitor any part of your application stack, not just PostgreSQL


On Fri, Oct 14, 2022 at 12:10 PM Mani Sankar <manisankar01695@gmail.com> wrote:
Hi Sbob,

Maybe you can check tools like grafana, nagios, postgres_check, PMM etc.

Regards,
Mani.

On Fri, Oct 14, 2022 at 7:44 PM Sbob <sbob@quadratum-braccas.com> wrote:
All;


I'm wanting to find a good open source monitoring & alerting tool for
PostgreSQL, it needs to have near real time alerting so tools like PG
Badger / PGCLUU are out.  What are you all using?


Thanks in advance for any suggestions







--
Keith Fiske
Senior Database Engineer
Crunchy Data - http://crunchydata.com

Re: Best open source monitoring tools for PostgreSQL?

От
"Edward J. Sabol"
Дата:
On Oct 14, 2022, at 11:44 AM, Sbob <sbob@quadratum-braccas.com> wrote:
> I'm wanting to find a good open source monitoring & alerting tool for PostgreSQL, it needs to have near real time
alertingso tools like PG Badger / PGCLUU are out.  What are you all using? 

check_postgres is great if you have a Nagios (or compatible alternative like Icinga) monitoring system. Even if you
don't,you could use it with cron pretty easily, I imagine. 

https://bucardo.org/check_postgres/
https://github.com/bucardo/check_postgres

Later,
Ed




Re: Best open source monitoring tools for PostgreSQL?

От
Licio Matos
Дата:
Hi Edward,

Take a look at PMM from percona.



Em sex., 14 de out. de 2022 às 21:13, Edward J. Sabol <edwardjsabol@gmail.com> escreveu:
On Oct 14, 2022, at 11:44 AM, Sbob <sbob@quadratum-braccas.com> wrote:
> I'm wanting to find a good open source monitoring & alerting tool for PostgreSQL, it needs to have near real time alerting so tools like PG Badger / PGCLUU are out.  What are you all using?

check_postgres is great if you have a Nagios (or compatible alternative like Icinga) monitoring system. Even if you don't, you could use it with cron pretty easily, I imagine.

https://bucardo.org/check_postgres/
https://github.com/bucardo/check_postgres

Later,
Ed



--
Licio Matos