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 1sKh6E-00Bdpn-8A for pgsql-admin@arkaria.postgresql.org; Fri, 21 Jun 2024 16:26:54 +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 1sKh6C-004sRK-Kp for pgsql-admin@arkaria.postgresql.org; Fri, 21 Jun 2024 16:26:52 +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 1sKh6B-004sP3-Ug for pgsql-admin@lists.postgresql.org; Fri, 21 Jun 2024 16:26:52 +0000 Received: from sonic308-9.consmr.mail.ne1.yahoo.com ([66.163.187.32]) by makus.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_128_GCM_SHA256 (Exim 4.94.2) (envelope-from ) id 1sKh68-002RMm-OO for pgsql-admin@lists.postgresql.org; Fri, 21 Jun 2024 16:26:50 +0000 DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=yahoo.com; s=s2048; t=1718987207; bh=ZeLR+B1Do15lpOARiP9cp64kH19oKCAgrM3Xpnh46rQ=; h=Date:From:To:Cc:In-Reply-To:References:Subject:From:Subject:Reply-To; b=naHKJpBD4cvTwSyG6Sc2Nh6tglwatLvOl7VXRqGILSG5uawPEXQdwwQFgQKpXm1i4PkmyWVthpOWiU0fEwv7saCc5V/5c10lxxikQUmid4CCRcEmyRPPWghy9waAQZcL2s0ybWZc7GuMpLGWKXg1n/mwEZBnOhMoND5wPeANrjveIBO1jvFc1Qjwncc6OihOFrPFags5fXk3Z/ZSdTkgYlK6j7k6bueSbpNQCC5iPPRPcEU94NgpxJvGEBzVMzQmWnf8p3UIhWvMMo5ag48rmmiQAU5g/VEnnRMkI7IEe+b85BB6skr/1cYjlPCk3IlXWDNaC3u0gLIZ5bkXxqLqkw== X-SONIC-DKIM-SIGN: v=1; a=rsa-sha256; c=relaxed/relaxed; d=yahoo.com; s=s2048; t=1718987207; bh=37NfVtBo1D1apsWkBpFQt1G4J7m6VrOLXAOsoghfPm+=; h=X-Sonic-MF:Date:From:To:Subject:From:Subject; b=JPO5KZ1TIRAQSFfIugyUya0GSdu8W2UhCMRQ8Clff3GCBCnId0LMYJoHUWeYQjzFACaFl+01BPKUG9l3aRZCkv0lYIvVXsWk8CbtYZGCuglcFnt0knU//Yv9StVCo5KNXzLv6C1XdgI+8N1ynEXTrlLQAw6rrLkCv/nRd216smlBqWoFXp0GUduGXgkdR9+hhebwMs5bzih5hAD6iRv4dHV46j6aRVa4ke+i00yhPcERSG6KxFX1+6YliYfUJ3tLJYYBgqvmzVtR9y4GI6qmRLW6KBq8ES0GS9Mc0GpenslW3ygqEyFgcLZK5MirUgvLWiDQFqh32mleXXryzy5B5A== X-YMail-OSG: Lsd7lKwVM1nXs05rLL3Jf5D3kIcz3bWPusLT8i046XceDWifgfQX98nyPNIhC.l sTL1EACMF0CwDhRvKIOqGYg.nGDktcc1oxMd0PVHwf7K4xOECnZGZdek2d5Yol.ftHY_SNJBLNap k_yPvlhdaiYbhwjMTjPQzSYla926CG6rjX_l4qL93VOcFI7a9Ljxi0X4rOOLsBAnm7lAaxWvikEh 9ZliM6Y9N5phaddp9yKoQqldwgkxN8H2AlQb7S7tu0ZAQhQPdBJwkm_OdmK6HaccPO7k2laPQWx8 NLqHkr6HWn9SXn4aQLJj5XsKEb3cSbLygZM5SReVIxOJeldaYbVHasqwOfp02nCttO_t3R2NoXl1 KSsq08bx5b6oOq4U8SvMPE7SL.HrCn7Ur5cP8zSGb2eg7jxHjxANXYOAuPMqNFshH1plQcaCg._H 14f0Od_pf0UjfvCSoARUcZvMGxC3f3M5BOSHnDbgzog.Fz1jAo.UzOrf.PSFANn5QNrSkJ5I.vMC xpj1WpxIlWMCLviOahMCfVwZlb0mj0q.7usXYYHErLEh9Pp4DtCo_BCcgAKH1h6HfahlWQDKkswK 3mI6QL1DLRkIPE12u2EGzB9qDgZLqbgdS9a14S6s_57C3mCH8jmvfn49qQr13Fjo.B8eIvYyjl8M mYsh2TsR3Nnn4cPket5gqwscl7Pzq3Eriln866HGvpgEnEdT8C0DDSTVBRcr.b9yW0ZZMhbCPR9H oYBTFg7xISenCZ3LPVf7oXPAyoedTq9fd1KJEpwlMOi1aZqWjnXNV_SezS4rtPJ4PpMZVxMQLpmc KxIGxFE5BGzEOMQVkPoOuJGL0QoMT_HqUTpiYM_oX7eDdKz523CnsRqxmfSxWEzEX8Zu3MdoJWLS T7yfeWHO9BfNPaKDN5StnOyr1XRHKujfg6ho.VeWM6cx21BS.uaRrqhPtvUxk8aSUZitSHYu_b02 BdjUtg5gFhv3aPpUrqW3Osml8kRoC9i1fguJJudNXxLp2f8GKIYLRsYmA2yYa3TfYv4Uawvv4pyz 2jycjv9Ne.9ynhVjlFD2Y_CSJW8Op8nkO9fIUUVUk3Srqwlmh8ltM9i1PQBHpR_2eD_ddXv6FbHo NLkb4bvuJY_Y05Sgj_.Fo3IF.vVRV8.qD4FWHstN2crhpoQ22arumJhZGuobYAs9ySoPkBmCcFyC oEmzZm6eaJGsP1szalMNS.vYcM3dU7fyfhuoI8QeLC3_gBTtlmBmtuhzl189hv9TtTMA2deD7biK VCunBUapu.iWWSkYddve97cFkwbkYOxHEK5T3vE5kCXYw2as5Sbbv2fRYwZkEjDHkCZ32bLQVq0n XxGk4ilkKkdpSs1rfMfylRxM95xlMWT77QB6bCic5HmgqfRBI8afaI6FT7_rKUp7T05qlJv.VHko gN.NpwfBCXV8VB8.jWxWe0h0flwdmdnQV5lt_IzBthpZI2DyjCgzl0PdqLmGW1Qb0P8y.7RPl6I. zPEl8fVPV_idacjSTupC2MU6a6WzGSo4Cl0j5CCjznYWp8Izn426VbvpTpdAb9wazgjpS5niQHFr 6HHQ7hcpCKyUUJ.FiEtA_Ujt8rElhzsqmV3unAbA6hudkS2DKIuvwTlZSw96EteZ34i7bw7pg.nV 2MtNH62SxrA5iZ50wWRxevwv9wO71gIxCyRzacCu2Tl925sDcyCj5ZyoP_4.oaXvsZOINlwlny4w hFuoshckOZYbd08D7J6WXpMsSwPjVwEJt_exx9M1ngNUlQbZ0rSJFZMXLLWvkqin_xW5e6pgDVE3 vWT459IYwZd3XtgU.h6cvsX2j.c42js4WkjRRAp10u5.GkTY4X7lsgvQ5JBIvzaY_VxGJylL1rmz yxHHNo_BhjP0hqM7ufTFSpYungdTfZZoMK9TlPFUWXwFx1UH5HY6c3UqpO9TvUpvSyxS1eefiE.5 CnooAY1CHaJ66l5g9sB.W7lR2eRDXrZ17R6qoQRIA.OmjkqzMDubUMvdf6x2wP.EecP6ZvFxRIjc Y42DvFBrONPvLJePoK7PfGrPcKXgbv9mEI9yxCmvhX8T_ywwxdDfMzUoJiroJpaGelRDDgqX7uaW YVmTdyYqQQwaZK16AaIAmOODe5mifolX4r3OPY8hgknRMQAqhVuWugVemWFHdcd0J2vxV.oCmOx3 ovFF42tosKTeP6GN_0cgkAWQ4EtScDUlwhHXD7Plh7AyRRKStll5FiyFw9rkSnMFo53v8lGICxm3 tB0MoxcmcocNodrMjzlKjSUUftfd3n4Yt7yxYE3EDbKwJD0bBIvw.D5Q5i9IVJ7B5aOes9Cub_yQ H X-Sonic-MF: X-Sonic-ID: 77c5f1e8-9e74-4106-ab5e-f76747e18a25 Received: from sonic.gate.mail.ne1.yahoo.com by sonic308.consmr.mail.ne1.yahoo.com with HTTP; Fri, 21 Jun 2024 16:26:47 +0000 Date: Fri, 21 Jun 2024 16:26:45 +0000 (UTC) From: Naveed Iftikhar To: Kashif Zeeshan Cc: "pgsql-admin@lists.postgresql.org" Message-ID: <683270498.6299366.1718987205013@mail.yahoo.com> In-Reply-To: References: <1677836299.8406039.1718933702004@mail.yahoo.com> Subject: Re: Monitoring Script for Postgres MIME-Version: 1.0 Content-Type: multipart/alternative; boundary="----=_Part_6299365_221657342.1718987205012" X-Mailer: WebService/1.1.22407 YMailNorrin Content-Length: 5161 List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk ------=_Part_6299365_221657342.1718987205012 Content-Type: text/plain; charset=UTF-8 Content-Transfer-Encoding: quoted-printable Thanks Kashif. Best Regards=C2=A0-Naveed-=20 On Thursday, June 20, 2024 at 10:28:15 PM CDT, Kashif Zeeshan wrote: =20 =20 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=E2=80=AFAM Naveed Iftikhar wrote: Hi PostgreSQL Admin Team, =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 Best Regards=C2=A0-Naveed- =20 =20 ------=_Part_6299365_221657342.1718987205012 Content-Type: text/html; charset=UTF-8 Content-Transfer-Encoding: quoted-printable
Thanks Kashif.
Best Regards
 -Naveed-


=20
=20
On Thursday, June 20, 2024 at 10:28:15 PM CDT, Kash= if Zeeshan <kashi.zeeshan@gmail.com> wrote:


=20 =20
Hi

Please refer to the following for= the monitoring purposes.


On Fr= i, Jun 21, 2024 at 6:35=E2=80=AFAM Naveed Iftikhar <naveed= 27c@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 memo= ry threshold, replication lag etc.  Please suggest if any extensions a= re suitable for the PostgreSQL monitoring. What to avoid third party enterp= rise tools. 

Best Regards
 -Naveed-
------=_Part_6299365_221657342.1718987205012--