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 >> replication and have installed repmgr3 and

Re: [GENERAL] upgrade to repmgr3

2016-08-11 Thread Martín Marqués
Hi, 2016-08-11 7:54 GMT-03:00 Pekka Rinne : >> >> Do you by chance have synchronous replication set? That ps output alone >> doesn't say much, but being stuck on COMMIT normally points to failure >> to sync the replication on a standby. >> > > Yeah, I learned that repmgr3 actually writes to DB dur

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. > > > > 1. Install repmgr3.1.2 RPM

Re: [GENERAL] upgrade to repmgr3

2016-08-09 Thread 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. > > 1. Install repmgr3.1.2 RPM to all nodes as upgrade to previous 2.0.2. > 2. I took repmgr

Re: [GENERAL] upgrade to repmgr3

2016-08-08 Thread Pekka Rinne
hello Thanks for your comments. They are very helpful. If you have any draft level documentation available of the upgrade procedure I would be very interested in seeing it and maybe trying it out as well. Meanwhile I did some more testing with my environment using repmgr3 and noticed an issue wit

Re: [GENERAL] upgrade to repmgr3

2016-08-04 Thread 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 replication and have installed repmgr3 and exeuted the provided sql scripts and also added use_replication_