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 1qWvS7-004hRK-HF for pgsql-admin@arkaria.postgresql.org; Fri, 18 Aug 2023 09:07:31 +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 1qWvS5-009UhF-OA for pgsql-admin@arkaria.postgresql.org; Fri, 18 Aug 2023 09:07:29 +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 1qWvS5-009Uh6-2E for pgsql-admin@lists.postgresql.org; Fri, 18 Aug 2023 09:07:29 +0000 Received: from sonic304-21.consmr.mail.ir2.yahoo.com ([77.238.179.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 1qWvRw-000pFL-UT for pgsql-admin@lists.postgresql.org; Fri, 18 Aug 2023 09:07:28 +0000 DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=yahoo.co.uk; s=s2048; t=1692349637; bh=4QtPGyATvSOJ4BsKPvvpeR/ziQ8gA+DzD3/JKWwuojE=; h=Date:To:From:Subject:References:From:Subject:Reply-To; b=lLrTeP9y4Cyr/XgAlPDyCvEyYkjtz7fu0Rj/IOgpg+BNwM9NNQleN0dhnQgI07sP/X5r8L3Ipo4VouqUuPaply7Qe7383FA9icD4Cyrw43vn4i75P5kUQZkO4jNrHjbqDFShJJ0nPU+L68vL4j7R20IVW309nHdeWEmEeDRXg9mwmn6IS0nJtvmbckf1ATXJyTw5GG7mm72gaIq0nXRApR1qv+wd6nqckS9VbCqrzKnOlWUhlY6RJpfbzl5dUzRqCi494g14YY5fPTRDy9rNnOkKO8yP297u46grb3pNJ2OigA4XJrPqciqp65mefnDy77qOzk/cN1UlOqozvcX4iQ== X-SONIC-DKIM-SIGN: v=1; a=rsa-sha256; c=relaxed/relaxed; d=yahoo.com; s=s2048; t=1692349637; bh=xuDxcgRmlKSFFxHkk0/4Rgl5Ps4SVQ972bnOjW9knps=; h=X-Sonic-MF:Date:To:From:Subject:From:Subject; b=bTDGweNhGWAkxuViLuAuZ5s7UDAENxRRwCXs1QJ2hhm76vR6d3/51YaoTlyhpLF8T4S4x6EueLbq4M5aHtdq0PE80TJUpQAZ2tqcyCAaKX9adz76miLemmwmHnsuBWLdCpXrCaHCrsqFK/J+jsqsoNGwqPpmVepyx60sGY8SC5AC37PnBzOewboodTfmVx9P/eRIEAEKCsiUCsh1FpzzziQnDl2kNaHmReW4BRxv8brpR7MdFpjAvVfpQrl4QPi0gJavAEC76zzK4tWQeHzFEwWQouqQ8Z6pcDW2OL9JavrUrJ7s9QRlKoB+3IxDRXKe+lRlVQWQKpc3OJKNzcSXXA== X-YMail-OSG: HuVq2mcVM1lsP0tWuJmHc_rQsuRaJLOZ.EMnjf3R0e9eMyRJNf04czKLnlOHqs1 jZ0lcV3n.y0lyDMtjRhPEmxcGQEBuq17hJaoojytqd2WSp0Bf7sDErkrWS4bI61I6Q0PjdZ09LVb G7dRM0vI.R3VZzrMHLZgxw85sK2FtN4VTRWC9vCtS5IsyLDWPvCR6qQtR9OylGFey0dZHRu5AMn2 7pJ3omJTOptMIq9s4MyAF13rI1d5l7QDu9Z4xBOa__ZuS8mLbk2ES_RDDn30s3E7tIqYrnm_s41k hW5nCZJ3OzBPcvoEsqNa7aa2JMeynVHwD_Y9YNm9.LOQ3kmRHvx0UMe0yXGjjc_KM_PYpmP.XQGM q3WYTDf5L6zgjwdfy2jDASw.aZPKS87PXvP7QcYFyQxDooJTXTAVC9.IEMn3hhBrsAFu_3WH_MK4 bAYPDHyKNJLxMBlXTJt1Ld2ZxORVRESRU3.rqIGdpqHlnfnrptyNKpdQnqMtuiam6Dts85dOl1h4 m2wDwBAw0WUBbEi4mU7CK2DxZw_dhG9Ar0zMwAaAIUCiC6NCAJ1eDr417Vn4spd27lvrquvbKG87 O0_DdtIP8KW7u69aXCdcrpCXJWrlVy2tGJ3sX84_YXJvgevyhci18YogRyZf9y6PR0iRxUdLondR O1rhnHL8xJr1cv26SFVXdGhuCOSN3Mt97XgAp846gfbflleUHFR_G6alm4WnRwwkBx8lXM5URzIk q.p8j1cFAGDOnu7y6lCECez.2yRp0SXx7B7hogwV7C8G1BsPP3calXGw.KRRaSkLLi_s7Bh84dAe _RWxkhWJmIS9oyMGS7b1h00mqWd8hCjd_N_0HoF6hr89bpuffCyjjSBoBeuizT8gwyPTxn7FreVL TNGn0q1cCyopAxWkRM0Ij84srWupiqZBb0xmmx8sftbMKMYI_AsJSYfGehih4oMvcAcQfT6eSyGS 3xIPh_g3NbRP_x.WwuqOkzdvYEO8JfvQ8kQSWRaCTGiaAzGs5nFM9vhOC_dD0jIWKi4uD7J6QZsL 0E1qnV1MGFwYsEYUB8444xF4gb9Ufop6r24c9.aD19SPyYnZlOOurlygi78cTYmpWaP3dyN30x7V Fw3ytgrwrP3kaTm3jdi3Po.0UQjLOGiftzkXY31fTUym3mCr3yRHq2FRpBCGQ4cJT5IfXY1xabyD E6.Bb0Z4eXjFoNm7x4O2rD2nk3XBcne_lNUsJSgLZoHXnPNzl_2pUSRAdPzdBOivvqL40UIROMaq v5YcmZ1QZVLmEYEvjcekPTS7t3qxQPaoEgN2X6rHA_1GVBvUKI.MfcL5SIvQMCCioeANQCuvlPNU LR2JbtsI.Y6Ni_gNSxTe.mbD1toX5l8zskwQrrt6tG.vtx2U8a6Z7wtMCNho.3_x3jp_YTEB2u_d 0lY_tPwYEHqRVcxMyzJ23F3NroAhnSB_0fAz2m1yhlC2TwXdQKByslBXU3CUZZGOjz67MZ1.LrNd so1MaYt90cH09sSqMHfblU6W.AoWZPTaSDsNz4O4QQvNvl9ETlyx22Drbxi8IUGW3M4UOKZp3O7P jkkO02B.Q5ShxZEsCvCZi1gRzHXxM7WdQByiTXdUW7n4mNh2YUS7CHw56F6DGvR.ggl.PsfqZn4l 4MecHGw7hfHohw0yUbvxn8INyL0lVqb_8KzvHJ2nMq836uNJLoaHxz3d0C6KxGt_Ke4oRLzrWou5 TQ2gpxyu4nNV.R_E_B3s1zBJhhMQvCG18jdOkd8wJiXAmO4ld9fsiqyw5JU83kSqubc7HT0zYPm1 5J3uzG0RSy.IPGUWZsZ4KbgoF4_T1xpfjs4nfCdD0MjaXme.Q6NHV5c2OQkpBjP_QBHaD2Dx5VdA vmszFgofxO1_OGo3aeu42ui_QUP1WPfZjZ8YTx3Eh0oxf0.lxD4DFKb6pKNOhgajrtnKTrLu4J4L 6ChvzvakEu9MgnW32gmZXWAZfXUlQOonn5avzTMnEtcTzJeXeKC.lmZHI3Rvpp0n_oVx6tWM4.71 cM6rijdjZpgdguCCjGJichFE_ns9PXDboAJ9NqbOZ0VO12eZUlFJXfksIIcAJsce_JjCYb2MCZdZ aO1vhRjPM7sB8Yon.LMbTFeQWWhJy4LjXW_tqn8NFTUr1KUswpgf3uZ.ymhO9J_3R4K5mmRgeGtm iVnDiR.soH1vqRosW5eIY8PRnrRNhoTqtXxM_TgH415ZubdctbLHQFv.XoTs0fJHMYof3mcPZSLR unMKrdLojJW2ac1h9Yxv887W2bSWEK7bIyUAhFFGPVwe_ZQp9m1sunIIEmxam0H4ZPuhgZfz3TSX 8PQ-- X-Sonic-MF: X-Sonic-ID: e4e6729f-d50f-414a-80af-e1975580a8c8 Received: from sonic.gate.mail.ne1.yahoo.com by sonic304.consmr.mail.ir2.yahoo.com with HTTP; Fri, 18 Aug 2023 09:07:17 +0000 Received: by hermes--production-ir2-5cc57b9c45-xgg42 (Yahoo Inc. Hermes SMTP Server) with ESMTPA ID 2d0ca5228f7d3f3bdc74483c76d4e397; Fri, 18 Aug 2023 09:07:15 +0000 (UTC) Content-Type: multipart/alternative; boundary="------------is6xRhdGJX00LsNJJhGRlSoZ" Message-ID: <3e072d55-a260-d4aa-0ea7-0ce395e359eb@yahoo.co.uk> Date: Fri, 18 Aug 2023 11:07:14 +0200 MIME-Version: 1.0 User-Agent: Mozilla/5.0 (X11; Linux x86_64; rv:102.0) Gecko/20100101 Thunderbird/102.13.0 To: pgsql-admin@lists.postgresql.org Content-Language: en-US From: lejeczek Subject: tell master to tell it's the master - ? References: <3e072d55-a260-d4aa-0ea7-0ce395e359eb.ref@yahoo.co.uk> X-Mailer: WebService/1.1.21732 mail.backend.jedi.jws.acl:role.jedi.acl.token.atz.jws.hermes.yahoo Content-Length: 1110 List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk This is a multi-part message in MIME format. --------------is6xRhdGJX00LsNJJhGRlSoZ Content-Type: text/plain; charset=UTF-8; format=flowed Content-Transfer-Encoding: 7bit Hi guys. Is it possible to configure pgSQL to announce it's being a master and not querying it? I was hoping for a file whose existence or content would confirm that and would be generated/created by pqSQL itself - am I too naive? many thanks, L. --------------is6xRhdGJX00LsNJJhGRlSoZ Content-Type: text/html; charset=UTF-8 Content-Transfer-Encoding: 7bit Hi guys.

Is it possible to configure pgSQL to announce it's being a master and not querying it?
I was hoping for a file whose existence or content would confirm that and would be generated/created by pqSQL itself - am I too naive?

many thanks, L.
--------------is6xRhdGJX00LsNJJhGRlSoZ--