Re: postgresql-9.4-BDR replication issue

From: Mikhail Levandovskiy <mikhail(dot)levandovskiy(at)nixsolutions(dot)com>
To: Shreeyansh Dba <shreeyansh2014(at)gmail(dot)com>
Cc: "pgsql-admin(at)postgresql(dot)org" <pgsql-admin(at)postgresql(dot)org>
Subject: Re: postgresql-9.4-BDR replication issue
Date: 2015-05-25 13:05:32
Message-ID: 55631E1C.7020502@nixsolutions.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin

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 <http://www.shreeyansh.com/>

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

In response to

Browse pgsql-admin by date

  From Date Subject
Next Message Bruce Momjian 2015-05-25 13:08:56 Re: Minor upgrades of postgre in aws rds?
Previous Message Rafał Radecki 2015-05-25 12:42:56 Minor upgrades of postgre in aws rds?