Date: Sat, 9 May 2020 17:57:01 +0900
From: Michael Paquier <michael@paquier.xyz>
To: Kyotaro Horiguchi <horikyota.ntt@gmail.com>
Cc: 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
Message-ID: <20200509085701.GM11539@paquier.xyz>
References: <17709.1588908623@sss.pgh.pa.us>
 <20200508050211.GA6945@alvherre.pgsql>
 <20200508.150326.909507514141434296.horikyota.ntt@gmail.com>
MIME-Version: 1.0
Content-Type: multipart/signed; micalg=pgp-sha512;
	protocol="application/pgp-signature"; boundary="IpgPcFyQO6wM49Um"
Content-Disposition: inline
In-Reply-To: <20200508.150326.909507514141434296.horikyota.ntt@gmail.com>
Precedence: bulk


--IpgPcFyQO6wM49Um
Content-Type: text/plain; charset=us-ascii
Content-Disposition: inline
Content-Transfer-Encoding: quoted-printable

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.c=
om> wrote in=20
>> 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.
>>=20
>> I agree with this.
>=20
> 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

--IpgPcFyQO6wM49Um
Content-Type: application/pgp-signature; name="signature.asc"

-----BEGIN PGP SIGNATURE-----

iQIzBAABCgAdFiEEG72nH6vTowiyblFKnvQgOdbyQH0FAl62cF0ACgkQnvQgOdby
QH2emQ//Z94/jRvJ0Ox5n/41Bjxf9GTtyVVStRu49I3AxJvhYpTWtFtl4DKL4G05
UNJB56jGsif/SYYM+2H0UudhyuSmSeUiUQJyadCxBhh2z8iMAVuAgAfx0pW158xE
AoVjyB0oxVRPb2hTZ3y00eO1fnIIionXM5eoGm9l69TRQS3RW0qNFFdYxD5PtJ5o
Gy9cqkGVjk3Kjzfg1ryZrC9MSo2FbGcnnxyFBt9tIrAbnoW2waI5Zh9KRrS/+0gT
GvMNtAiG90eVeYP5HP6OP7GqphoQbyXIbo80dNufYOd4rVLB1Jimc/F3UqA2Qw61
BCPOxmkWloOSSSBB7sMoMsRpSE3GgI7YNCFogzP96B/Qn9vxuSYhl+X0Z/z6gS3+
3boerqzg7O8snSORw1e+pkroPeUvXJsADG9lx+K3Xd7Tcl1MPnTknecFFJfjaTkd
OjKhZoWT0juv6vv7UZf9HqrcJkdvNp+rFc/nKOvtQFnMWEZTb6RvziVRv13I0k2y
coBNNRFRYEFfYBt6GvDQjVC+F/P5voC0n38fYi6jTu+YzZIkb8LyaKqdhb0Pon+Z
ejCsdZyRo108+mhnlrDLFwC9oVvu+2dVfM17M30zhJTfDML6wj8Q+f8q8aXtHjIP
Hs+A1AWbOCxiR3BdtGID+2PtbQ3v/AgNL+s59USZle6bJ9pGoJs=
=Nbc8
-----END PGP SIGNATURE-----

--IpgPcFyQO6wM49Um--