Re: Setting up HA postgresql

[Aviel Buskila <aviel33@xxxxxxxxx>]

hey will,

Is there any open-source tool instead of developing the fail-over logic by myself?

2015-07-21 18:34 GMT+03:00 William Dunn <dunnwjr@xxxxxxxxx>:

Hello Aviel,

On Tue, Jul 21, 2015 at 3:56 AM, Aviel Buskila <aviel33@xxxxxxxxx> wrote:

How can I set a highly available postgresql in a share-nothing architecture?

 

I suggest you review the official documentation on high-availability configurations linked below:

http://www.postgresql.org/docs/current/static/high-availability.html

The most common configuration is to use PostgreSQL's built in master/standby streaming replication. However you will need to develop any fail-over logic you need yourself or use a third party tool such as EnterpriseDB's Failover Manager.

Will J. Dunn

willjdunn.com

On Tue, Jul 21, 2015 at 3:56 AM, Aviel Buskila <aviel33@xxxxxxxxx> wrote:

Hey,

How can I set a highly available postgresql in a share-nothing architecture?

Best regards,

Aviel B.