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

Hi,

Sorry for late response.

(2013/01/11 23:11), Simon Riggs wrote:
 > On 11 January 2013 12:18, Tomonari Katsumata
 > <katsumata.tomonari@po.ntts.co.jp> wrote:
 >
 >> I'm not sure but what about adding the parameter("cascade_mode") on
 >> recovery.conf ?
 >> The parameter represents a will to connect to standby server when
starting
 >> as standby.
 >> If the parameter is set to on, connect to a server forcely like
PostgreSQL
 >> 9.2,
 >> and if the parameter is set to off, connect to the another standby
server is
 >> refused like PostgreSQL 9.1.
 >
 > 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
 >

This idea seems better than mine.

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

regards,
--------
NTT Software Corporation
  Tomonari Katsumata