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 1tIpS9-00Gtx6-6e for pgsql-general@arkaria.postgresql.org; Wed, 04 Dec 2024 13:30:05 +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 1tIpS5-00HKFB-Ql for pgsql-general@arkaria.postgresql.org; Wed, 04 Dec 2024 13:30:03 +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 1tIpS5-00HKF1-FT for pgsql-general@lists.postgresql.org; Wed, 04 Dec 2024 13:30:02 +0000 Received: from mail-ot1-x32c.google.com ([2607:f8b0:4864:20::32c]) by magus.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_128_GCM_SHA256 (Exim 4.94.2) (envelope-from ) id 1tIpS3-0011Bt-5K for pgsql-general@postgresql.org; Wed, 04 Dec 2024 13:30:02 +0000 Received: by mail-ot1-x32c.google.com with SMTP id 46e09a7af769-71d51a9a42bso3104029a34.1 for ; Wed, 04 Dec 2024 05:29:59 -0800 (PST) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=20230601; t=1733318997; x=1733923797; darn=postgresql.org; h=cc:to:subject:message-id:date:from:references:in-reply-to :mime-version:from:to:cc:subject:date:message-id:reply-to; bh=k5+Jx50/7VeDQsxpFd2O1Kl9NzT1bipmThgPLg/OzdU=; b=lw6Llo8KA6Mo5lB2bgpZ1HIqy6fGuVnhd5IAODAxioMJtrj6ZpleTSmZLN3DOLVwux 3k5bc4cq4wf6bxyQFNrocZ3vSMmm1UAHlyVWeOqWoKgFF+mj1iifcA6BdfQ7EV6s8UHW p/qvp1seO0fkHYna+mLduAnDlZBp4kWGd3ZTlx3g3wQfc9dg5lQ+y7dmwjCwfWPuYLnU ZRbUrc+7vp5mf00K/NR6odpvIUxDb/DwVunoRzoSyH8ed6orhGw3JKlYyfTK/7SLS8Hi a/tQVS0hPmOLQuUFiNeJp2iyH+EBQgVx6T9QC7jk19qCA95EE5J9EFpWE2HWYcyEB5Ta 8RBA== X-Google-DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=1e100.net; s=20230601; t=1733318997; x=1733923797; h=cc:to:subject:message-id:date:from:references:in-reply-to :mime-version:x-gm-message-state:from:to:cc:subject:date:message-id :reply-to; bh=k5+Jx50/7VeDQsxpFd2O1Kl9NzT1bipmThgPLg/OzdU=; b=ksg4LE9kTZaz8kc2hmdjiXnulxLW5dnx9co0QiFdxvSKbjbHfATm2+Rd4HCrLnwG1O 0IWaTQgsPaDzLCeUoUyBkHXFI4wdhyC8a6QZeLL0bYgiKg16vXdehLY41y3T3KF8o91s zyYvwTM1CBxFxY9dyWf8bNRUGQDvt1TFmXCDBjk/NkPwQlRbozZ4eT6YqDUSH8egpwP6 kU+W44lUiEik25V0cuel+1wwIt/j1ZOzrFni6aBx05nr59YD+v5pjM5uPuRZ6UT9Rerx sYHGQ4oKUza+QMhItcsthBDwDXHAc//FlLkDurpAOt7ncXTpgcQnc4cf3GuFgm4x55Mf IIxQ== X-Gm-Message-State: AOJu0Ywp75le0+bIdBpaD+fWNbRzVwfiw2/EOe/nmlVchCd54DDYXy2G IX3EXZYCFPsnRAqKXfHy3Y3SxpaHZOEOXfRmbBHH7ved6CRJvzYXt8mrDPMuyr5Zc46JIqkuiFR 6xZeaj+5PaJP9ubf55lrxrJWXqw6mhbCs X-Gm-Gg: ASbGncvqJzUwqYDLq0D+fFKdfp2dgMOg/rmI4zbCFWvksd6oSqbIatSkV5ul63MCtGA YqXIIHauttbJhq+BKW8xXxI28S2Cioo0= X-Google-Smtp-Source: AGHT+IEm41bCA3aFMs3Dga9NJq45KTyFvvmVBVpdUMi0HKC7IqCyfE2ehwOESJGz2gg3JQq3YwliRWuN+6iadXh3Y0E= X-Received: by 2002:a05:6830:b93:b0:71d:4a91:9208 with SMTP id 46e09a7af769-71dad68753cmr5396896a34.17.1733318997334; Wed, 04 Dec 2024 05:29:57 -0800 (PST) MIME-Version: 1.0 Received: by 2002:a8a:5e5:0:b0:56c:c9af:3ee6 with HTTP; Wed, 4 Dec 2024 05:29:56 -0800 (PST) In-Reply-To: <1028265449.5830238.1733314802260@mail.yahoo.com> References: <548541174.442598.1733314635403.ref@mail.yahoo.com> <548541174.442598.1733314635403@mail.yahoo.com> <1028265449.5830238.1733314802260@mail.yahoo.com> From: "David G. Johnston" Date: Wed, 4 Dec 2024 06:29:56 -0700 Message-ID: Subject: Re: Qsn on Setting replication using " set session_replication_role = " To: Bharani SV-forum Cc: "FN_pgsql-general@postgresql.org LN_pgsql-general@postgresql.org" Content-Type: multipart/alternative; boundary="0000000000001e61cf062871c792" List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk --0000000000001e61cf062871c792 Content-Type: text/plain; charset="UTF-8" On Wednesday, December 4, 2024, Bharani SV-forum wrote: > > > Team > Need help on clarification on using > " set session_replication_role " > > Assume i am loggging into > psql > and issue > \o output.lst > set session_replication_role=default > update .... > This seems like a bad idea. Why would you do such a thing? > coming out of \psql command and verifying log file > and assume i come out of the psql session > without > doing set session_replication_role=replica. > If you logged out, the session no longer exists so anything you did to configure the session environment is no longer relevant. > > what will be the impact. > How to find out if the session replicat role is in Replica stage or local ? > https://www.postgresql.org/docs/current/config-setting.html David J. --0000000000001e61cf062871c792 Content-Type: text/html; charset="UTF-8" Content-Transfer-Encoding: quoted-printable On Wednesday, December 4, 2024, Bharani SV-forum <esteembsv-forum@yahoo.com> wrote:
=C2=A0<= /span>

=20 =20
Team
Need help on clarification on using
" s= et=C2=A0

session_replication_role "


Assume i am loggging into
psql=C2=A0
and issue
\o output.lst
set session_replication_role=3Ddefault
update ....
<= /blockquote>

This seems like a bad idea.=C2=A0 Why would= you do such a thing?
=C2=A0
=
coming out of \psql command and verifying l= og file
and assume i come out of the psql session=C2= =A0
without=C2=A0
doing set ses= sion_replication_role=3Dreplica.
<= /div>

If you logged out, = the session no longer exists so anything you did to configure the session e= nvironment is no longer relevant.
=C2=A0

wh= at will be the impact.
How to find out if the session= replicat role is in Replica stage or local ?


= David J.

--0000000000001e61cf062871c792--