Re: [GENERAL] upgrade to repmgr3

2016-08-15 Thread Pekka Rinne
hi 2016-08-04 16:19 GMT+03:00 Ian Barwick : > Hi > > On 08/04/2016 05:57 PM, Pekka Rinne wrote: > >> hi! >> >> I have been using postgres 9.4 and repmgr2.0 combination and been doing >> replication (hot standby). Now I'd like to start doing slot based

Re: [GENERAL] upgrade to repmgr3

2016-08-11 Thread Pekka Rinne
hi 2016-08-09 15:39 GMT+03:00 Martín Marqués : > Hi, > > El 08/08/16 a las 05:57, Pekka Rinne escribió: > > > > Meanwhile I did some more testing with my environment using repmgr3 and > > noticed an issue with promoting standby node. Here is roughly what I did. > &g

Re: [GENERAL] upgrade to repmgr3

2016-08-08 Thread Pekka Rinne
g existing master as failed [2016-08-08 10:29:05] [DEBUG] begin_transaction() [2016-08-08 10:29:05] [DEBUG] commit_transaction() The system is left in a strange state after this. If I start postgresql again in old master node and issue cluster show it lists both nodes as masters. In this experimen

[GENERAL] upgrade to repmgr3

2016-08-04 Thread Pekka Rinne
hi! I have been using postgres 9.4 and repmgr2.0 combination and been doing replication (hot standby). Now I'd like to start doing slot based replication and have installed repmgr3 and exeuted the provided sql scripts and also added use_replication_slots=1 into repmgr.conf. The question is that w