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

From Joshua D. Drake
Subject Re: Setting up HA postgresql
Date
Msg-id 55AE7B38.6050008@commandprompt.com
Whole thread Raw
In response to Re: Setting up HA postgresql  (William Dunn <dunnwjr@gmail.com>)
Responses Re: Setting up HA postgresql  (Aviel Buskila <aviel33@gmail.com>)
List pgsql-general
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: Aviel Buskila
Date:
Subject: Re: Setting up HA postgresql
Next
From: Fritz Meissner
Date:
Subject: Cannot reach pg server using -h localhost