[GENERAL] Setting up HA postgresql

Hey, How can I set a highly available postgresql in a share-nothing architecture? Best regards, Aviel B.

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 : > Hello Aviel, > > On Tue, Jul 21, 2015 at 3:56 AM, Aviel Buskila wrote: >> >> How can I set a highly available postgresql in a share-no

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 : > > On 07/21/2015 08:34 AM, William Dunn wrote: > >> Hello Aviel, >> >> On Tue, Jul 21, 2015 at 3:56 AM, Aviel Buskila > <mailto:avie...@gmail.com>>

[GENERAL] repmgr won't update witness after failover

d master server; 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 Date: 2015-08-13 15:43 GMT+03:00 Subject: Re: [GENERAL] repmgr won't update witness after failover To: Jony Cohen ‫‎‎‬ Hey, I have just tried to start the repmgrd on the new standby after I have fixed it as a standby and still

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 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 s

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

terminating... [INFO] repmgrd 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 SEL

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

es should be updated too about the new standby server? Best regards, Aviel Buskila 2015-08-16 12:11 GMT+03:00 Aviel Buskila : > hey, > > I have tried to set the configuration all over again, now the status of > 'repl_nodes' before the failover is: > > id | typ

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" כתב: > 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

[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 get