On 2020-Jun-24, Kyotaro Horiguchi wrote:
> In logical replication, a replication role is intended to be
> accessible only to the GRANTed databases. On the other hand the same
> role can create a dead copy of the whole cluster, including
> non-granted databases.
In other words -- essentially, if you grant replication access to a role
only to a specific database, they can steal the whole cluster.
I don't see what's so great about that, but apparently people like it.
--
Álvaro Herrera https://www.2ndQuadrant.com/
PostgreSQL Development, 24x7 Support, Remote DBA, Training & Services
