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 1r7bIt-005wJE-Ki for pgsql-admin@arkaria.postgresql.org; Mon, 27 Nov 2023 13:05:36 +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 1r7bIr-00DMQb-AT for pgsql-admin@arkaria.postgresql.org; Mon, 27 Nov 2023 13:05:33 +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 1r7bIq-00DMQT-OE for pgsql-admin@lists.postgresql.org; Mon, 27 Nov 2023 13:05:32 +0000 Received: from sonic309-20.consmr.mail.ne1.yahoo.com ([66.163.184.146]) by magus.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_128_GCM_SHA256 (Exim 4.94.2) (envelope-from ) id 1r7bIn-008n4d-4e for pgsql-admin@lists.postgresql.org; Mon, 27 Nov 2023 13:05:31 +0000 DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=yahoo.com; s=s2048; t=1701090325; bh=nWlbdspqrWbtE6C/WPFF6ewvITb9ui9IW1ue9y3Nkww=; h=Date:From:Reply-To:To:In-Reply-To:References:Subject:From:Subject:Reply-To; b=hvu5EyqTeTI84GjNaTVCYv4dmsUzY/Emtg0KX2ugZRLzNdSYAG0bRKjXcCyox86Nlp5nouFBOkuE3jXhXB7VUoVLSH2nGhzt71EYcm02L6Ua7kouWJtqUMflDLc8OHLqlpIRLKpf1zUOEIIch0BS0+zFWKElBWJSD/pkilPATwUxNZK5nMWD4ZyHEMpI7aH1Py6twit6yo7M57haIPHP7pzBGtWTmSjJdayUmecLSaasKq8mrYBTDIY0e6+w4Nl2yfquQsi0j17ECQU9KN/4Eg1EGNDBYRxOKsiqhEiKEkxLL4NWopK8k+iNYL65MtLsujui4jrwY5rCBxpHja7MlQ== X-SONIC-DKIM-SIGN: v=1; a=rsa-sha256; c=relaxed/relaxed; d=yahoo.com; s=s2048; t=1701090325; bh=QxaN7bYy/eF1lk6yPHNhrjk/bSvcgcgytp0/uggc4Bv=; h=X-Sonic-MF:Date:From:To:Subject:From:Subject; b=pktEyMHA6mR2fwJmDdQwssmLiO+iYcmSWzVl4mJc3Uwz/37A6gOsUJFedSiNSfl4pTVBB5mAZcB2rfi8nFXyEwQdW82Fs4g3lKi1g78J6Zeb1po/SHQlVo+GtP98eKZwFSI1Eo7lcTN7TvG1efxcca7qh9B6XkBHKicGCxtfrPpc6QswUs+rj69OzPWfAqt0QY5NPVjoN0ANL8wH/RWUaFvjKtbA2rGq2GPqpwhyoOU7MpPusQKVzY5ravbfQIve4IdUjHrUpxBBUQtlERLCBHjh1cnOS2fwyBuzWFuEjRoIibKEJsb3YMjtX7klr4UI3MEVHVdyrLlZQnBbFjICTw== X-YMail-OSG: AmpK.ScVM1mv5Jzc0Dm5tjUlUZkjj0ae5rLlXlV8k49pBpN.c7uvdvyiQN9Ma9V WNTVTQkKyJZNmG5sGOfmZP894EQHVRHUQemKBORkCq233ejzqACeucpg8x9VFmqStgzEDkUv4C7D VATqIZgDkbi8uKpyiqmY3NQ2bWNJYWgUxU_3aGxoI1q7i_0AmYxpDsFvkWKVj9HeRKGsMylocex5 FhOqoYkU_lDyz6QHU2PT58D4YP3DGPujp9t9LXIYCm2lKnScIkNgZF7uoWE7xVDfx0rBEPuCG.Lf yc5IAkwu9eOW7cV6M6fGC01ZHimN3rPJzgoZ81dZVK0lXOeLu2J1p.vGzPQ80Iyy4dv6YyBxonee NwVss2DlfzxsGbtLzqpKxeAfX3.fnj_llUoMyF_FOkx.l.1TXXdj2aHkxiNJcA2QKFciGwsL_wv1 qSd894tYHySHHob5ixJRZOhduEcNqKK5aJ3HJGYJPGAchlzqgKcA61be2xZvmfVciV9ZHlfH8277 X6ShUy0n1KmnKY47oj2.7et9pBHnLbVwZ91LW2I3CH7h_o9A49RJrhlBjd2diYGo1IQdXoL8qQCI sdL8Xe6Hux4i24niXC2Wk4175tQBOKrMFH8hkivTynQbRHzox0HjnBrroDLsREUgrkJrGuESbk9R hYpUjRKlZNZQ5wtQ1Wro3j20ReUbyfv25jNuiNtVnqdH8xV.O7_RjvMSDWLI3EOIlb7R9yDM5wvR z1seMhZcH0t5kuL_2aiPm8RlV4M4s8poQ.zoyVYP1KLx5snls.M0Gy1FnuQN0lCv0WQzMS0WC2js vYXdJGeFJwOTbft6MIeON7e7drwj2NcB97agUnqSd0ikVx_SVS77F0C5G5dpAe3UoO0D691NdBPp ZwecwTUnj.c3cVc8AHWN9v9QMnsryuK8Wxwf9DJESShpr1F1vXosJ8jdDSJZXRHpxBclxEjrKR91 J5XKldqyRq4nKT671J8qfU3RvLnABMAvgFWj9X5U1hbKPYvcsE5MWUKPO6gCpXlxNIxbkDtWJCKj aWbcnAFbWAsqmTJRh67YSECHATD4ELiefrLvAn7CzBA6uFrOA5tjuD6sqNN9hmhLY.RdSMknPeeh mjCgZbBWCfA2y0E8lZjOEmP53e4f_wJSAzm56YaJuclA3XfehpdSjaYubWcWYMRBDJ7x19T7lU7I hNPqL4jq1GiepfB7lCxGREP6_RO5_CwtxpHqlIX3WO0Q1AlcCuiBkTFQMsjJ6RiVMC0VNo4vNjLX 3j_ZaDNeMFm_M8v8lJ.ufGNIKI3R56JQZiJGyLVc0Pko96HtIZln5iDQ6P3seSt2MUd1OwFYpsc0 QlfhVIGjQgKvQ3RTa_CtPAaCA4vw.Feccx8.OU2XORQ9VP39KPmy9b8Q6BVz7FRKmFISAlF.bFK. PUGHUrhTT4Plw8jJcFultaLFXa9QzV16lLgR0bXxQESE66m5qNu6dMKqa8kvZVr4hHwKxHZBK2.m z6804zBsiyhHCqBxOWcR4HeInukfWy18NtVz6VlKTSjzifSh0Hz2HDi.J3I6UXbkiCmoXPFyTdqU crAAfh0O61Ji5L221vXL8dOtv00rs8nAArVjsZgac4IEe4.41EETcv8VE1ccGldu44lJfaixC4Zc 8NLt92zywQdXNgpGDNQbweUb1oYCrIfssHTzgpvU.QBZNR1gE3FO.ac1Gg5wayx8iWMGWQRmcIrj f_zN8d7XNqm07AcDSrVGIrX8d29rhr9B8ZKe2VmLTz06OWSII5LdKhL.qOP9rMqPPR4M0ujipFPk 5OejMCQYg_A5e6yrgfkTkM_vJAYlE5OHjll4bgWRIBa.9be9YBXU4HQmba9bBlEfB3wtdtQSvZNj NC2KzpxuF2WV_IotMpVLl6CcljtliPGrjjcgMgnhlf2YrN4_qlhxcdQE6F6qW8GR9LmZ2QDwUOKQ BkHtmEINW9xgnhBxpruBo2E8t7UglbRHFy50g13tpipqviEezdmOmt20azseRTbeihCQNd_Ti8xH GtKpgDHyC_BQK6bk5ePkrexyQ6Co5RFAbUH6kaWsPcFYosSQng045yLYbpuAIPhpggbBy6gfoWnG m1xfT3erHyz7V3lU4.Ri0dcDZRdB2EWlWFlRfYb.9h8oz2DltfoJwzFtes5zmRQRCORAETdwdc0_ BLgyrh4dZ6Pxt.tfQBmNkHDN3YgGkjeaBmOvtiLQBWgG4LrkbF9ODGkfIYS4_lnQFTRrP_nW_fVu 7PBICl2K9Kju_6sbslQRYIK57dWfcvRlUBiX5HzTtBe4eoYaZ2mLMJp.Cc8VQNESrxmi0e2D.TVJ vCcT1.7KN2NGmdq0IOJD9UiUWXQWzm.0LJVj1GZcjf0JSNFdK0qFwdaNVZDHrpqPdKcn9HViEQqb lwba5PxIhUAXVdfS34CuRZIVUlRjrYY.Jy42MD_3DfQV5QmNvD.ErGWklIFRv9C5f2WoTiX7LbWr 6jYoqDPYpuMwAxCIdK5sOFgLqKflKAUJUVqb8C8bHHUNUTXE1bi_sah46dYFhDom8vTpGu5tXYFO 6VLeb6HPGI3tQwqxRmKo- X-Sonic-MF: X-Sonic-ID: de188b58-595a-4c2e-9b41-234b9276cae9 Received: from sonic.gate.mail.ne1.yahoo.com by sonic309.consmr.mail.ne1.yahoo.com with HTTP; Mon, 27 Nov 2023 13:05:25 +0000 Date: Mon, 27 Nov 2023 13:04:56 +0000 (UTC) From: Pepe TD Vo Reply-To: Pepe TD Vo To: "pgsql-admin@lists.postgresql.org" , Rajesh Kumar Message-ID: <491456449.8413239.1701090296494@mail.yahoo.com> In-Reply-To: References: Subject: Re: Postgres monitoring scripts MIME-Version: 1.0 Content-Type: multipart/alternative; boundary="----=_Part_8413238_1748455494.1701090296492" X-Mailer: WebService/1.1.21896 YMailNorrin Content-Length: 5940 List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk ------=_Part_8413238_1748455494.1701090296492 Content-Type: text/plain; charset=UTF-8 Content-Transfer-Encoding: quoted-printable There's a Health Check script to check daily/monthly that provide postgresq= l and os metrics connection and configuration detail status.=C2=A0=C2=A0 Bach-Nga No one in this world is pure and perfect.=C2=A0 If you avoid people for the= ir mistakes you will be alone. So judge less, love, and forgive more.To cal= l him a dog hardly seems to do him justice though in as much as he had four= legs, a tail, and barked, I admit he was, to all outward appearances. But = to those who knew him well, he was a perfect gentleman (Hermione Gingold) **Live simply **Love generously **Care deeply **Speak kindly.*** Genuinely = rich *** Faithful talent *** Sharing success =20 On Monday, November 27, 2023 at 12:07:40 AM EST, Rajesh Kumar wrote: =20 =20 Hi Can somebody help me with postgres daily monitoring scripts or monthly repo= rt scripts or links related to that=C2=A0 Thanks=C2=A0 =20 ------=_Part_8413238_1748455494.1701090296492 Content-Type: text/html; charset=UTF-8 Content-Transfer-Encoding: quoted-printable
=
There's a Health Check script to che= ck daily/monthly that provide postgresql and os metrics connection and conf= iguration detail status.  

<= font color=3D"#8000ff">Bach-Nga

No one in this world is = pure and perfect.  If you avoid people for their mistakes you will be = alone. So judge less, love, and forgive more.3D"Em=3D"Emoji"=3D"Emoji"
To call him a dog hardly= seems to do him justice though in as much as he had four legs, a tail, and= barked, I admit he was, to all outward appearances. But to those who knew = him well, he was a perfect gentleman (Hermione Gingold)

**Live simply **Love generous= ly **Care deeply **Speak kindly.
*** Genuin= ely rich *** Faithful talent *** Sharing success

<= span>


=20
=20
On Monday, November 27, 2023 at 12:07:40 AM EST, Rajesh= Kumar <rajeshkumar.dba09@gmail.com> wrote:


Hi

C= an somebody help me with postgres daily monitoring scripts or monthly repor= t scripts or links related to that 

Thanks&nb= sp;
------=_Part_8413238_1748455494.1701090296492--