Received: from malur.postgresql.org ([217.196.149.56]) by arkaria.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.94.2) (envelope-from ) id 1sLkzB-00GOcv-3l for pgsql-admin@arkaria.postgresql.org; Mon, 24 Jun 2024 14:48:01 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.94.2) (envelope-from ) id 1sLkz9-009vqS-76 for pgsql-admin@arkaria.postgresql.org; Mon, 24 Jun 2024 14:47:59 +0000 Received: from makus.postgresql.org ([2001:4800:3e1:1::229]) by malur.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.94.2) (envelope-from ) id 1sLkz8-009vp9-Dr for pgsql-admin@lists.postgresql.org; Mon, 24 Jun 2024 14:47:59 +0000 Received: from sonic315-20.consmr.mail.ne1.yahoo.com ([66.163.190.146]) by makus.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_128_GCM_SHA256 (Exim 4.94.2) (envelope-from ) id 1sLkz5-002tyN-Ch for pgsql-admin@lists.postgresql.org; Mon, 24 Jun 2024 14:47:57 +0000 DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=yahoo.com; s=s2048; t=1719240473; bh=nlb9RoHff+202yN5493Js3J2So3Gx2kHNdsWx+jfSuU=; h=Date:From:To:Cc:In-Reply-To:References:Subject:From:Subject:Reply-To; b=jH3U4q602vM3L7vC0cFlrkqLrJS7rwYoXZVjGH2oa7QPo+tb4xCs8Hc3lXvDy7wEVZAxUWQwkhOZgmi+6Q+xzSAMShvuJOqxjBdSVjyRaeX6qt27skgDshtBIRE7JvsPvgArdkoSTDP+EjifLQnATrt/nfdq1GIkxNHhGFSeVm3bRIaOUtKwOoz/vOMRyJEjbFHUdsTKLoQT56jCVWuPvueIxSv6dpp++5xpk8IHqJVp3yKj1YqB8PisQb3/fI1kvGLBSOAjSdYjbaloHKxKfp8S72K6VtlKRmF14tIU4UDpPkm5HRPztKNeOrdEiW8tpmHGmdPTXYLTunYJJJD9PA== X-SONIC-DKIM-SIGN: v=1; a=rsa-sha256; c=relaxed/relaxed; d=yahoo.com; s=s2048; t=1719240473; bh=gezfHvt9KUmIJ9UWddFI+rsvhuuNNKGJJXzZ2aVelDH=; h=X-Sonic-MF:Date:From:To:Subject:From:Subject; b=ff4wfVpn5i4anzYkSvezT9j6I8c5nrmXAkY2GmSQXpyFic0SerD1DCbbs5OL/0H8VyAV0WvpJGFsdNvqvzZqfHFTfHgyZnpMbICP55TCcYbdNf4hfVYR+UBAWzvoPMoI2zieHwbPCwW6u8HnesaCGNlY0Tsww6B9uaShcJLa175HKBGVxLq3TOU7g1hhFHhBwggfTcbstLg3hdRQmA3wobGXg3OI1E0lH3khvv5BX8MqZD89fm6tEm7jm2GiJv1vSRqkY6wDl9yCCDsSBrAwLBAVSsCWnXUxvYrnQ+FYLbQyu75jF32sX7aDCU86dPefG3NDF5AMO9vFqTtFsX12XQ== X-YMail-OSG: 1RtLSN8VM1koBZXs4lfJtawUQQ72w1QQGgu8jtMw6ZNAGsM_zGvdUrhnL92cBie k.Kt8WI4XSvzsiHqBe.KUvwyVftnxatkI4T9ldwp.XL36mIX1PZkoPiQ4iiQs41wzedWJErE1uyK 1oVq7Gocw7w6oemdfPKirBtBsaBzR9aiPWe.T0g0TDMMkw1gE11.BOwnzy1wOR81hCv3QtmWRA1K DZJTguuKB3ElPF54weLZ56YD4SPdVbTQbWHx7AIUhNTnWoM.fLes1CwZL02LlRHmkm.YtYgIup3U eROUDvVht2YejNQi2u0Gf9VRQOutG1MmSv06OqUt47ZEU8vuzRh66pqN0zwiWnJdnnuGMU46CCv4 9F3UHhTHBYQ9Or8HDCpLOydDKwmcDfaizC3rW4koL3OGeqaIIL7kWJ1N1ACaAKlmW4COuNk9dTvL n7GMGRhbbMyKm2Q.zmmVFYXb9c_JuhaU4vcRDaD365R.6susyLeCM2ksKzAdrGFCFUUo4TyNmWit vJe8lBq9nm983xIFWLODX0bnUpjjha8TwWBHfQ1npyVLQpjQiu2i80bmd_6E1CrHuzVYQ6SOO.s5 66dcp3WMi.fgWxuS5KT.0H6q4lcvTJh18Pi5uWWR643OiN4DmiDX.CHjWx6q.ddRZPYcAeDv42zf csSOxAoO.ae6yGDFg868NDN0GzjqVlZ4CrzWMdNxIUYbx0fKTpLjwiZNTBGSdm2yI_EGsaodLdYA TSFEZx283x7nU8aIEnY6aRa__E0O6T96JAEyUe7M3rjKTUA6SNNXw_EIR7ZeVOFl_PwVA_MdriRb NoOkhK4nnnHKd_IJOg8A3vi3vT29k8aZEePUW3hWpoI29VLQC_UnOT8FhA5L_hXv1tza54lDkgsK XQ74jFTxEQjpRABZFA3MpwtMg06ENQYsk6iuy_OemuzjLEp9AX9P6YUVrz1bwUXL8nedCmUpu1tb cDN78w08ZQA3UmuupTgwIHJitsrabhwilpvx0G.Togen6hgFZRQH1uw7qXjQEvYXRZcoAC0p3Gv4 8V5DBBbie..Gazg9z2hzjS_UcBpzFf9Rm60fq5vzrDM0TZ8v2ablheHAdlZl8LuMOADs38yN.LAG ihhkv9oY96qzmKURU9JiSJ9j7Qk1.T_WkdEW5BGmt9.oPH8zWba.NSbYys3UMeAujEI9P2MSymVc J.JgrJhhpejV9njxfeBvIezqSXYFzTN3oXllvG_iPWR.9ApTgJDByMbtWJFnMIOZPHWj6PDGtQvo ylUV0HtVJ99eM7YvAq7dXZMjX14FVipTXnoX6lUU.qjYfkZ8Q0KVLEG8zoMuatwKHmaVn16LSsGM 6U1ex3euLyvcMO82uKAdAgfEgIKDY6jDRQXMNerrATrjwkS04SftO0MKbMqYwo7UFSWZlNSAftF4 p0jtwnMmddxxqUr9mOX9vbmOknZPvj8UoP41PpESSVW52WPWDSxK0R4WmrRwxy7st6GCmc6QaPlO pREijQIZ1SYHbaBRK0Z.TgV9YM38Jmp8p.nu6ClhXENuHqDmmswKKYb9C9JmLVr9doL6AFRPGtAE JtonVY8etx6ZIl1b4VJy2DeGxw0v19fdhf9K9xCePH4fNNFcHzqtj2oqvkYuQz_CG0.XNGsyEgDc Qawt04cq7t6XxNI.YdqGSBpLGgsZgi4CzT4RXuyLePzDiPzkoHVy0vKoD4lMTJGDt06fTydg_7OY OARoStN1bvoNXNWu6VOcTIGuTC3UGegqgTmT3dxid2IU.N0ykDjhQ9CAi9BLtrHSoMHNWjBnyz7v M7w1ecS9y3KBK1RJe1YlvFLsfb6ctlY7gLSzN3UVmAz8FvznZ00x.JhXeEK1x.1B__6HKasypRTa PICVu7Nu_e6gzoyiNYXav0fds1btCZWxFeKAlGxdVKICG1VdAtUn3WsIVQOcdphnHmOPXdaF4WDO loz1ZJqJrHdBYzsLvq3n7gZCDqsevjDy6fhgiUNZ0zvKzFWFwkPP8p1Jb4io3UGwWUnaY51cKekB I54MIEfZ.kQMv.yubfW6_izGX_GGVv_RmIwNsO_mpyjxlEzs6glhzO.mJCqUEbmQKQ1QTYSPfzme 8MSJYgf9.1A_ZbZ3x34eKYZcWB5IeUulwdqsnGr4NYv8WOGOk8KPBAKkr8iAYGLsXgxRpBSBmXKb zsmO4QQ.C.qBlsX1w5QX7P6mWzux5iR.3vIfjDlMDlQA6Be51jltkQbu3NmO.4EgV7bZ1sudcBqX gQ1sZb1S.wdo8Yf3EeBB8oSJ0sDdMdtQyChHDuS_jEny8TJVLQC3INxJaj82g76mQUFAj X-Sonic-MF: X-Sonic-ID: 5a892ac3-933b-4c69-9153-c8869a943f1d Received: from sonic.gate.mail.ne1.yahoo.com by sonic315.consmr.mail.ne1.yahoo.com with HTTP; Mon, 24 Jun 2024 14:47:53 +0000 Date: Mon, 24 Jun 2024 14:47:51 +0000 (UTC) From: Naveed Iftikhar To: "lennam@incisivetechgroup.com" Cc: "pgsql-admin@lists.postgresql.org" Message-ID: <770454097.9464082.1719240471493@mail.yahoo.com> In-Reply-To: <006f01dac56a$51861d40$f49257c0$@incisivetechgroup.com> References: <1677836299.8406039.1718933702004@mail.yahoo.com> <683270498.6299366.1718987205013@mail.yahoo.com> <006f01dac56a$51861d40$f49257c0$@incisivetechgroup.com> Subject: Re: Monitoring Script for Postgres MIME-Version: 1.0 Content-Type: multipart/alternative; boundary="----=_Part_9464081_17328558.1719240471492" X-Mailer: WebService/1.1.22407 YMailNorrin Content-Length: 9838 List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk ------=_Part_9464081_17328558.1719240471492 Content-Type: text/plain; charset=UTF-8 Content-Transfer-Encoding: quoted-printable Thanks a lot Lennam.=C2=A0 Best Regards=C2=A0-Naveed-=20 On Sunday, June 23, 2024 at 07:38:59 AM CDT, wrote: =20 =20 =20 Pg_catalog tables have all details no need any extension or tool required ,= tool extract information pg_catalog=C2=A0 and incormation_schema=C2=A0=20 =C2=A0 From: Naveed Iftikhar =20 Sent: Friday, June 21, 2024 12:27 PM To: Kashif Zeeshan Cc: pgsql-admin@lists.postgresql.org Subject: Re: Monitoring Script for Postgres =C2=A0 Thanks Kashif. =C2=A0 Best Regards =C2=A0-Naveed- =C2=A0 =C2=A0 On Thursday, June 20, 2024 at 10:28:15 PM CDT, Kashif Zeeshan wrote:=20 =C2=A0 =C2=A0 Hi =C2=A0 Please refer to the following for the monitoring purposes. =C2=A0 https://gist.github.com/phil-hildebrand/c59f9739bbd745f70b6c1e513931873b https://github.com/nilenso/postgresql-monitoring https://www.site24x7.com/help/database-monitoring/postgresql-monitor.html =C2=A0 Regards Kashif Zeeshan =C2=A0 On Fri, Jun 21, 2024 at 6:35=E2=80=AFAM Naveed Iftikhar wrote: Hi PostgreSQL Admin Team, =C2=A0 =C2=A0 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, rep= lication lag etc.=C2=A0 Please suggest if any extensions are suitable for t= he PostgreSQL monitoring. What to avoid third party enterprise tools.=C2=A0 =C2=A0 Best Regards =C2=A0-Naveed- =20 ------=_Part_9464081_17328558.1719240471492 Content-Type: text/html; charset=UTF-8 Content-Transfer-Encoding: quoted-printable
Thanks a lot Lennam. 

