Re: Postgresql HA questions

Israel,

I can't answer all your questions, but we've just set up a HA pair with *Hot
Standby using Corosync/Pacemaker*. However we haven't deployed this 'live'
yet.

We originally found a presentation from The PostgreSQL Conference PostgreSQL
High Availability with Corosync/Pacemaker
<http://www.pgcon.org/2013/schedule/events/546.en.html>, and then bought
the book PostgreSQL 9.0 High Performance <http://2ndquadrant.com/en/books/>
(a sample chapter
<https://www.packtpub.com/sites/default/files/0301OS-Chapter-2-Database-Hardware.pdf>
is available as a PDF).

All working out well in testing at the moment.

Steve Pritchard
British Trust for Ornithology

On 23 September 2015 at 17:36, Israel Brewster <israel(at)ravnalaska(dot)net>
wrote:

> <snip>
> With my application servers, I have a system set up using corosync and
> pacemaker that allows for seamless fail-over between the two machines, with
> the IP address and all services moving smoothly between the two at will.
> Ideally, I would have a similar setup with my database servers, so the
> applications never even know that there was a switch. Is this possible with
> Postgresql at all? Does it make a difference that at least one app has an
> "always on" connection to the DB Server?
> <snip>
>