Qsn on Setting replication using " set session_replication_role = "
TeamNeed help on clarification on using" set
session_replication_role "
Assume i am loggging intopsql and issue\o output.lstset session_replication_role=defaultupdate ....coming out of \psql command and verifying log fileand 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 ?
Import Notes
Reply to msg id not found: 548541174.442598.1733314635403@mail.yahoo.comReference msg id not found: 548541174.442598.1733314635403.ref@mail.yahoo.comReference msg id not found: 548541174.442598.1733314635403@mail.yahoo.com
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 ?
https://www.postgresql.org/docs/current/config-setting.html
David J.