Re: postgresql-9.4-BDR replication issue

From: Shreeyansh Dba <shreeyansh2014(at)gmail(dot)com>
To: Mikhail Levandovskiy <mikhail(dot)levandovskiy(at)nixsolutions(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 12:16:14
Message-ID: CAGDYbUNOVrmrCoED7eq-Ha6bDaQcXyzC6otJXQu2=0RSiLNY9Q@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin

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

In response to

Responses

Browse pgsql-admin by date

  From Date Subject
Next Message Rafał Radecki 2015-05-25 12:42:56 Minor upgrades of postgre in aws rds?
Previous Message Mikhail Levandovskiy 2015-05-25 11:38:29 Re: postgresql-9.4-BDR replication issue