Re: Master-slave failover question

Hi all again,
I rigged up a solution with PGPool (!) in master-slave mode, using the
existing documentation and it works like a charm with a downtime of only a
few seconds, which is acceptable in our case. However assume the following
scenario:
1) Master goes down
2) slave gets promoted to master
owing to the usage of pgpool, this works fine. However, assuming that there
is a certain amount of write traffic that goes to the new master. When the
old master (sorry for the terminology) comes back up, how can I "sync" him
with all the changes that have been performed? This is one of the two
pieces of the puzzle missing for me (the other one is pgpool specific and I
directed my query to their specific mailing list).
Thanks for any replies.

On Fri, Jan 3, 2014 at 2:00 PM, Athanasios | ZenGuard <
athanasios(at)zenguard(dot)org> wrote:

> Hi,
> PGPool is a bit of a blackbox. I am confident in the use of VRRP but I
> have not seen any documentation on how to combine this with pgpool to
> eliminate single points of failure.
> Can you share a few more details about how I can use a virtual IP?
>
>
> On Fri, Jan 3, 2014 at 1:12 PM, Sameer Kumar <sameer(dot)kumar(at)ashnik(dot)com>wrote:
>
>> Check their site. Www.enterprisedb.com
>>
>> Can you share you failover command here? You may use ifconfig to switch a
>> vitrual IP while doing a failover.
>>
>> BTW why are you reluctant to use pgpool?
>>
>> Regards
>> Sameer
>>
>> PS: Sent from my Mobile device. Pls ignore typo n abb
>>
>
>