Received: from malur.postgresql.org ([217.196.149.56])
	by arkaria.postgresql.org with esmtps
 (TLS1.3:ECDHE_RSA_AES_256_GCM_SHA384:256)
	(Exim 4.92)
	(envelope-from <pgsql-hackers-owner+archive@lists.postgresql.org>)
	id 1jXREM-0002vF-4B
	for pgsql-hackers@arkaria.postgresql.org; Sat, 09 May 2020 15:17:34 +0000
Received: from localhost ([127.0.0.1] helo=malur.postgresql.org)
	by malur.postgresql.org with esmtp (Exim 4.92)
	(envelope-from <pgsql-hackers-owner+archive@lists.postgresql.org>)
	id 1jXREK-0005Sl-AY
	for pgsql-hackers@arkaria.postgresql.org; Sat, 09 May 2020 15:17:32 +0000
Received: from makus.postgresql.org ([2001:4800:3e1:1::229])
	by malur.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_256_GCM_SHA384:256)
	(Exim 4.92)
	(envelope-from <tgl@sss.pgh.pa.us>)
	id 1jXREK-0005Sa-3c; Sat, 09 May 2020 15:17:32 +0000
Received: from sss.pgh.pa.us ([66.207.139.130])
	by makus.postgresql.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_GCM_SHA384:256)
	(Exim 4.92)
	(envelope-from <tgl@sss.pgh.pa.us>)
	id 1jXREH-00053R-3b; Sat, 09 May 2020 15:17:31 +0000
Received: from sss1.sss.pgh.pa.us (localhost [127.0.0.1])
	by sss.pgh.pa.us (8.14.4/8.14.4) with ESMTP id 049FHQPF003749;
	Sat, 9 May 2020 11:17:26 -0400
From: Tom Lane <tgl@sss.pgh.pa.us>
To: Michael Paquier <michael@paquier.xyz>
cc: Kyotaro Horiguchi <horikyota.ntt@gmail.com>, alvherre@2ndquadrant.com,
        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>
References: <17709.1588908623@sss.pgh.pa.us>
 <20200508050211.GA6945@alvherre.pgsql>
 <20200508.150326.909507514141434296.horikyota.ntt@gmail.com>
 <20200509085701.GM11539@paquier.xyz>
Comments: In-reply-to Michael Paquier <michael@paquier.xyz>
	message dated "Sat, 09 May 2020 17:57:01 +0900"
MIME-Version: 1.0
Content-Type: text/plain; charset="us-ascii"
Content-ID: <3746.1589037446.1@sss.pgh.pa.us>
Date: Sat, 09 May 2020 11:17:26 -0400
Message-ID: <3747.1589037446@sss.pgh.pa.us>
List-Id: <pgsql-hackers.lists.postgresql.org>
List-Help: <https://lists.postgresql.org/manage/>
List-Subscribe: <https://lists.postgresql.org/manage/>
List-Post: <mailto:pgsql-hackers@lists.postgresql.org>
List-Owner: <mailto:pgsql-hackers-owner@lists.postgresql.org>
List-Archive: <https://www.postgresql.org/list/pgsql-hackers>
Precedence: bulk

Michael Paquier <michael@paquier.xyz> writes:
> 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.

ISTM those statements are contradictory.  The two privileges could
only be called orthogonal if it's possible to make use of one without
having the other.  As things stand, REPLICATION without LOGIN is an
entirely useless setting.

			regards, tom lane