Qsn on Setting replication using " set session_replication_role = "

From: Bharani SV-forum <esteembsv-forum(at)yahoo(dot)com>
To: "FN_pgsql-general(at)postgresql(dot)org LN_pgsql-general(at)postgresql(dot)org" <pgsql-general(at)postgresql(dot)org>
Subject: Qsn on Setting replication using " set session_replication_role = "
Date: 2024-12-04 12:20:02
Message-ID: 1028265449.5830238.1733314802260@mail.yahoo.com
Views: Whole Thread | Raw Message | Download mbox | Resend email
Thread:
Lists: 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 ?

Responses

Browse pgsql-general by date

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