Thread: Qsn on Setting replication using " set session_replication_role = "
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 ....
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.
what will be the impact.
How to find out if the session replicat role is in Replica stage or local ?
Re: Qsn on Setting replication using " set session_replication_role = "
From
"David G. Johnston"
Date:
On Wednesday, December 4, 2024, Bharani SV-forum <esteembsv-forum@yahoo.com> wrote:
TeamNeed help on clarification on using" setsession_replication_role "
Assume i am loggging intopsqland issue\o output.lstset 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 fileand assume i come out of the psql sessionwithoutdoing 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.