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
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) |