Re: Monitoring Script for Postgres

[Naveed Iftikhar <naveed27c@xxxxxxxxx>]

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-