On 28 August 2015 at 00:35, cchee-ob <carter.chee@xxxxxxxxxxxxxxxx> wrote: > 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 nodes and have no issue with this command and BDR > works fine. Is there anything that can be done to insure this command > executes properly on an existing database? Check the PostgreSQL logs on the node(s). The wait for ready function does just that - it waits. If the node never joins properly and never reaches the ready state, it'll wait indefinitely. There is presumably an issue with the node joining. To learn more you'll need to take a look at the log files. We cannot, unfortunately, have bdr_node_join wait until the join completes, because it's necessary to co-ordinate with background workers, commit multiple transactions, etc. It's not clear from your description what you mean by "on an existing database". Details? -- Craig Ringer http://www.2ndQuadrant.com/ PostgreSQL Development, 24x7 Support, Training & Services -- Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
