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

From: Simon Riggs <simon(at)2ndQuadrant(dot)com>
To: Tomonari Katsumata <katsumata(dot)tomonari(at)po(dot)ntts(dot)co(dot)jp>
Cc: pgsql-bugs(at)postgresql(dot)org
Subject: Re: BUG #7803: Replication Problem(no master is there)
Date: 2013-01-15 08:14:09
Message-ID: CA+U5nMJEVsP6dKuthyD1GpuW-LPeToPjpvtL3gZEC5Nv7_YROQ@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-bugs

On 15 January 2013 05:12, Tomonari Katsumata
<katsumata(dot)tomonari(at)po(dot)ntts(dot)co(dot)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

In response to

Responses

Browse pgsql-bugs by date

  From Date Subject
Next Message Heikki Linnakangas 2013-01-15 08:25:56 Re: BUG #7803: Replication Problem(no master is there)
Previous Message Tomonari Katsumata 2013-01-15 05:12:14 Re: BUG #7803: Replication Problem(no master is there)