pg.ddx.io pgsql-general@postgresql.org mailing list archivehelp / color / mirror / Atom feed
Qsn on Setting replication using " set session_replication_role = " 2+ messages / 2 participants [nested] [flat]
* Qsn on Setting replication using " set session_replication_role = " @ 2024-12-04 12:20 Bharani SV-forum <esteembsv-forum@yahoo.com> 2024-12-04 13:29 ` Re: Qsn on Setting replication using " set session_replication_role = " David G. Johnston <david.g.johnston@gmail.com> 0 siblings, 1 reply; 2+ messages in thread From: Bharani SV-forum @ 2024-12-04 12:20 UTC (permalink / raw) To: pgsql-general 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 ? ^ permalink raw reply [nested|flat] 2+ messages in thread
* Re: Qsn on Setting replication using " set session_replication_role = " 2024-12-04 12:20 Qsn on Setting replication using " set session_replication_role = " Bharani SV-forum <esteembsv-forum@yahoo.com> @ 2024-12-04 13:29 ` David G. Johnston <david.g.johnston@gmail.com> 0 siblings, 0 replies; 2+ messages in thread From: David G. Johnston @ 2024-12-04 13:29 UTC (permalink / raw) To: Bharani SV-forum <esteembsv-forum@yahoo.com>; +Cc: 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 ? > https://www.postgresql.org/docs/current/config-setting.html David J. ^ permalink raw reply [nested|flat] 2+ messages in thread
end of thread, other threads:[~2024-12-04 13:29 UTC | newest] Thread overview: 2+ messages (download: mbox mbox.gz follow: Atom feed) -- links below jump to the message on this page -- 2024-12-04 12:20 Qsn on Setting replication using " set session_replication_role = " Bharani SV-forum <esteembsv-forum@yahoo.com> 2024-12-04 13:29 ` David G. Johnston <david.g.johnston@gmail.com>
This inbox is served by DDX for PostgreSQL; see mirroring instructions for how to clone and mirror all data and code used for this inbox