pg.ddx.io  pgsql-docs@postgresql.org mailing list archive  
help / color / mirror / Atom feed
From: Tom Lane <tgl@sss.pgh.pa.us>
To: Michael Paquier <michael@paquier.xyz>
Cc: Kyotaro Horiguchi <horikyota.ntt@gmail.com>
Cc: alvherre@2ndquadrant.com
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, 09 May 2020 11:17:26 -0400
Message-ID: <3747.1589037446@sss.pgh.pa.us> (raw)
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>

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





view thread (15+ messages)  latest in thread

Message-ID: <3747.1589037446@sss.pgh.pa.us>
Permalink:  ../3747.1589037446@sss.pgh.pa.us/
Also on:    postgresql.org/message-id/3747.1589037446@sss.pgh.pa.us

 · 

reply

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: tgl@sss.pgh.pa.us, michael@paquier.xyz, 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: <3747.1589037446@sss.pgh.pa.us>

* 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