Re: Time-Delayed Standbys
| От | Mitsumasa KONDO |
|---|---|
| Тема | Re: Time-Delayed Standbys |
| Дата | |
| Msg-id | CADupcHXHGj3y3Lshdtsu1qH9UBywWm9uFw30Jwf8MKB9N0kfUQ@mail.gmail.com обсуждение исходный текст |
| Ответ на | Re: Time-Delayed Standbys (Christian Kruse <christian@2ndQuadrant.com>) |
| Список | pgsql-hackers |
2013/12/4 Christian Kruse <christian@2ndquadrant.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.
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
Regards,
--
Mitsumasa KONDO
NTT Open Source Software Center
В списке pgsql-hackers по дате отправления: