Re: dividing privileges for replication role.

Josh Berkus <josh@agliodbs.com>

From: Josh Berkus <josh@agliodbs.com>
To: pgsql-hackers@postgresql.org
Date: 2013-01-21T01:57:35Z
Lists: pgsql-hackers
Katsumata-san,

> In this patch, I made below.
> a) adding new privileges for replication:"MASTER REPLICATION" and "CASCADE
> REPLICATION"
>    "MASTER REPLICATION":  Replication-connection to master server is only
> allowed
>    "CASCADE REPLICATION": Replication-connection to cascade server is only
> allowed
>    ("REPLICATION" already implemented means replication-connection to both
> servers is allowed)

This seems to me a case of making things more complicated for everyone
in order to satisfy a very narrow use-case.  It certainly doesn't seem
to me to do anything about the "accidental cycle" issue.  Am I missing
something?

-- 
Josh Berkus
PostgreSQL Experts Inc.
http://pgexperts.com