Re: Qsn on Setting replication using " set session_replication_role = " - Mailing list pgsql-general

From David G. Johnston
Subject Re: Qsn on Setting replication using " set session_replication_role = "
Date
Msg-id CAKFQuwa96VUADGXCzKn988Gd_JO=s8aeERmSyQM2UXYqw8FpjA@mail.gmail.com
Whole thread Raw
In response to Qsn on Setting replication using " set session_replication_role = "  (Bharani SV-forum <esteembsv-forum@yahoo.com>)
List pgsql-general
On Wednesday, December 4, 2024, Bharani SV-forum <esteembsv-forum@yahoo.com> 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 ?


David J.

pgsql-general by date:

Previous
From: Bolaji Wahab
Date:
Subject: Clarification of behaviour when dropping partitions
Next
From: Ron Johnson
Date:
Subject: Re: Help in vetting my steps for Postgres DB upgrade from Ver 13.X to ver 15.X