PostgreSQL HA config recommendations

From: Alex Gregory <alex(at)c2company(dot)com>
To: "pgsql-general(at)postgresql(dot)org" <pgsql-general(at)postgresql(dot)org>
Subject: PostgreSQL HA config recommendations
Date: 2015-04-29 18:13:01
Message-ID: 6160515F-9C24-4ED2-9BBF-2B34A4EB46BF@c2company.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Hello-

I have been doing lots of reading and I really want to make sure that I get this HA architecture I am working on correct. I figured the best way would be to reach out to the community for advice.

I am installing Cisco Jabber and want to use Postgres for the back end. The Postgres servers will be running on CentOS.

The requirement is to have two servers in HA using a database stored on shared NetApp Filer storage in California. A third server will be in Ireland for DR purposes. There only really needs to be one writeable server in California if it keeps things simple. Automatic conflict resolution should be easier this way causing lower overhead.

I was thinking that I could use Slony but then I read that it does not like WAN replication. I have also read about streaming replication native to Postgres but was not sure how that would work over the WAN. Bucardo seems better for Data Warehousing or multimaster situations which this is not. That leaves pgpool ii which seems like it would add an extra layer of complexity.

When it comes down to to there are so many choices I am not sure if I need one or a combination of two. Any help you could provide could be greatly appreciated.

Thanks for the assistance,

Alex

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Melvin Davidson 2015-04-29 18:13:17 Re:
Previous Message John McKown 2015-04-29 18:08:57 Re: New column modifier?