RE: Monitoring Script for Postgres

Pg_catalog tables have all details no need any extension or tool required , tool extract information pg_catalog and incormation_schema

From: Naveed Iftikhar <naveed27c(at)yahoo(dot)com>
Sent: Friday, June 21, 2024 12:27 PM
To: Kashif Zeeshan <kashi(dot)zeeshan(at)gmail(dot)com>
Cc: pgsql-admin(at)lists(dot)postgresql(dot)org
Subject: Re: Monitoring Script for Postgres

Thanks Kashif.

Best Regards

-Naveed-

On Thursday, June 20, 2024 at 10:28:15 PM CDT, Kashif Zeeshan <kashi(dot)zeeshan(at)gmail(dot)com <mailto:kashi(dot)zeeshan(at)gmail(dot)com> > wrote:

Hi

Please refer to the following for the monitoring purposes.

https://gist.github.com/phil-hildebrand/c59f9739bbd745f70b6c1e513931873b

https://github.com/nilenso/postgresql-monitoring

https://www.site24x7.com/help/database-monitoring/postgresql-monitor.html

Regards

Kashif Zeeshan

On Fri, Jun 21, 2024 at 6:35 AM Naveed Iftikhar <naveed27c(at)yahoo(dot)com <mailto:naveed27c(at)yahoo(dot)com> > wrote:

Hi PostgreSQL Admin Team,

I am new to PostgreSQL Database. I have provisioned few databases on RHEL. Need help and advise on how to setup basic database level monitoring like service status, tablespaces thresholds , buffer memory threshold, replication lag etc. Please suggest if any extensions are suitable for the PostgreSQL monitoring. What to avoid third party enterprise tools.

Best Regards

-Naveed-