Re: Master-slave failover question

From: "Athanasios | ZenGuard" <athanasios(at)zenguard(dot)org>
To: Sameer Kumar <sameer(dot)kumar(at)ashnik(dot)com>
Cc: "pgsql-novice(at)postgresql(dot)org" <pgsql-novice(at)postgresql(dot)org>
Subject: Re: Master-slave failover question
Date: 2014-01-03 16:03:45
Message-ID: CAHPc5uQ3_dqWPiFx-WKdaqtSZXvYDPwDDwEV5bQGg3KzjEbM5Q@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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(dot)kumar(at)ashnik(dot)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
> Sameer
>
> PS: Sent from my Mobile device. Pls ignore typo n abb
>

In response to

Responses

Browse pgsql-novice by date

  From Date Subject
Next Message Sameer Kumar 2014-01-03 16:07:01 Re: Master-slave failover question
Previous Message Sameer Kumar 2014-01-03 16:00:03 Re: Master-slave failover question