agora inbox for pgsql-admin@postgresql.org  

help / color / mirror / Atom feed

Monitoring Script for Postgres
5+ messages / 3 participants
[nested] [flat]

* Monitoring Script for Postgres
@ 2024-06-21 01:35  Naveed Iftikhar <naveed27c@yahoo.com>
  0 siblings, 1 reply; 5+ messages in thread

From: Naveed Iftikhar @ 2024-06-21 01:35 UTC (permalink / raw)
  To: pgsql-admin@lists.postgresql.org <pgsql-admin@lists.postgresql.org>

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-

  

^ permalink  raw  reply  [nested|flat] 5+ messages in thread

* Re: Monitoring Script for Postgres
@ 2024-06-21 03:27  Kashif Zeeshan <kashi.zeeshan@gmail.com>
  parent: Naveed Iftikhar <naveed27c@yahoo.com>
  0 siblings, 1 reply; 5+ messages in thread

From: Kashif Zeeshan @ 2024-06-21 03:27 UTC (permalink / raw)
  To: Naveed Iftikhar <naveed27c@yahoo.com>; +Cc: pgsql-admin@lists.postgresql.org <pgsql-admin@lists.postgresql.org>

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@yahoo.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-
>
>

^ permalink  raw  reply  [nested|flat] 5+ messages in thread

* Re: Monitoring Script for Postgres
@ 2024-06-21 16:26  Naveed Iftikhar <naveed27c@yahoo.com>
  parent: Kashif Zeeshan <kashi.zeeshan@gmail.com>
  0 siblings, 1 reply; 5+ messages in thread

From: Naveed Iftikhar @ 2024-06-21 16:26 UTC (permalink / raw)
  To: Kashif Zeeshan <kashi.zeeshan@gmail.com>; +Cc: pgsql-admin@lists.postgresql.org <pgsql-admin@lists.postgresql.org>

Thanks Kashif.
Best Regards -Naveed- 

    On Thursday, June 20, 2024 at 10:28:15 PM CDT, Kashif Zeeshan <kashi.zeeshan@gmail.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

RegardsKashif Zeeshan
On Fri, Jun 21, 2024 at 6:35 AM Naveed Iftikhar <naveed27c@yahoo.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-

  
  

^ permalink  raw  reply  [nested|flat] 5+ messages in thread

* RE: Monitoring Script for Postgres
@ 2024-06-23 12:38  lennam@incisivetechgroup.com
  parent: Naveed Iftikhar <naveed27c@yahoo.com>
  0 siblings, 1 reply; 5+ messages in thread

From: lennam@incisivetechgroup.com @ 2024-06-23 12:38 UTC (permalink / raw)
  To: 'Naveed Iftikhar' <naveed27c@yahoo.com>; 'Kashif Zeeshan' <kashi.zeeshan@gmail.com>; +Cc: pgsql-admin@lists.postgresql.org

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@yahoo.com> 
Sent: Friday, June 21, 2024 12:27 PM
To: Kashif Zeeshan <kashi.zeeshan@gmail.com>
Cc: pgsql-admin@lists.postgresql.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.zeeshan@gmail.com <mailto:kashi.zeeshan@gmail.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@yahoo.com <mailto:naveed27c@yahoo.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-

^ permalink  raw  reply  [nested|flat] 5+ messages in thread

* Re: Monitoring Script for Postgres
@ 2024-06-24 14:47  Naveed Iftikhar <naveed27c@yahoo.com>
  parent: lennam@incisivetechgroup.com
  0 siblings, 0 replies; 5+ messages in thread

From: Naveed Iftikhar @ 2024-06-24 14:47 UTC (permalink / raw)
  To: lennam@incisivetechgroup.com <lennam@incisivetechgroup.com>; +Cc: pgsql-admin@lists.postgresql.org <pgsql-admin@lists.postgresql.org>

Thanks a lot Lennam. 
Best Regards -Naveed- 

    On Sunday, June 23, 2024 at 07:38:59 AM CDT, <lennam@incisivetechgroup.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@yahoo.com> 
Sent: Friday, June 21, 2024 12:27 PM
To: Kashif Zeeshan <kashi.zeeshan@gmail.com>
Cc: pgsql-admin@lists.postgresql.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.zeeshan@gmail.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@yahoo.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-

  

^ permalink  raw  reply  [nested|flat] 5+ messages in thread

end of thread, other threads:[~2024-06-24 14:47 UTC | newest]

Thread overview: 5+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2024-06-21 01:35 Monitoring Script for Postgres Naveed Iftikhar <naveed27c@yahoo.com>
2024-06-21 03:27 ` Kashif Zeeshan <kashi.zeeshan@gmail.com>
2024-06-21 16:26   ` Naveed Iftikhar <naveed27c@yahoo.com>
2024-06-23 12:38     ` lennam@incisivetechgroup.com
2024-06-24 14:47       ` Naveed Iftikhar <naveed27c@yahoo.com>

This inbox is served by agora; see mirroring instructions
for how to clone and mirror all data and code used for this inbox