Re: Setting up HA postgresql

Hi,

I made the following document 4 years back:
http://www.rummandba.com/2011/02/postgresql-failover-with-pgpool-ii.html

You may have a look if it makes any good to your work.

BTW, if you want to setup a share-nothing high scalable system with
data-sharding, you can go for pl/proxy.

Thanks.

On Tue, Jul 21, 2015 at 10:55 AM, Aviel Buskila <aviel33(at)gmail(dot)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(at)commandprompt(dot)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(at)gmail(dot)com
>>> <mailto:aviel33(at)gmail(dot)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.
>>
>
>