[GENERAL] Trying to setup pglogical with no success

Here's what I have done to try to set up pglogical. What am I doing wrong? 2 nodes provider - 10.241.0.10 subscriber - 10.241.0.12 svp2=# select version(); version -

[GENERAL] BDR not catching up

I'm getting this message repeating on the UDR node that I just added today. Any way to get it start applying? svp2=# select * from bdr.bdr_nodes; node_sysid | node_timeline | node_dboid | node_status | node_name|node_local_dsn | node_init_from_ds

[GENERAL] BDR concern/issue

I queried pg_replication_slots after I removed an BDR node and I noticed a slot_name that isn't in bdr.bdr_node_slots. And active is 'f' and it has been retaining bytes. Should I be concerned and is there a way to remove it. I do still have one UDR node which is running (bdr_16385_62289942768143

[GENERAL] BDR error trying to replay a invalid statement

I noticed that the BDR replication continually trying to replay a ddl statement that has a syntax error. Is there anything that can be done to skip this statement or do I need to rebuild the replicated node? Here's what I see in the logs: t=2016-02-01 13:02:27 PST d= h= p=21795 a=LOCATION: bdr_

Re: [GENERAL] BDR setup - bdr_node_join_wait_for_ready()

Craig, By an existing database, I mean I have a database that has our data on it. I have created the btree_gist and bdr extensions and ran the bdr.bdr_group_create () function and the bdr.bdr_node_join_wait_for_ready(), all run successfully. After setting up the next BDR node, and after running

Re: [GENERAL] BDR setup - bdr_node_join_wait_for_ready()

I have not used the bdr_init_copy procedure because I've haven't been able to find any step by step documentation on how to use. Can you provide some? -- View this message in context: http://postgresql.nabble.com/BDR-setup-bdr-node-join-wait-for-ready-tp5863606p5864210.html Sent from the Pos

[GENERAL] BDR setup - bdr_node_join_wait_for_ready()

What exactly does bdr_node_wait_for_ready() do? I've been trying to setup BDR on an existing database and once I run the select bdr.bdr_node_wait_for_ready(); command on the 2nd node after running the bdr.bdr_group_join() command it just hangs . I've done the same setup procedure on brand new nod

Re: [GENERAL] BDR - Failure of Primary Server - How to recover?

I understand removing the BDR node with bdr.bdr_part_by_node_names (). But if I need create another BDR node what would I reference for the join_using_dsn string on the new node, if the primary doen't exist any more? Thanks! Carter -- View this message in context: http://postgresql.nabble.co

[GENERAL] BDR - Failure of Primary Server - How to recover?

If my Primary Server in a BDR environment fails what is my recourse for recovery? My servers are in the cloud so I don't have control over IP address assignment either. This hasn't happen but I need to present a plan if our Production system has this occur. Thanks in advance! Carter Objectbrain

Re: [GENERAL] Getting UDR up and running

I used the BDR 0.10.0 Documentation to set up UDR. Basically you set the UDR node the same way as a BDR node and you use the bdr.bdr_subscribe function to subscribe to the node that you ran the brr.bdr_group_create function on. It works great! The only caveat is that if you are running any DDL