Re: Time-Delayed Standbys

2013/12/4 Christian Kruse <christian(at)2ndquadrant(dot)com>

> You created a master node and a hot standby with 3000000 delay. Then
> you stopped the standby, did the pgbench and startet the hot standby
> again. It did not get in line with the master. Is this correct?
>
No. First, I start master, and execute pgbench. Second, I start standby
with 3000000ms(50min) delay.
Then it cannot connect standby server by psql at all. I'm not sure why
standby did not start.
It might because delay feature is disturbed in REDO loop when first standby
start-up.

> I don't see a problem here… the standby should not be in sync with the
> master, it should be delayed. I did step by step what you did and
> after 50 minutes (3000000ms) the standby was at the same level the
> master was.
>
I think we can connect standby server any time, nevertheless with delay
option.

> Did I missunderstand you?
>
I'm not sure... You might right or another best way might be existed.

Regards,
--
Mitsumasa KONDO
NTT Open Source Software Center