Re: [GENERAL] Auotmated postgres failover

2016-01-22 Thread Jehan-Guillaume de Rorthais
Le Thu, 21 Jan 2016 11:34:18 -0800, John R Pierce a écrit : > On 1/21/2016 11:07 AM, jwienc...@comcast.net wrote: > > > > > > I'm looking for a tool to automate PostgreSQL cluster management > > failover in the event the master database were to become unavailable. > > Currently are manually i

Re: [GENERAL] Auotmated postgres failover

2016-01-21 Thread Andrew Sullivan
On Thu, Jan 21, 2016 at 11:34:18AM -0800, John R Pierce wrote: > the most difficult part is reliably determining that A) the master has > crashed, and B) fencing the failed old master so it doesn't wake up and > think its still in charge. > And, depending on your workload, C) that you actually wa

Re: [GENERAL] Auotmated postgres failover

2016-01-21 Thread John R Pierce
On 1/21/2016 11:07 AM, jwienc...@comcast.net wrote: I'm looking for a tool to automate PostgreSQL cluster management failover in the event the master database were to become unavailable. Currently are manually issuing a "pg_ctl promote" once we become aware that the master database has cr

[GENERAL] Auotmated postgres failover

2016-01-21 Thread jwiencek3
Hello I'm looking for a tool to automate PostgreSQL cluster management failover in the event the master database were to become unavailable. Currently are manually issuing a "pg_ctl promote" once we become aware that the master database has crashed. Is repmgr a via solution? Please pass al