Re: postgresql-9.4-BDR replication issue - Mailing list pgsql-admin

BDR replication link on new databases wokring properly.
Looks like something wrong with existing DBs...

if you are trying to create new database the follow the steps

Exeute On both servers(nodes)

-create database new_bdrdemo;

-\c new_bdrdemo

-create extension btree_gist;

-create extension bdr;

_______________

On node1

-SELECT bdr.bdr_group_create(local_node_name := 'node1',

node_external_dsn := 'host=10.10.1.39 dbname=new_bdrdemo');

-SELECT bdr.bdr_node_join_wait_for_ready();

_____________________

On node2

-SELECT bdr.bdr_group_join(local_node_name := 'node2',

 node_external_dsn := 'host=10.10.5.107 port=5432 dbname=new_bdrdemo',

 join_using_dsn := 'host=10.10.1.39 port=5432 dbname=new_bdrdemo');

 

-SELECT bdr.bdr_node_join_wait_for_ready();

Thanks and Regards,

Sagar R. Jadhav

www.shreeyansh.com 

-- 
------------------------
Best regards,
System Administration Dept.
NIX Solutions Ltd.