I’ve been having issues while attempting to begin BDR replication. If I set up the main node, then use bdr_init_copy, it always fails on second node, as shown below. postgres$ rm -Rf $PGDATA postgres$ echo db_password | pg_basebackup -X stream -h main_node_ip -p 5432 -U username -D $PGDATA postgres$ cp $HOME/backup/postgresql.conf $PGDATA postgres$ bdr_init_copy -U username -D $PGDATA bdr_init_copy: starting... Assigning new system identifier: 6098464173726284030... Creating primary replication slots... Creating restore point... Could not connect to the remote server: could not connect to server: No such file or directory Is the server running locally and accepting connections on Unix domain socket "/tmp/.s.PGSQL.5432"? If I start both servers simply by using pg_ctl using conf set up for replication, I get the following error on the main node:. LOG: starting background worker process "bdr (6098483684958107256,1,16384,): dr: apply" CONTEXT: slot "bdr_16384_6098483684958107256_1_16384__", output plugin "bdr", in the startup callback ERROR: data stream ended LOG: worker process: bdr (6098483684958107256,1,16384,): dr: apply (PID 6294) exited with exit code 1 … and, I get the following error on the second node: ERROR: bdr output plugin: slot creation rejected, bdr.bdr_nodes entry for local node (sysid=6098483778037269710, timelineid=1, dboid=16384): status='i', bdr still starting up: applying initial dump of remote node HINT: Monitor pg_stat_activity and the logs, wait until the node has caught up CONTEXT: slot "bdr_16384_6098483684958107256_1_16384__", output plugin "bdr", in the startup callback LOG: could not receive data from client: Connection reset by peer It will keep cycling these errors indefinitely. I have gotten this working off and on; but, I keep running into this issue. I am on CentOS 6.5. Both servers can execute psql against the databases on other nodes when not configured for replication, so it is not a connectivity or firewall issue. I have installed using the beta2 rpm as well as built it from source for rc1 (bdr stable). Any ideas? |
