[GENERAL] [BDR] Node Join Question

2015-05-11 Thread Wayne E. Seguin
_node_join_wait_for_ready();' it will usually just hang. How can I debug why the nodes are not connecting to each other find out where they getting stuck trying to join? ~Wayne Wayne E. Seguin wayneeseg...@gmail.com wayneeseguin on irc.freenode.net http://twitter.com/wayneeseguin/ https

Re: [GENERAL] [BDR] Node Join Question

2015-05-11 Thread Wayne E. Seguin
: Remove all replication identifiers and slots corresponding to this node from the init target node then drop and recreate this database and try again On Mon, May 11, 2015 at 11:33 PM, Wayne E. Seguin wrote: > To the wonderful BDR folks, > > I have a 5 node pg+bdr cluster that I've s

Re: [GENERAL] [BDR] Node Join Question

2015-05-11 Thread Wayne E. Seguin
Also, what is the proper way to locate and remove these replication slots as mentioned in this log? On Mon, May 11, 2015 at 11:36 PM, Wayne E. Seguin wrote: > Also, > > Is there a way to remove these things from the init target node easier? > > d= p=504 a=ERROR: 55000: previ

Re: [GENERAL] [BDR] Node Join Question

2015-05-12 Thread Wayne E. Seguin
wrote: > > > On 12 May 2015 at 14:36, Wayne E. Seguin wrote: > >> Also, >> >> Is there a way to remove these things from the init target node easier? >> >> d= p=504 a=ERROR: 55000: previous init failed, manual cleanup is required >> d= p=

Re: [GENERAL] [BDR] Node Join Question

2015-05-12 Thread Wayne E. Seguin
area :) Thank you for this, I will alter what I am doing to start sequentially. On Tue, May 12, 2015 at 1:19 AM, Craig Ringer wrote: > > > On 12 May 2015 at 14:33, Wayne E. Seguin wrote: > >> >> > 7. on nodes 1-4 I am doing (adjusted for the nodes IP):

Re: [GENERAL] [BDR] Node Join Question

2015-05-12 Thread Wayne E. Seguin
Craig, It's alive!!! One more question on this thread, where can I find the meanings of node_status in the documentation? pgbdr=# SELECT * FROM bdr.bdr_nodes; node_sysid | node_timeline | node_dboid | node_status | node_name |node_local_dsn |

Re: [GENERAL] [BDR] Node Join Question

2015-05-12 Thread Wayne E. Seguin
*awesome*, the question was for my own curiosity so thanks for this! On Tue, May 12, 2015 at 18:27 Craig Ringer wrote: > On 12 May 2015 at 22:21, Wayne E. Seguin wrote: > >> Craig, >> >> It's alive!!! >> >> One more question on this thread, where can I f

Re: [GENERAL] replicating many to one

2015-06-04 Thread Wayne E. Seguin
ke pgpool statement-based replication, the major down side > being sequences. Does anyone know a better way to achieve this type of > replication? > -- ~Wayne Wayne E. Seguin wayneeseg...@gmail.com wayneeseguin on irc.freenode.net http://twitter.com/wayneeseguin/ https://github.com/wayneeseguin/

[GENERAL] [BDR] vs pgpool-II v3

2015-08-13 Thread Wayne E. Seguin
nd no SQL changes required on an application side." I appreciate any input as to pros/cons of BDR vs PGPool-II v3 in this context. ~Wayne Wayne E. Seguin wayneeseg...@gmail.com wayneeseguin on irc.freenode.net http://twitter.com/wayneeseguin/ https://github.com/wayneeseguin/

Re: [GENERAL] [BDR] vs pgpool-II v3

2015-08-13 Thread Wayne E. Seguin
The question is specifically about the replication feature mentioned here http://www.pgpool.net/mediawiki/index.php/Main_Page for the purposes of failing over minimizing downtime. On Thu, Aug 13, 2015 at 12:28 PM, Joshua D. Drake wrote: > > On 08/13/2015 08:52 AM, Wayne E. Seguin

Re: [GENERAL] [BDR] vs pgpool-II v3

2015-08-13 Thread Wayne E. Seguin
(But thank you for the response!!!) On Thu, Aug 13, 2015 at 1:37 PM, Wayne E. Seguin wrote: > The question is specifically about the replication feature mentioned here > http://www.pgpool.net/mediawiki/index.php/Main_Page for the purposes of > failing over minimizing downtime. > &

Re: [GENERAL] [BDR] vs pgpool-II v3

2015-08-17 Thread Wayne E. Seguin
Thank you everyone for your replies, the thoughts and context are greatly appreciated! On Sun, Aug 16, 2015 at 9:35 PM, Craig Ringer wrote: > On 13 August 2015 at 23:52, Wayne E. Seguin > wrote: > > > The context of this is using BDR to implement a HA solution where we >