Best Regards
 -Naveed-


=20
=20
On Sunday, June 23, 2024 at 07:38:59 AM CDT, <l= ennam@incisivetechgroup.com> wrote:


=20 =20

Pg_catalog tables have all details no need any extension or t= ool required , tool extract information pg_catalog  and incormation_sc= hema 

 

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: M= onitoring Script for Postgres

 

Tha= nks Kashif.

 

Best Regards

=

 -Naveed-

 

 

On Thursday, June 20, 2024 at 10:28:15 PM CDT, Kashif Zees= han <kashi.zeeshan@gmail.com> wrote:

 

 

Hi

 

Please refer to the following for the monitorin= g purposes.

 

https://gist.gith= ub.com/phil-hildebrand/c59f9739bbd745f70b6c1e513931873b

 

Regards

Kashif Zeeshan

 

On Fri, Jun 21, 2024 at 6:35=E2=80=AFAM Naveed Iftikha= r <naveed27c@yahoo.com> wrote:

Hi PostgreSQL Admin Team,

 

  I am new to Postgre= SQL Database. I have provisioned few databases on RHEL. Need help and advis= e on how to setup basic database level monitoring like service status, tabl= espaces thresholds , buffer memory threshold, replication lag etc.  Pl= ease suggest if any extensions are suitable for the PostgreSQL monitoring. = What to avoid third party enterprise tools. 

 

Best Regards

 -Naveed-

=
------=_Part_9464081_17328558.1719240471492--