Re: [GENERAL] Postgresql HA questions

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 primar

Re: [GENERAL] 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

[GENERAL] Postgresql HA questions

I have a couple of questions regarding setting up and administering a high availability Postgresql "cluster". At the moment the setup I have consists of two servers set up with streaming replication using the named replication slots feature of Postgresql 9.4 (currently running 9.4.1). Let me know i