[GENERAL] fixing failed master after standby promotion

resync the failed master and re-register him as a standby server? Thanks in advance, Aviel Buskila.

[GENERAL] reverse proxy to postgresql with haproxy

Hey everyone, I am trying to configure reverse proxy to postgresql using haproxy, for this example I have the following architecture: - node1 - node2 - haproxysrv Streaming replication between node1 and node2 and auto failover with repmgr. When I issue a connection to haproxysrv to connect, I

Re: [GENERAL] repmgr won't update witness after failover

Hey, Thanks for the reply, this helped me very much. Kind Regards, Aviel Buskila. בתאריך 17 באוג' 2015 08:49, Jony Cohen jony.cohe...@gmail.com כתב: Hi, The clone command just clones the data from node2 to node1, you need to also register it with the `force` option to override the old record

Re: [GENERAL] repmgr won't update witness after failover

terminating.. what am I doing wrong? El 14/08/15 a las 04:14, Aviel Buskila escribió: Hey, yes I did .. and still it wont fail back.. Can you send over the output of repmgr cluster show before and after the failover process? The output of SELECT * FROM repmgr_schema.repl_nodes; after the failover

Re: [GENERAL] repmgr won't update witness after failover

too about the new standby server? Best regards, Aviel Buskila 2015-08-16 12:11 GMT+03:00 Aviel Buskila avie...@gmail.com: hey, I have tried to set the configuration all over again, now the status of 'repl_nodes' before the failover is: id | type | upstream_node_id | cluster | name

Re: [GENERAL] repmgr won't update witness after failover

one offline and the new one online. Regards, Jony Sent from my iPhone On 13 באוג׳ 2015, at 15:43, Aviel Buskila avie...@gmail.com wrote: Hey, I have just tried to start the repmgrd on the new standby after I have fixed it as a standby and still this goes the same way. from the message

[GENERAL] repmgr won't update witness after failover

; waiting 10 seconds to retry... it seems that the witness doesn't know about the new standby server.. Has anyone got any idea about what am I doing wrong here? Best regards, Aviel Buskila

Fwd: [GENERAL] repmgr won't update witness after failover

-- Forwarded message -- From: Aviel Buskila avie...@gmail.com Date: 2015-08-13 15:43 GMT+03:00 Subject: Re: [GENERAL] repmgr won't update witness after failover To: Jony Cohen ‫‎jony.cohe...@gmail.com‎‬ Hey, I have just tried to start the repmgrd on the new standby after I have

Re: [GENERAL] Setting up HA postgresql

hey will, Is there any open-source tool instead of developing the fail-over logic by myself? 2015-07-21 18:34 GMT+03:00 William Dunn dunn...@gmail.com: Hello Aviel, On Tue, Jul 21, 2015 at 3:56 AM, Aviel Buskila avie...@gmail.com wrote: How can I set a highly available postgresql in a share

Re: [GENERAL] Setting up HA postgresql

Can you link me up to a good tutorial using pgpool-II? 2015-07-21 20:02 GMT+03:00 Joshua D. Drake j...@commandprompt.com: On 07/21/2015 08:34 AM, William Dunn wrote: Hello Aviel, On Tue, Jul 21, 2015 at 3:56 AM, Aviel Buskila avie...@gmail.com mailto:avie...@gmail.com wrote: How can