Received: from malur.postgresql.org ([217.196.149.56]) by arkaria.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.92) (envelope-from ) id 1nCOCt-0001o3-KH for pgsql-admin@arkaria.postgresql.org; Tue, 25 Jan 2022 15:58:07 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.92) (envelope-from ) id 1nCOCs-00072z-D3 for pgsql-admin@arkaria.postgresql.org; Tue, 25 Jan 2022 15:58:06 +0000 Received: from makus.postgresql.org ([2001:4800:3e1:1::229]) by malur.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.92) (envelope-from ) id 1nCO9m-0001FS-TW for pgsql-admin@lists.postgresql.org; Tue, 25 Jan 2022 15:54:55 +0000 Received: from sonic312-20.consmr.mail.bf2.yahoo.com ([74.6.128.82]) by makus.postgresql.org with esmtps (TLS1.2:ECDHE_RSA_AES_128_GCM_SHA256:128) (Exim 4.92) (envelope-from ) id 1nCO9j-0002Gy-L8 for pgsql-admin@lists.postgresql.org; Tue, 25 Jan 2022 15:54:53 +0000 DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=yahoo.com; s=s2048; t=1643126088; bh=HOqkJxQyri3V2SS+5BzqzHZERXeDj/1LNOZ0S5llTH4=; h=Date:From:To:Subject:References:From:Subject:Reply-To; b=SMyruV2xqlr/BtCZC8bdzKCa3O39uof9l2U7MLFKfjNpxxSTxkMesKKj5Mx9Ce1dfzwBJQopSpHa2UfO0PPXc0L/osigiJnAUwXGeyvdbDJnIFIEARdqUm/HeXhGAs6Qg1uIE+GED4LVsTW/97cQ7hmPEMvD1tzr8XU/vtj0/dHNc+HdjI7ziMx+InsqlvSL97cWKNDWKsPk0pxyhxVNo2w0W34awguRLVKFWxQYOKBcJmH4BOwdrVkUe/qXhujgerRqyLA8RLfLclDa4TE7jGjGBfOvZmLIFBnVrFO1YQJA0HZHtiFLJ1iz8RCFDyS/Cw7u/K4m7qip7Ml13IClLQ== X-SONIC-DKIM-SIGN: v=1; a=rsa-sha256; c=relaxed/relaxed; d=yahoo.com; s=s2048; t=1643126088; bh=vGEBQPW+4qcCwxNsu5GycYuKdpcw7PsH87uswFlXH6x=; h=X-Sonic-MF:Date:From:To:Subject:From:Subject; b=JfRsQDnk9/zYIXTuRRxsFIVsTJW9Iw+HpYbiCBa3O85R9HcET3hDbDTEtLRWZtmBmJtlFpF7PDcMaGYmbjiA6sVX/8JGU4d7l8yahktEol78HUOluMXI1UhGNH78mkignuK/vwjEZBlEWSjqpoQEfHzuGe/w3yXZ1Eafc3R+pjBpMcM1kN6okgP/GXi07NNZ0234GjWJkcZLIJwwxl+0hRrZeaQhjm4uRiDFmZemffsJda2WJsspvVrcjTZ6zrB9041gOBzcDWDB/+tcesH8vrQms2yMoQdX0np2sDrICvtt+vJkproHP5RDdvjEcc7oZEkzdE11w7ca6wP1R8rcbA== X-YMail-OSG: LKEZG1EVM1mnU79e_SzoFtR5s.9ln7v4VNTGnkW1R1CAS569rKm11YyUMTBVTkw ODXnSFlen2tV.1i88CQ6DPgSai28GyRd2wPR4U8lUc1HR3HCNIn72l7VBcizXGENNU.Hte9UeQx8 U2fGqD.wqTb09MiDCkwv5Qe5Bu6gxsfsTvfrqURzqqe3FZNKrPeiydgod_7RQzRw60XTUbPrj0zD cSenHoCBUPboINhBK6NchPI2xfbqbMsPmTRU88WIqrPC9a2JvS13NADqsDIUBZF6nJ_Z_VrvIBvN iAbaT0RK_FTR.0ZAHUY36DEURUBgTR1UHJt5heysGn4REedswRbT7NEBqdZ13hTN7INtJqH8g6yY 7uiVi58qFEFuOHtxdx38X77iXTaAL7IMYV7WD6oiW1RNlDj7EmQnC4sVTc6EnQIi_Q_wzcMGnziX EFmS8BdywfjA8WiY4iKTS5B9RjxBD7m9dqvGIHJzdNIkwiLugm8VdZf2rqkBusGv8f9tCoHPVQ6W ZG5CJmDE0ulVCD8HX0.3RxghxoIhr_QIV_vLeO1wPpcBHmRgUeTPIpAMSZCMujTDr6c7AXdCdb4a jABzrYEOm90R122Ah99ChveutKo35vWRDolMBVJFwLMi_3Frgqh7rheQAZ8HWoS40FfXzASztjXH NRZO__2SLec.ZlOcD1aa6UWQf9Y5Jkz9ldLuq6lfL3wJj5T8GHwLzLrNDW6lMHO37eQX6z0wtm4O QfcPTB_dFqeMIiny9384vmdWXofmdbJ_joD5zNQOfzw68uYk_x_WB5Jjf5mD2I4.HS8S.ov5B.0B MzjY3bPP3w3.ZKyGiYsT43HQD7B5DmJA0J8KrbqVXoTBXao06knBj66hCNzB7iVqJNQeMO9U0muX tGSfm6C4SGExfUv3tCERrSBgG1Geghmb52bFFj6OpwEYLMNWNk_RsszwYuvWAxlELIbZyAMcqRf4 1.2IrWKTijYHfbHsKm1sj.K023.Qbvqca9FtgEn8InJwWrGGfThMHDqPFyphkMe7KNB6Pqo_m2ys hbL74pIhnLwlK3rkQycUKmS9VIZ8UrE2gWq9xIS1qYs4CxTtnIrLXIpu4dNLY2A5ItxTM9LTSzB_ qMAkNZkViUmL.ZR9rM6HPI..ArFTZBTdWUZ0eyHgB30x1Pl6KlWK7IEnbUaTFfQaW4gOB4.Uo9k_ 4cEcTsDBsZqdLAFHxR.lmXn2M.X9oVcy_i6nY.qJg5eswhNPDDVQh6etH827VTJgwxOjsX53wzH0 PQacY9XbaK537cXUwGCS_gzbidFLYrZZXvYxETecmRmXQudEHo.lgn40k.V5TWCYOxOD18A1T3RN TDyRFOKX3I9UiKN6BH4i_IyOo_2A16BAcS6f.fTzc0hI2eRwg_o0kg6kIV01uOttDk2Fgb4hY79s q.DCn0.jis_uhXtNdJboWOEzQUp_SZiQfJ7.c_VDXhvgYbCMT31QZLU2YB6wCW3zstc_zOxswxtq mL9rLSb9bSMB.elBstyKFRXHKPnOf24UE1ezWqEkPTcMo13Om7dyUTF3b0pQI1JJrfnEq5IzH5Ze 2Lg9jJCuky.EzysVSbFGC3bpeHRzdxEMKpKVJ5uZnRpZlNVI3Zyd3DdynbVfn4W1cSKdxhWVjEAv dV.vJnbU3WOk4iIJ3cyEKxbsUf.S7sfYAuJvYyK2ajfa0.EHOcufZL6HUO.x5VHR_rS_DEDyzlAv C1AAzS9V5R7nenX8my4BCLnElsb.O8.5jYxvBpaQ.qYcDwwSfvvM62Rkj2foPy9TvmDp4bPA2tFp khd7sjkIli1xdWvqBWsomuPQQhCxB2ubMtOIOxJSMNrYPXVmiCAlvszI6.niA4aIWpQTUkyTMgpH Jwfh6ngiYIb67crgvIwqh3G0BcP6GTdZIOwOurXneDQXvQfiMObXD1fasB0delvxhm1S0PR1jWrI 9oNwS3efxTMzz9HxnoyLS5yk7aFsSsrU_V1GRyxNsnBSihfjCD1Y2z7uaG4sxDvm44fklVYoxXId FO_1j3WGSjjbEsMVCV9FJ2IX0YCBiAgiuz9SlQHhLAFyqwtX_HifPkw53VGHogsNrs4hjgPRUc11 l.m6VCNEfMNEf75._PAg5UDiVuyFIezrJLnwN1K6peYDUmg89B_q38m9hA.6VYCLhqLfw2Q82EDI OdYnYpIAlUSALR1c4qt8GtxQipa03k6Lg3b8MWeoI76mG5vuWAminP7ICKxB.vpsxsNGYwCTDkOU RXprjZaVPc.cM9ptzJCS29jk- X-Sonic-MF: Received: from sonic.gate.mail.ne1.yahoo.com by sonic312.consmr.mail.bf2.yahoo.com with HTTP; Tue, 25 Jan 2022 15:54:48 +0000 Date: Tue, 25 Jan 2022 15:54:44 +0000 (UTC) From: Chris Cawley To: "pgsql-admin@lists.postgresql.org" Message-ID: <1687462832.923336.1643126084620@mail.yahoo.com> Subject: Question about blocks. MIME-Version: 1.0 Content-Type: multipart/alternative; boundary="----=_Part_923335_703605016.1643126084619" References: <1687462832.923336.1643126084620.ref@mail.yahoo.com> X-Mailer: WebService/1.1.19615 YMailNorrin Content-Length: 1217 List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk ------=_Part_923335_703605016.1643126084619 Content-Type: text/plain; charset=UTF-8 Content-Transfer-Encoding: quoted-printable All - I have the sql to check for blocks; however , it is per server or per datab= ase?Do I need to connect to each database and check.=C2=A0 This would mean = that Ineed a list first and then cycle through. ThanksChris ------=_Part_923335_703605016.1643126084619 Content-Type: text/html; charset=UTF-8 Content-Transfer-Encoding: 7bit
All -

I have the sql to check for blocks; however , it is per server or per database?
Do I need to connect to each database and check.  This would mean that I
need a list first and then cycle through.

Thanks
Chris
------=_Part_923335_703605016.1643126084619--