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 1sKTBL-00AOpR-Am for pgsql-admin@arkaria.postgresql.org; Fri, 21 Jun 2024 01:35:15 +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 1sKTBI-005fpP-1i for pgsql-admin@arkaria.postgresql.org; Fri, 21 Jun 2024 01:35:12 +0000 Received: from magus.postgresql.org ([2a02:c0:301:0:ffff::29]) by malur.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.94.2) (envelope-from ) id 1sKTBH-005fp3-7S for pgsql-admin@lists.postgresql.org; Fri, 21 Jun 2024 01:35:12 +0000 Received: from sonic320-21.consmr.mail.ne1.yahoo.com ([66.163.191.83]) by magus.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_128_GCM_SHA256 (Exim 4.94.2) (envelope-from ) id 1sKTBE-002kGL-JT for pgsql-admin@lists.postgresql.org; Fri, 21 Jun 2024 01:35:10 +0000 DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=yahoo.com; s=s2048; t=1718933706; bh=10tnC7+gd3bX/PaWx+1kCBQkrh6Jfe1amhiIW5crJbg=; h=Date:From:To:In-Reply-To:References:Subject:From:Subject:Reply-To; b=UpgwYICU6i2rok9DcwRjQZmHThkyMCdtiLxF5yLPfx6f1aLr41Kq/H1o1Mqi9/QX5vEP74tiGPz9t79cTRB6ymbSR4awDskUrCsyAQViZmJKZ/llCrcSROMNqQkXbitD4+7Kaw2I9qc04gqJu9Qxshg//sW3IczahegUlZlqyzM8LERbK24HuU9AExbGVwQZbfzSQ9zuGZmeGtDRGa/aZnz9UYPUMEOPflFQvPAl6xD/E0kY53Kwxz/djBUKqtCOxdEyR+ULgdm3bUr33f6HTmx2MJtPRnXKnUY/WrygUfL47lHqfFzgTXFmV1Mby/dVcGTqAs6R1pd8PsQhRAujqA== X-SONIC-DKIM-SIGN: v=1; a=rsa-sha256; c=relaxed/relaxed; d=yahoo.com; s=s2048; t=1718933706; bh=UM15O/7hNnFQ0vykFt7Z/xloGIjJUGx+MrDQScdaATX=; h=X-Sonic-MF:Date:From:To:Subject:From:Subject; b=Zt3dn18wH8OvMfXHa92jM9zW2yKPrYw0WZr4EKjfWnXUsffh7VpbbfcEAOGHGkgFNomxGVPBqsGfpQV5/SD8+G8sEenp/h6kzAM4Ic+kCaE/Upj+JRgmjDBCbsCIArMGWS+KdB2TVOl0NwffcfIyf56B6+KpLvbXBytrlb2BI816asa/c4OYVgl7KUgC2h4YLsutWfp8auk394OQy1sW8ny2AOOPhEulm2wcUZ1cmuyyLSIEZNgwlSSLz5ZxFcnAvp3fNyzDYdf0YvgsNUPDQmqz8SUeNxi6xzYZGgbamJnREUX2ufxnvGpQe0YJZfMR/kLGJozws15VhRgKk/o+0g== X-YMail-OSG: S7WfCuEVM1lXzOBV9at.rIx6yk_HHIbVGxUuRjhGJa0tYYrcjfdhv1vaGxnXUPx 7lW4od2vo8z9dLkju_vZB6NBHAbyq.x4Cd4N5P1qkhZ.uZnSkh94y4s6KXeEiV0T8XII9_M1KzJO NmZiADoccQYfJJhtM3c7qacZDtPQLvwmzoaMBMTOaFmyYzBsgFCvopCj90tQBcP9eVYVs2yBCL2M GshMwyQKNGGWf9gTIKNsYVFT1wj7rm4eJOoJ4uvDxEO.DVfs1pjznhebC1nWMdVAZi6u_U3LbF6p IwHmOdp0M_O4T_FO5EOTmt96Ebu.na7avffgYTkf.hY0KIt0jmDt_uv0NDBXeVTjaUTuIydyxGlv UzlZ6yVO5aC5q5zJDb8cMLp5Cclz0xh3IeMCh8Y2YDycgu5qL_v_r2saXHF6j3VrsL98JQGPIgz8 ConGlCMRDNQhclu_l_xAoCBvoJVHDS89O0yDUJLjGFy4w6aYP626XZGl8pnnc2zZYwDMAXS2voEF tsBVsrhy_L3M23DbHRkwa94xSqs5ADaN2Z6ntMXXbFWCPkd9XJUs8sDFWzqoKUHuAwKGt2N.Av5. Si_7A_0HuEvc6vZTswoBT5mL5dwoSD9yqJyNa..29KO54r0GyQKELRavNN29V9VileqNcn49iJ9y mLB6RS3eyoR6xLEvtJ9veY6WfIsi2meTiNoI4cvzu6WmAQaaW79cLBW8YVqynkNOGcKLwD8UlZey voz4AcFxeITXpngNoKKNtyqOR0uxH2.o7iLKctbAy8MybCzfipQFRl219u4rCntYVymg64lEgbdF GGB6bB8h5Zs0TzoxkcBKb8rIszX4P3n.fR5pco1rB75fpY73lrsgmH43kW1kCnAMwjoAFWqBDGor nbwgZNALq25kSbnYkxXNc.uv3pp_QhXYgtscTknNfYMD6a02kaqCHIhqFjWM44Z_OMvo4P1A3MtV ZvwGbVtsMEWhFdcR.D396vYi7OQkQ_sjyJWh0bBHZX2F_7NCS7QMPvPHU4dYw3sLk555UBNknltM mBOVFtlY4wH8OvYq6R2IqKbi0R3qN70aF2WGNVvSm6degs9U3xvGdU9osjymCV7THIrSUOJAmx81 8SWbbTxStpBQLJBxqu9nHEJVxXXpKxTbkJvimYpsxzHvMu8jkEOMINowP2lNlbt3jW8fsshDhR4L x9uvz_fhLWzBkPoHAJV9gf7CmmbBGdxTU4pYAGCpe8PldCxJhd3ZtkplNaw.nzzK0mYLXOIH6oJV rQVKV7p7r7snVFPdwXBYB1uTJhMbKi18zqjZuBckEPR68kYkEoaAzr4Pw6XIOGDU7kMnA9iFPv5s bas_0dV4BXkRQNh_a1rxNvOtXplZlUrbT8LHzt1CjVPo_qahms5wOe3N_6.rBHLE5LnJpkLVu_eG aioyLEZIdlHQAvz_0g7jB4_stU46.npDy4jCtuvte.l0vOoIxZt0FgL6e_z8T8REtyKwBY3Mk0sI fsN3ebp_ztKrHBR_AdQdjpYF7fmZo8o2lnaEOa_Wwm3pInjBhpEtRm9lPEZfuuWuBYIijOS7mo2g 1WV4XtIA5VRpBAUmQIvpMIgbrp3TiuqlUANtjlI3I7IPte6z2D1.dpKVdnK2W7JAiiDaBf0ICDzQ iJrxvb4Oet3tIe8SKaS.ctlwdMCvHPsh2tAhiB9DBHyNiDCrtZ73iImv9cFNYBwhwposEqBnPaxi ZKxzrd9os4IgREcU_FyDV3C2pBwRiI_oybsYUXqmfyRD5GhbnVq_Iv_GM_1BSSkVPaRCp81B0dBl byAv.Yer3h831bIpePG2eG_Ir.F8sat6tqcKpjDY7mrTUns36iYk2.1RDZuZL0iul6ysJ48GhNah .5RXQIhjPuHBpNXLX7meNgCSoCf.tVfIDDovFigyy_FumfKBe80S3lyeqAR_klk.EyGJv_wBXtGE JgRIhyHZrRho7shU5q0LONkEcQUKowAD79NHBl2PEC2_gO.6OiCmET3G.VyrdQwLuIgO08FNrcAL NqrHAxw7G5SUea6CztBQD3GGOGH1Bw1cFYYKzy58bUDNwbSvKYlqjzvsqoyI2yXYF1223REaP9HD H2spXkb0A2.x87Oi5gd2Re.QvzW9oIv5SUOI.QIVedNvOJm96vyXJAISERkXajPRnxWiYmil5qQO tcCJ7wmzqZUlp0ii5RhUDsvhRRaR3W8oY2l3dRbOEZvBFLqUjadKT_iedvqbHXkmnoc0WAS0skin OQg0OsL4EVe6lcdDJFGAJTXkRXY7sZYR6Ugz7H9jPn2mZo4GSBUWqHMOPjKWIQ1b8_id8Aitco2J zfV4Zrtv8kg0- X-Sonic-MF: X-Sonic-ID: 500cf5a5-98e9-4ae5-b726-09072d67b4d2 Received: from sonic.gate.mail.ne1.yahoo.com by sonic320.consmr.mail.ne1.yahoo.com with HTTP; Fri, 21 Jun 2024 01:35:06 +0000 Date: Fri, 21 Jun 2024 01:35:01 +0000 (UTC) From: Naveed Iftikhar To: "pgsql-admin@lists.postgresql.org" Message-ID: <1677836299.8406039.1718933702004@mail.yahoo.com> In-Reply-To: References: Subject: Monitoring Script for Postgres MIME-Version: 1.0 Content-Type: multipart/alternative; boundary="----=_Part_8406038_1613447503.1718933702003" X-Mailer: WebService/1.1.22407 YMailNorrin Content-Length: 2243 List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk ------=_Part_8406038_1613447503.1718933702003 Content-Type: text/plain; charset=UTF-8 Content-Transfer-Encoding: quoted-printable 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 ------=_Part_8406038_1613447503.1718933702003 Content-Type: text/html; charset=UTF-8 Content-Transfer-Encoding: quoted-printable
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 memor= y threshold, replication lag etc.  Please suggest if any extensions ar= e suitable for the PostgreSQL monitoring. What to avoid third party enterpr= ise tools. 

Be= st Regards
 -Naveed-
------=_Part_8406038_1613447503.1718933702003--