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