Postgres Pro
Downloads
Home   >   mailing lists

Re: postgresql-9.4-BDR replication issue - Mailing list pgsql-admin

From Shreeyansh Dba
Subject Re: postgresql-9.4-BDR replication issue
Date
Msg-id CAGDYbUNOVrmrCoED7eq-Ha6bDaQcXyzC6otJXQu2=0RSiLNY9Q@mail.gmail.com
Whole thread Raw
In response to postgresql-9.4-BDR replication issue  (Mikhail Levandovskiy <mikhail.levandovskiy@nixsolutions.com>)
Responses Re: postgresql-9.4-BDR replication issue
List pgsql-admin
Tree view
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

pgsql-admin by date:

Previous
From: Mikhail Levandovskiy
Date:
Subject: Re: postgresql-9.4-BDR replication issue
Next
From: Rafał Radecki
Date:
Subject: Minor upgrades of postgre in aws rds?