Re: PostgreSQL HA config recommendations

On 04/29/2015 10:53 AM, Alex Gregory wrote:
> 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
thirdserver will be in Ireland for DR purposes.  There only really needs to be one writeable server in California if it
keepsthings 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
streamingreplication native to Postgres but was not sure how that would work over the WAN.  Bucardo seems better for
DataWarehousing or multimaster situations which this is not.  That leaves pgpool ii which seems like it would add an
extralayer 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
youcould provide could be greatly appreciated. 

This is a can of worms topic but:

You can use streaming replication (or log shipping) asynchronously which
will allow you to use it over  WAN just fine.

Other than that, use the Linux HA suite. That is what it is there for.

JD


--
Command Prompt, Inc. - http://www.commandprompt.com/  503-667-4564
PostgreSQL Centered full stack support, consulting and development.
Announcing "I'm offended" is basically telling the world you can't
control your own emotions, so everyone else should do it for you.