Re: Master-slave failover question
| От | Athanasios | ZenGuard |
|---|---|
| Тема | Re: Master-slave failover question |
| Дата | |
| Msg-id | CAHPc5uQ3_dqWPiFx-WKdaqtSZXvYDPwDDwEV5bQGg3KzjEbM5Q@mail.gmail.com обсуждение исходный текст |
| Ответ на | Re: Master-slave failover question (Sameer Kumar <sameer.kumar@ashnik.com>) |
| Ответы |
Re: Master-slave failover question
Re: Master-slave failover question |
| Список | pgsql-novice |
Hi Sameer,
thank you for the quick reply (again!). I am not using pgpool admin so is it possible to share the shell script that does the rebuilding? Also, if a slave is lost, when he comes back up, will he not "catch up" using Streaming Replication?
Cheers!
On Fri, Jan 3, 2014 at 5:00 PM, Sameer Kumar <sameer.kumar@ashnik.com> wrote:
As of now (v9.3 of postgreSQL), you need to rebuild old (lost) master from new master.
Glad you could discover the magic of pgpool :-)You can either use pgpoll admin to do this rebuilding in a single click or you can write your own shell script (like I had done) to resotre a lost node (do remember to test a scenario where slave is lost and you have to rebuild that).
Regards
SameerPS: Sent from my Mobile device. Pls ignore typo n abb
В списке pgsql-novice по дате отправления: