Subject: Re: libpq options
To: Andres Freund <andres@anarazel.de>,
 Michael Paquier <michael.paquier@gmail.com>,
 Petr Jelinek <petr@2ndquadrant.com>
Cc: sahapasci@gmail.com, pgsql-docs@postgresql.org,
 Fujii Masao <masao.fujii@gmail.com>
References: <20171122132714.1463.27247@wrigleys.postgresql.org>
 <CAB7nPqRZ-8BkUuF1UR+xzg3J+LDTcafbJ75DZGsfn+++iF5_aw@mail.gmail.com>
 <CAB7nPqTMQYKO4AJ6xfz-btAtvL-=CWxYnkXUOVEQGNk4Ey1k=Q@mail.gmail.com>
 <20180301093554.qrqgdnfwgs77tj23@alap3.anarazel.de>
From: Petr Jelinek <petr.jelinek@2ndquadrant.com>
Message-ID: <e2c073c5-8ed6-5cdb-e390-678a2026a4f1@2ndquadrant.com>
Date: Fri, 2 Mar 2018 10:44:13 +0100
User-Agent: Mozilla/5.0 (X11; Linux x86_64; rv:52.0) Gecko/20100101
 Thunderbird/52.6.0
MIME-Version: 1.0
In-Reply-To: <20180301093554.qrqgdnfwgs77tj23@alap3.anarazel.de>
Content-Type: text/plain; charset=utf-8
Content-Language: en-US
Content-Transfer-Encoding: 7bit
Precedence: bulk

On 01/03/18 10:35, Andres Freund wrote:
> On 2017-11-25 19:05:54 +0900, Michael Paquier wrote:
>> +     <varlistentry id="libpq-connect-replication" xreflabel="replication">
>> +      <term><literal>replication</literal></term>
>> +      <listitem>
>> +      <para>
>> +       This option determines if a backend should use the replication
>> +       protocol.
> 
> "should"? The backend will, and the client will have to do so as well.
> 

I think so as well.

> 
>> A Boolean value of <literal>true</literal> tells the backend
>> +       to go into walsender mode, wherein a small set of replication commands
>> +       can be issued instead of SQL statements.
> 
> This actually is wrong now I think. Petr?
> 

If the replication is true, we don't have database connection so only
replication commands can be executed.

SQL commands work when replication is set to database.

-- 
  Petr Jelinek                  http://www.2ndQuadrant.com/
  PostgreSQL Development, 24x7 Support, Training & Services