Re: Monitoring Script for Postgres

Thanks a lot Lennam. 
Best Regards -Naveed-

On Sunday, June 23, 2024 at 07:38:59 AM CDT, <lennam(at)incisivetechgroup(dot)com> wrote:


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> 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> 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-