agora inbox for [email protected]  

help / color / mirror / Atom feed

From: Alvaro Herrera <[email protected]>
To: [email protected]
To: [email protected]
Subject: Re: Logical replication subscription owner
Date: Wed, 22 Apr 2020 13:40:29 -0400
Message-ID: <[email protected]> (raw)
In-Reply-To: <[email protected]>

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

view thread (16+ messages)  latest in thread

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: [email protected]
  Cc: [email protected], [email protected], [email protected]
  Subject: Re: Logical replication subscription owner
  In-Reply-To: <[email protected]>

* Save the following mbox file, import it into your mail client,
  and reply-to-all from there: mbox

This inbox is served by agora; see mirroring instructions
for how to clone and mirror all data and code used for this inbox