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 <isr...@ravnalaska.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> >
