agora inbox for pgsql-admin@postgresql.org
help / color / mirror / Atom feedFrom: lennam@incisivetechgroup.com
To: 'Naveed Iftikhar' <naveed27c@yahoo.com>
To: 'Kashif Zeeshan' <kashi.zeeshan@gmail.com>
Cc: pgsql-admin@lists.postgresql.org
Subject: RE: Monitoring Script for Postgres
Date: Sun, 23 Jun 2024 08:38:57 -0400
Message-ID: <006f01dac56a$51861d40$f49257c0$@incisivetechgroup.com> (raw)
In-Reply-To: <683270498.6299366.1718987205013@mail.yahoo.com>
References: <CA+M9Y+AyJyXDvMhUYbM-FrR5BSbfhmwTY1NRH4_Fzp8DBGwaHw@mail.gmail.com>
<CAA=RfSNOEbp7J9W4_TsfEvzpTsGJy8qWU44Oa+O8z5txeV4hsg@mail.gmail.com>
<1677836299.8406039.1718933702004@mail.yahoo.com>
<CAAPsdhcjbtQajbgKn_o-MMkzxEBTXWix6T=ZmEEAC2hF5z3wcw@mail.gmail.com>
<683270498.6299366.1718987205013@mail.yahoo.com>
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-
view thread (5+ messages) latest in thread
Message-ID: <006f01dac56a$51861d40$f49257c0$@incisivetechgroup.com>
Permalink: ../006f01dac56a$51861d40$f49257c0$@incisivetechgroup.com/
Also on: postgresql.org/message-id/006f01dac56a$51861d40$f49257c0$@incisivetechgroup.com
reply
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-admin@postgresql.org
Cc: lennam@incisivetechgroup.com, naveed27c@yahoo.com, kashi.zeeshan@gmail.com, pgsql-admin@lists.postgresql.org
Subject: RE: Monitoring Script for Postgres
In-Reply-To: <006f01dac56a$51861d40$f49257c0$@incisivetechgroup.com>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by agora; see mirroring instructions
for how to clone and mirror all data and code used for this inbox