Re: Qsn on Setting replication using " set session_replication_role = "

Поиск
Список
Период
Сортировка
От David G. Johnston
Тема Re: Qsn on Setting replication using " set session_replication_role = "
Дата
Msg-id CAKFQuwa96VUADGXCzKn988Gd_JO=s8aeERmSyQM2UXYqw8FpjA@mail.gmail.com
обсуждение исходный текст
Ответ на Qsn on Setting replication using " set session_replication_role = "  (Bharani SV-forum <esteembsv-forum@yahoo.com>)
Список 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 ?


David J.

В списке pgsql-general по дате отправления: