Re: Qsn on Setting replication using " set session_replication_role = "

["David G. Johnston" <david.g.johnston@xxxxxxxxx>]

On Wednesday, December 4, 2024, Bharani SV-forum <esteembsv-forum@xxxxxxxxx> 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.