RE: Monitoring Script for Postgres

[<lennam@xxxxxxxxxxxxxxxxxxxxx>]

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@xxxxxxxxx>
Sent: Friday, June 21, 2024 12:27 PM
To: Kashif Zeeshan <kashi.zeeshan@xxxxxxxxx>
Cc: pgsql-admin@xxxxxxxxxxxxxxxxxxxx
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.zeeshan@xxxxxxxxx> 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@xxxxxxxxx> 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-