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 1tIoMX-00GmQ9-Jr for pgsql-general@arkaria.postgresql.org; Wed, 04 Dec 2024 12:20:14 +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 1tIoMU-00GuD9-Af for pgsql-general@arkaria.postgresql.org; Wed, 04 Dec 2024 12:20:11 +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 1tIoMT-00GuD0-VC for pgsql-general@lists.postgresql.org; Wed, 04 Dec 2024 12:20:11 +0000 Received: from sonic321-25.consmr.mail.ne1.yahoo.com ([66.163.185.206]) by makus.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_128_GCM_SHA256 (Exim 4.94.2) (envelope-from ) id 1tIoMS-0010IF-Jz for pgsql-general@postgresql.org; Wed, 04 Dec 2024 12:20:09 +0000 DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=yahoo.com; s=s2048; t=1733314807; bh=9i5c5XFlcfCIMFOgY8ON4i7CtRRwxKwG37JvsIV+oGQ=; h=Date:From:To:In-Reply-To:References:Subject:From:Subject:Reply-To; b=qtBLbTuEptINaTL7Ph+ejaSyGK5g2LP7R0O+Y5ebSkRtblwUXgn19gqvaHM+ORxHwww/kFhJox6LT34o+XRb7RvGnw7zUXD4gTGczIbwhO1qELUK9bDi1t+m0WMLgl95KPkzHgF3+mdewXHlyXwek0pidyZZfsywLYFvAr9fEC1si5SnmJGRJv0RtX6D1Rpq4aJOLDFFGwChUjzsc4nm44shIuKML2z36Sw7Z6kkL09/t1DQykAMAMXQmpLf9n/y7eeg9KRsy0iAjUx6pNC08esruav1hz44wNdj5anJuF01R9o+LF9xuo0Qotmrui9X4yPwtucFb7447iSs1f7KTQ== X-SONIC-DKIM-SIGN: v=1; a=rsa-sha256; c=relaxed/relaxed; d=yahoo.com; s=s2048; t=1733314807; bh=YQiGyMF2V5+ooKxAOomk+/DQuDoGyJo6hAK7eIsIduV=; h=X-Sonic-MF:Date:From:To:Subject:From:Subject; b=SIePKZBYVrFAZVMbeTTtu9zU03iUMUx7/EfB5HX/uUy4PpFfEjKe0jOuiBjeXeYjZwHIeqWSRuC01hb2ewjxvzJk+/WoiuLFYuTsYsLdnYFrSxYdCMk62pQV0B1HGqRNTpqmYrhAJSU/pYBa2WaNSVhh2ww4DW8aXOAa1rqm0pN89xSGWF88gs7Vkx2Poildvuoli7BfHo3y24oNfWE2WoBM8Q+qwFDBF4j+/NlLPFaoeoHgJG66In06ZhN0FhsICXuwRcM+nXcQm7JmfsXtE50SJd8A9q/UoGDKZXUvibLCBWVcQuIAbxijwEB2X2WgCaxENK73i8R21sv+ldZ8bw== X-YMail-OSG: fBfHLX8VM1lrrXJ9wf9DcLmiFiKlIW3OwmduqJszCGD5mIvOLbazNuzIu52E3bM NJbqVzFrdaOO9EFDK.6PzR_BtRrP5wiAL98RR.wTh7va_a9XH89K_.vhDTy3NaQRZ5XijfmsHVod M65TwDBg_FBjrZRYO19cPHzjV5uOslsl3AGlX3LY883ovPniR.Ja3hcxxbFWXBcazKfnPNc.i7ad WumOHgHlu9Szesco5xSN.sM9MELW47cqtLIywWqSA77F8jZrSr04rgP.pmAWVe7uaW3Dx_Fm8HQ6 GSGuyytfmwSKh7QUytrz8bywUJ9kZJshvLIVYS88Gx5Wc_yCImMIfl5GJ0rCt1eDOy2vmK7Z.TFY MJqambXyXMeeYRsOgxWYXORgoDxl_A.u.HmAoDHdJ0T0GGUhQ2JZ13U.aPmXbqiup.rTAOM3Bhd9 lqn_y_xFk0yAWZk2KqWqM0v5ibkzf5C6CRDR4c5acB00GzAN9yWzsUeIlNiCnqyuJQnyexyUpwFM Zz6WWnNlum9BYwx0XQGJ.NifxEg9hd73x.rQCp4fgr90l2H_l_frKECO_m8DxW3ubNs7tBV.5VTa upMaoKk.6yVSXgjTXLD3Zag1hl6fhgnX7rrF770WEYo3yiFREWp0HjJCKOJ7R_v.17lXYqrWHE_g LNgaOkhnnw.Ch_SsEwa2mbcq0JVMJwatTljSpx73hHiN9GGoP3Lt34JQ97mYRxJAovTdb3q8n4ey 54RSHFi2yIl2LrtoZki1wuezptXgLaW3oAd56llvobY46xhOiO997WoZnne__d6l0DWJtq63RJaz 7p7UsZ2o6YsGrxEnmL4NJpQ0YBVXnTmeJsHGborJKtoouJk9MRzFN3pqwtZ7fX4eqLoT5sCQ_.g. CiPK7Expow88_59v5MMKtOYjQ6XCYFCo6mTufV9EOOloEezrPbmFuNCtFV8wy.C26D5XcT1Mtx0U Vu.3yq6T5DQIwSpqtk3jDhE9OBSvqv3rFQGHFAO_RWUZoLY3PyndMSgQY7yzSPIWXVvG_Z40qqps 01mgul1Qk3HKQLK0SM9CAJNyqgNt0N0nwUmOwe9kNcq5z.fdsyDpscjc_gxy.MqGF0hXrX_MYg8P FvyDFz1ILuQo67Fp6IMD.npU0Vs_wz1DxNtKg3ASqUpW7KhrpFJ5gRY1Jby8ab0QUdvuBhHGgQws sX_wXyYYmVmszP3_FCrSPAQTQE.wwV0f95.O.C7NTBvjflt1JwzJ8o5B2LwgO3YZ2yC5lLrDpb2u Gldh2D4xJvpOFeOxnnLRWL7bBS.ZU60zTTyoNDu8nImViebq.8cWwD0LunsQ5oQCpjqFkygTMb.9 odDOHr.Z4_6qOKlTUfn4Qr8JAHUNtRbxJ0zGKUIX_kZju3OlpsBeAcI0h2NkhmQ_VXB_S4EBymCs VserkVL91I4hM85Xiermj3Vad87FGkyzA8UkLyFIC0XoMiq8relWjyZK1UXiXiWbKdh65QnD_Vps eqD0F7SO9T.eUeitrFNZgzqRIYva2BKyOJjup8mhYSPZIbctQUi57yR6rcMr.2EszfU0fbYMMZTw hh2Jti7mwrsm7pU32lJq6ON1GSGT4efQ2oUTw15.83nJiuSe6yr32Fz7OMfp6bi2wD3n4Z4fsEU5 Tjj4u0RULNZ.4Pqh8z7gSDxz6QrS9M7GkwuwFRUdm9mwx4QRtycYKFXtogspQazq4r2.3oP0D3jB SFFfABwrGNysTI89ZaugoMAxHKk5KIzpWjUhfM8kutObFZVpP2DXDE4NCbcgjOCXVu7wS6Yv_dIe 6ykEN9NJ1apCOGA9dAfugrluaUgTc6o1ywNKth49UsT3dx.kKkYLZlLJFPINOKBZQCFzNXJHiqG8 iHohVAavNcO8dK1cZznx4x0hJGopsF9CZgSKh4Tsew2ypyK5IC0H6riuaDNkjJalgA7roH9exOkx .GOsJn15K0xm9UYDsRZ.kda2gOPhhElxDYrn8M7p_skOXC0lDoPMFS5MDlrWn3G8xrpDudPoTVj1 xONA8ewndIpy1bbUp7AVnWlqrxdTNlVwblExN5flOvm5r_O9BDoXkR2LtG87Nrq2kKcET0CfBKYK KPSezSBQFUBDWVD.D2009LpBFMv4L0OFEYpREWFLitV1IKJfdZ.xOXZMfLZ8eG77I_8trQ7C2rkQ 6R.AiSCsdBFWIoFkrJS7neCGw_9WWGFxkvInRnLeldgkUOE86ezlL02PjQmrYYuirBkGqgaTgbg5 VIpC8_ULaKagq7xYDN4GYi8mZD_YqcbZ7qpp7Qj1v7ioE_pxbkPODQXw5pPCYIEMdbflOxk03E_L THzIqrLRenqZ12DtJ92F7E777bZBo_5Oj747_3tDuIOijcO5D5RcbKI2acgV7p4G3F1oUmil54tA - X-Sonic-MF: X-Sonic-ID: a773575a-568d-4c40-8baa-c818d7442d44 Received: from sonic.gate.mail.ne1.yahoo.com by sonic321.consmr.mail.ne1.yahoo.com with HTTP; Wed, 4 Dec 2024 12:20:07 +0000 Date: Wed, 4 Dec 2024 12:20:02 +0000 (UTC) From: Bharani SV-forum To: "FN_pgsql-general@postgresql.org LN_pgsql-general@postgresql.org" Message-ID: <1028265449.5830238.1733314802260@mail.yahoo.com> In-Reply-To: <548541174.442598.1733314635403@mail.yahoo.com> References: <548541174.442598.1733314635403.ref@mail.yahoo.com> <548541174.442598.1733314635403@mail.yahoo.com> Subject: Qsn on Setting replication using " set session_replication_role = " MIME-Version: 1.0 Content-Type: multipart/alternative; boundary="----=_Part_5830237_509573072.1733314802260" X-Mailer: WebService/1.1.22941 YMailNorrin Content-Length: 2659 List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk ------=_Part_5830237_509573072.1733314802260 Content-Type: text/plain; charset=UTF-8 Content-Transfer-Encoding: quoted-printable =C2=A0 TeamNeed help on clarification on using" set=C2=A0 session_replication_role " Assume i am loggging intopsql=C2=A0and issue\o output.lstset session_replic= ation_role=3Ddefaultupdate ....coming out of \psql command and verifying lo= g fileand assume i come out of the psql session=C2=A0without=C2=A0doing set= session_replication_role=3Dreplica. what will be the impact.How to find out if the session replicat role is in = Replica stage or local ? =20 ------=_Part_5830237_509573072.1733314802260 Content-Type: text/html; charset=UTF-8 Content-Transfer-Encoding: quoted-printable
 

=20 =20
Team=
Need help on clarification on using
" set 

session_replication_role "


Assume i am loggging into
psql 
and issue
\o output.ls= t
set session_replication_role=3Ddefault
update ....
coming ou= t of \psql command and verifying log file
and assume = i come out of the psql session 
without 
doing set session_replication_role=3Dreplica.

what will be the impact.
How to find out if the session replicat role is in Replica stag= e or local ?
------=_Part_5830237_509573072.1733314802260--