Re: [GENERAL] cluster question

2017-08-16 Thread Alex Samad
On 17 August 2017 at 10:51, Ian Barwick wrote: > On 08/16/2017 02:41 PM, Alex Samad wrote: > (...) > > > > okay think I have it setup, but when i do a switch over it gets stuck > here. > > > > > > > > NOTICE: STANDBY PROMOTE successful > > NOTICE: Executing pg_rewind

Re: [GENERAL] cluster question

2017-08-16 Thread Ian Barwick
On 08/16/2017 02:41 PM, Alex Samad wrote: (...) > > okay think I have it setup, but when i do a switch over it gets stuck here. > > > > NOTICE: STANDBY PROMOTE successful > NOTICE: Executing pg_rewind on old master server > NOTICE: 3 files copied to /var/lib/pgsql/9.6/data > NOTICE: restarting

Re: [GENERAL] cluster question

2017-08-15 Thread Alex Samad
On 15 August 2017 at 16:35, Andreas Kretschmer wrote: > > > Am 15.08.2017 um 05:15 schrieb Alex Samad: > >> Hi >> >> Quick question. I have a 2 node cluster - each node has its own ip. >> >> But from reading this, I really need a 3rd ip, which potentially floats >>

Re: [GENERAL] cluster question

2017-08-15 Thread Andreas Kretschmer
Am 15.08.2017 um 05:15 schrieb Alex Samad: Hi Quick question. I have a 2 node cluster - each node has its own ip. But from reading this, I really need a 3rd ip, which potentially floats between the nodes to which ever is the master / rw node. Is that right? Sort of makes sense I guess

Re: [GENERAL] cluster question

2017-08-14 Thread Alex Samad
Hi Quick question. I have a 2 node cluster - each node has its own ip. But from reading this, I really need a 3rd ip, which potentially floats between the nodes to which ever is the master / rw node. Is that right? Sort of makes sense I guess A On 14 August 2017 at 16:47, Andreas Kretschmer

Re: [GENERAL] cluster question

2017-08-14 Thread Andreas Kretschmer
On 14 August 2017 08:39:54 GMT+02:00, Alex Samad wrote: >Hi > >I have setup a streaming replicating cluster, with a hot standby. > >Now I would like to change the RW to hot standby and change the hot >standby >to be the RW server. > >Is it just a matter of updating recover.conf