Re: High Availability Cluster - Mailing list pgsql-general

From Sameer Kumar
Subject Re: High Availability Cluster
Date
Msg-id CADp-Sm5cCNBs52sikdz1qeXtqJiBXPC3ETpf=GUChrnk8pTZHA@mail.gmail.com
Whole thread Raw
In response to High Availability Cluster  (Maila Fatticcioni <mfatticcioni@mbigroup.it>)
Responses Re: High Availability Cluster  (Tatsuo Ishii <ishii@postgresql.org>)
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).

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


Best Regards,

Sameer Kumar | Database Consultant

ASHNIK PTE. LTD.

101 Cecil Street, #11-11 Tong Eng Building, Singapore 069533

M: +65 8110 0350  T: +65 6438 3504 | www.ashnik.com

icons

 

Email patch

 

This email may contain confidential, privileged or copyright material and is solely for the use of the intended recipient(s).

Attachment

pgsql-general by date:

Previous
From: Adrian Klaver
Date:
Subject: Re: Postgres 9.2 PITR testing to before DROP DATABASE ends up removing file system files
Next
From: Sameer Kumar
Date:
Subject: Re: Synchronous Replication Timeout