Postgres Pro
Downloads
Home   >   mailing lists

Re: Setting up HA postgresql - Mailing list pgsql-general

From William Dunn
Subject Re: Setting up HA postgresql
Date
Msg-id CAEva=Vm2-RQxDNFZR_8a8kdeWiG7afYjeOmeoT_O9CBbpTAh9Q@mail.gmail.com
Whole thread Raw
In response to Re: Setting up HA postgresql  (Aviel Buskila <aviel33@gmail.com>)
Responses Re: Setting up HA postgresql
List pgsql-general
Tree view
If you dig deeper into pgpool-II you will find that it does not have failover logic. Its intention is to pool connections and distribute query load among replicas, but it cannot differentiate node failure from network partition and cannot promote a standby to master in the case of failure.

Will J. Dunn

On Tue, Jul 21, 2015 at 1:55 PM, Aviel Buskila <aviel33@gmail.com> wrote:
Can you link me up to a good tutorial using pgpool-II?

2015-07-21 20:02 GMT+03:00 Joshua D. Drake <jd@commandprompt.com>:

On 07/21/2015 08:34 AM, William Dunn wrote:
Hello Aviel,

On Tue, Jul 21, 2015 at 3:56 AM, Aviel Buskila <aviel33@gmail.com
 <mailto:aviel33@gmail.com>> 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.

Or use already available open source tools such as Pgpool-II or Linux-HA.

Sincerely,
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.


pgsql-general by date:

Previous
From: AI Rumman
Date:
Subject: Re: Setting up HA postgresql
Next
From: William Dunn
Date:
Subject: Re: Setting up HA postgresql