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.
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? |