Received: from malur.postgresql.org ([217.196.149.56])
 by arkaria.postgresql.org with esmtp (Exim 4.80) (envelope-from
 <pgsql-admin-owner+M44013=pgsql+2Dadmin=arkaria.postgresql.org@postgresql.org>)
 id 1Yws49-00030I-TR
 for pgsql-admin@arkaria.postgresql.org; Mon, 25 May 2015 13:05:14 +0000
Received: from localhost ([127.0.0.1] helo=postgresql.org)
 by malur.postgresql.org with smtp (Exim 4.80) (envelope-from
 <pgsql-admin-owner+M44013=pgsql+2Dadmin=arkaria.postgresql.org@postgresql.org>)
 id 1Yws49-0007A5-7h
 for pgsql-admin@arkaria.postgresql.org; Mon, 25 May 2015 13:05:13 +0000
Received: from magus.postgresql.org ([2a02:c0:301:0:ffff::29])
 by malur.postgresql.org with esmtps (TLS1.2:RSA_AES_256_CBC_SHA256:256)
 (Exim 4.80) (envelope-from <mikhail.levandovskiy@nixsolutions.com>)
 id 1Yws46-00078b-Q1
 for pgsql-admin@postgresql.org; Mon, 25 May 2015 13:05:10 +0000
Received: from smtp.nixsolutions.com ([91.208.153.2])
 by magus.postgresql.org with esmtps (TLS1.0:RSA_AES_256_CBC_SHA1:256)
 (Exim 4.84) (envelope-from <mikhail.levandovskiy@nixsolutions.com>)
 id 1Yws3z-0003lW-52
 for pgsql-admin@postgresql.org; Mon, 25 May 2015 13:05:09 +0000
DKIM-Signature: v=1; a=rsa-sha256; q=dns/txt; c=relaxed/relaxed;
 d=nixsolutions.com; s=mail;
 h=Content-Type:In-Reply-To:References:Subject:CC:To:MIME-Version:From:Date:Message-ID;
 bh=dJFOgEzGAUCYhVISlP6E8+cg5bXhoFC4lWdwBNt9TUo=;
 b=LF1VP/3j4qW7w0MxTjsLoKNX8tqDwrGKxRok/ZbTMPyNYu/EHN8KzTK5LtCTR0tGJpcmbUUV08aKhlvqIeXkz1apLKOg3EWyLsKAmdFOj3aKpeSeWCHl18PsKBFZywTHHEP9DbSeJT31lCY5HAMKVnd4K47kpfJZoJSVHcz4ZHg=;
Received: from [10.10.100.113]
 by smtp.nixsolutions.com with esmtpsa (TLS1.0:DHE_RSA_AES_128_CBC_SHA1:16)
 (Exim 4.76) (envelope-from <mikhail.levandovskiy@nixsolutions.com>)
 id 1Yws58-0008KK-1n; Mon, 25 May 2015 16:06:17 +0300
Message-ID: <55631E1C.7020502@nixsolutions.com>
Date: Mon, 25 May 2015 16:05:32 +0300
From: Mikhail Levandovskiy <mikhail.levandovskiy@nixsolutions.com>
User-Agent: Mozilla/5.0 (X11; Linux x86_64;
 rv:31.0) Gecko/20100101 Thunderbird/31.7.0
MIME-Version: 1.0
To: Shreeyansh Dba <shreeyansh2014@gmail.com>
CC: "pgsql-admin@postgresql.org" <pgsql-admin@postgresql.org>
Subject: Re: postgresql-9.4-BDR replication issue
References: <5562FEAB.1040903@nixsolutions.com>
 <CAGDYbUNOVrmrCoED7eq-Ha6bDaQcXyzC6otJXQu2=0RSiLNY9Q@mail.gmail.com>
In-Reply-To: 
 <CAGDYbUNOVrmrCoED7eq-Ha6bDaQcXyzC6otJXQu2=0RSiLNY9Q@mail.gmail.com>
