Re: postgresql-9.4-BDR replication issue

Поиск
Список
Период
Сортировка
От Mikhail Levandovskiy
Тема Re: postgresql-9.4-BDR replication issue
Дата
Msg-id 55631E1C.7020502@nixsolutions.com
обсуждение исходный текст
Ответ на Re: postgresql-9.4-BDR replication issue  (Shreeyansh Dba <shreeyansh2014@gmail.com>)
Список 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

-- 
------------------------
Best regards,
System Administration Dept.
NIX Solutions Ltd. 

В списке pgsql-admin по дате отправления:

Предыдущее
От: Rafał Radecki
Дата:
Сообщение: Minor upgrades of postgre in aws rds?
Следующее
От: Bruce Momjian
Дата:
Сообщение: Re: Minor upgrades of postgre in aws rds?