Re: postgresql-9.4-BDR replication issue

[Mikhail Levandovskiy <mikhail.levandovskiy@xxxxxxxxxxxxxxxx>]

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

On 25/05/15 15:16, Shreeyansh Dba wrote:

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.