From: Michael Paquier <michael@paquier.xyz>
To: Kyotaro Horiguchi <horikyota.ntt@gmail.com>
Cc: alvherre@2ndquadrant.com
Cc: tgl@sss.pgh.pa.us
Cc: sfrost@snowman.net
Cc: chris+postgresql@qwirx.com
Cc: pgsql-docs@lists.postgresql.org
Cc: pgsql-hackers@lists.postgresql.org
Cc: peter.eisentraut@2ndquadrant.com
Subject: Re: Logical replication subscription owner
Date: Sat, 9 May 2020 17:57:01 +0900
Message-ID: <20200509085701.GM11539@paquier.xyz> (raw)
In-Reply-To: <20200508.150326.909507514141434296.horikyota.ntt@gmail.com>
References: <17709.1588908623@sss.pgh.pa.us>
<20200508050211.GA6945@alvherre.pgsql>
<20200508.150326.909507514141434296.horikyota.ntt@gmail.com>
On Fri, May 08, 2020 at 03:03:26PM +0900, Kyotaro Horiguchi wrote:
> At Fri, 8 May 2020 01:02:11 -0400, Alvaro Herrera <alvherre@2ndquadrant.com> wrote in
>> On 2020-May-07, Tom Lane wrote:
>>> FWIW, I would argue that LOGIN permits logging in on a regular SQL
>>> connection, while REPLICATION should permit logging in on a
>>> replication connection, and there's no reason for either to depend on
>>> or require the other.
>>
>> I agree with this.
>
> I agree, too. Anyway, it is unreasonable that a user is banned for
> the lack of replication-attribute after a successful *replication*
> login.
Not to make the life of everybody more complicated here, but I don't
agree. LOGIN and REPLICATION are in my opinion completely orthogonal
and it sounds more natural IMO that a REPLICATION user should be able
to log into the server only if it has LOGIN defined.
--
Michael
Attachments:
signature.asc (application/pgp-signature, 832B) download
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-docs@postgresql.org
Cc: michael@paquier.xyz, horikyota.ntt@gmail.com, alvherre@2ndquadrant.com, tgl@sss.pgh.pa.us, sfrost@snowman.net, chris+postgresql@qwirx.com, pgsql-docs@lists.postgresql.org, pgsql-hackers@lists.postgresql.org, peter.eisentraut@2ndquadrant.com
Subject: Re: Logical replication subscription owner
In-Reply-To: <20200509085701.GM11539@paquier.xyz>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox