Re: Logical replication subscription owner

On 2020-Apr-15, PG Doc comments form wrote:

> If the logical replication subscription is owned by a role that is not
> allowed to login (for example, if the LOGIN privilege is removed after the
> subscription is created) then the logical replication worker (which uses the
> owner to connect to the database) will start to fail with this error
> (repeated every 5 seconds), which is pretty much undocumented:
> 
> FATAL:  role "XXX" is not permitted to log in
> LOG:  background worker "logical replication worker" (PID X) exited with
> exit code 1
> 
> You might want to include that error message in the docs, to ensure that web
> searches for it bring the user to this documentation.

I wonder if a better answer is to allow the connection when the
REPLICATION priv is granted, ignoring the LOGIN prov.

-- 
Álvaro Herrera                https://www.2ndQuadrant.com/
PostgreSQL Development, 24x7 Support, Remote DBA, Training & Services