Re: BUG #7803: Replication Problem(no master is there)

On 15 January 2013 05:12, Tomonari Katsumata
<katsumata.tomonari@po.ntts.co.jp> wrote:

>> We added a REPLICATION privelge onto user accounts to control access.
>>
>> Perhaps we should add a CASCADE privilege as well, so that we can
>> control whether we can connect to a master and/or a standby.
>>
>> Syntax would be
>>
>> ALTER USER foo
>> [MASTER | CASCADE] REPLICATION
>>
>> REPLICATION allows both master and cascaded replication (same as now)
>> MASTER REPLICATION allows master only
>> CASCADE REPLICATION allows cascaded replication only
>> NOREPLICATION allows neither option
>>

> Someone is working for it already ?
> If not yet, may I try to implement it ?

Please do. It looks fairly short.

--
 Simon Riggs                   http://www.2ndQuadrant.com/
 PostgreSQL Development, 24x7 Support, Training & Services