Postgres Pro
Downloads
Home   >   mailing lists

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

From Bharani SV-forum
Subject Qsn on Setting replication using " set session_replication_role = "
Date
Msg-id 1028265449.5830238.1733314802260@mail.yahoo.com
Whole thread Raw
Responses Re: Qsn on Setting replication using " set session_replication_role = "
List pgsql-general
Tree view
 

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 ?

pgsql-general by date:

Previous
From: PopeRigby
Date:
Subject: Re: Errors when restoring backup created by pg_dumpall
Next
From: Bharani SV-forum
Date:
Subject: Re: Help in vetting my steps for Postgres DB upgrade from Ver 13.X to ver 15.X