pg.ddx.io pgsql-admin@postgresql.org mailing list archive
help / color / mirror / Atom feed From: Mikhail Levandovskiy <mikhail.levandovskiy@nixsolutions.com>
To: Shreeyansh Dba <shreeyansh2014@gmail.com>
Cc: pgsql-admin@postgresql.org <pgsql-admin@postgresql.org>
Subject: Re: postgresql-9.4-BDR replication issue
Date: Mon, 25 May 2015 16:05:32 +0300
Message-ID: <55631E1C.7020502@nixsolutions.com> (raw )
In-Reply-To: <CAGDYbUNOVrmrCoED7eq-Ha6bDaQcXyzC6otJXQu2=0RSiLNY9Q@mail.gmail.com >
References: <5562FEAB.1040903@nixsolutions.com >
<CAGDYbUNOVrmrCoED7eq-Ha6bDaQcXyzC6otJXQu2=0RSiLNY9Q@mail.gmail.com >
List-Unsubscribe: <mailto:majordomo@postgresql.org?body=unsub%20pgsql-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.
view thread (4+ messages)
Message-ID: <55631E1C.7020502@nixsolutions.com>
Permalink: ../55631E1C.7020502@nixsolutions.com/
Also on: postgresql.org/message-id/55631E1C.7020502@nixsolutions.com
copy link · copy postgr.es
reply Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-admin@postgresql.org
Cc: mikhail.levandovskiy@nixsolutions.com, shreeyansh2014@gmail.com
Subject: Re: postgresql-9.4-BDR replication issue
In-Reply-To: <55631E1C.7020502@nixsolutions.com>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox