Re: session_replication_role meaning?

From: Luca Ferrari <fluca1978(at)gmail(dot)com>
To: Peter Eisentraut <peter(dot)eisentraut(at)2ndquadrant(dot)com>
Cc: pgsql-general <pgsql-general(at)postgresql(dot)org>
Subject: Re: session_replication_role meaning?
Date: 2018-02-13 10:03:01
Message-ID: CAKoxK+4HRkiR3KP=mgUHO5t-9GWp1gDAPCTyF0Ob3YYnufKXwA@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

On Wed, Jan 31, 2018 at 5:19 AM, Peter Eisentraut
<peter(dot)eisentraut(at)2ndquadrant(dot)com> wrote:
> The documentation was recently updated in the master branch, so maybe
> you will find this explanation a bit more detailed:
> https://www.postgresql.org/docs/devel/static/runtime-config-client.html#GUC-SESSION-REPLICATION-ROLE
>

Looks a lot more clear to me.

> The global setting for an instance is not affected by whether you are
> replicating. The replication system is supposed to set the parameter
> when it is applying changes, e.g.,
> https://git.postgresql.org/gitweb/?p=postgresql.git;a=blob;f=src/backend/replication/logical/worker.c;h=eedc3a8816bc2f157e62a664bcc57b5f87530be9;hb=958fe549884928cd3bdf009993e9a05df5fd6cee#l1521

Yes, it is clearer from the documentation and the code what the purpose is.

Thanks,
Luca

In response to

Browse pgsql-general by date

  From Date Subject
Next Message rob stone 2018-02-13 11:39:36 Re: Require assistance in Postgres + Hibernate : Error: java.math.BigInteger cannot be cast to java.math.BigDecimal
Previous Message Laurenz Albe 2018-02-13 09:32:20 Re: Prepared statements (PREPARE and JDBC) are a lot slower than "normal" ones.