Thanks. I'd taken some stabs at setting up Corosync/Pacemaker, but could never get the PostgreSQL portion to work properly. One difficulty is that I am using named replication slots, which don't appear to be supported. The other issue is that the system tended to try to start my secondary as primary, which of course doesn't work to bring up the old primary as secondary (at least, that's my understanding. Let me know if that's wrong).
I'll take another stab at it given the steps outlined in the presentation you posted, and given your success - I must just be doing something wrong here.
-----------------------------------------------
5245 Airport Industrial Rd
-----------------------------------------------
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.
All working out well in testing at the moment.
Steve Pritchard
British Trust for Ornithology