Content-Type: multipart/alternative;
 boundary="------------090004020300070606070607"
X-Pg-Spam-Score: -2.0 (--)
List-Archive: <http://archives.postgresql.org/pgsql-admin>
List-Help: <mailto:majordomo@postgresql.org?body=help>
List-ID: <pgsql-admin.postgresql.org>
List-Owner: <mailto:pgsql-admin-owner@postgresql.org>
List-Post: <mailto:pgsql-admin@postgresql.org>
List-Subscribe: <mailto:majordomo@postgresql.org?body=sub%20pgsql-admin>
List-Unsubscribe: <mailto:majordomo@postgresql.org?body=unsub%20pgsql-admin>
X-Mailing-List: pgsql-admin
Precedence: bulk
Sender: pgsql-admin-owner@postgresql.org

This is a multi-part message in MIME format.
--------------090004020300070606070607
Content-Type: text/plain; charset=utf-8; format=flowed
Content-Transfer-Encoding: 7bit

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.


--------------090004020300070606070607
Content-Type: text/html; charset=utf-8
Content-Transfer-Encoding: 8bit

<html>
  <head>
    <meta content="text/html; charset=utf-8" http-equiv="Content-Type">
  </head>
  <body bgcolor="#FFFFFF" text="#000000">
    BDR replication link on new databases wokring properly.<br>
    Looks like something wrong with existing DBs...<br>
    <br>
    <div class="moz-cite-prefix">On 25/05/15 15:16, Shreeyansh Dba
      wrote:<br>
    </div>
    <blockquote
cite="mid:CAGDYbUNOVrmrCoED7eq-Ha6bDaQcXyzC6otJXQu2=0RSiLNY9Q@mail.gmail.com"
      type="cite">
      <div dir="ltr">if you are trying to create new database the follow
        the steps
        <div>
          <div><br>
          </div>
          <div>Exeute On both servers(nodes)</div>
          <div>-create database new_bdrdemo;</div>
          <div>-\c new_bdrdemo</div>
          <div>-create extension btree_gist;</div>
          <div>-create extension bdr;</div>
          <div><br>
          </div>
          <div>_______________</div>
          <div>On node1</div>
          <div>-SELECT bdr.bdr_group_create(local_node_name := 'node1',</div>
          <div>node_external_dsn := 'host=10.10.1.39
            dbname=new_bdrdemo');</div>
          <div><br>
          </div>
          <div>-SELECT bdr.bdr_node_join_wait_for_ready();</div>
          <div><br>
          </div>
          <div>_____________________</div>
          <div>On node2</div>
          <div>-SELECT bdr.bdr_group_join(local_node_name := 'node2',</div>
          <div> node_external_dsn := 'host=10.10.5.107 port=5432
            dbname=new_bdrdemo',</div>
          <div> join_using_dsn := 'host=10.10.1.39 port=5432
            dbname=new_bdrdemo');</div>
          <div> </div>
          <div>-SELECT bdr.bdr_node_join_wait_for_ready();</div>
          <div><br>
          </div>
          <div><br>
          </div>
          <div>Thanks and Regards,</div>
        </div>
        <div class="gmail_extra">
          <div class="gmail_quote">
            <div>Sagar R. Jadhav</div>
            <div><a moz-do-not-send="true"
                href="http://www.shreeyansh.com/" target="_blank"
                tabindex="-1" rel="external"
                style="outline:0px;color:rgb(102,0,153);font-size:12px;line-height:20px"><span
                  style="outline:0px;color:rgb(0,0,255)">www.shreeyansh.com</span></a> </div>
          </div>
        </div>
      </div>
    </blockquote>
    <br>
    <pre class="moz-signature" cols="72">-- 
------------------------
Best regards,
System Administration Dept.
NIX Solutions Ltd. </pre>
  </body>
</html>

--------------090004020300070606070607--