Re: High Availability Cluster - Mailing list pgsql-general

From Tatsuo Ishii
Subject Re: High Availability Cluster
Date
Msg-id 20141204.133232.2053443811024804659.t-ishii@sraoss.co.jp
Whole thread Raw
In response to Re: High Availability Cluster  (Sameer Kumar <sameer.kumar@ashnik.com>)
Responses Re: High Availability Cluster  (Sameer Kumar <sameer.kumar@ashnik.com>)
List pgsql-general
> On Thu, Nov 27, 2014 at 7:26 PM, Maila Fatticcioni <mfatticcioni@mbigroup.it
>> wrote:
> 
>> I was wondering if there is another way to set up a complete cluster
>> that would manage in case of failure:
>>
>> * the relocation of the VIP (virtual ip address)
>> * the relocation of the main instance of Postgresql
>>
> 
> ​Consider trying pgpool. It has an HA mode (and I think the latest version
> works using a heartbeat, the older one uses watchdog).

No. Just the implementation of watchdog has been changed (more
precisely new life check mode added). In recent versions (since 3.3)
it uses UDP packet for life check of pgpool, which is pretty much
similar to heartbeat.

> If you are up for a commercial product, you may want to consider using
> something like EnterpriseDB's failover manager.

Commercial support for pgpool-II is provided by the way.

Best regards,
--
Tatsuo Ishii
SRA OSS, Inc. Japan
English: http://www.sraoss.co.jp/index_en.php
Japanese:http://www.sraoss.co.jp

pgsql-general by date:

Previous
From: Sameer Kumar
Date:
Subject: Re: recovering from "too many failures" wal error
Next
From: M Tarkeshwar Rao
Date:
Subject: Re: FW: getting error while running sql on mm_activealrm table