Search Postgresql Archives

Re: Unrecognized configuration parameter in bdr 0.9.3

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



On Fri, Feb 12, 2016 at 7:40 AM, Craig Ringer <craig@xxxxxxxxxxxxxxx> wrote:
On 11 February 2016 at 20:16, Kaushal Shriyan <kaushalshriyan@xxxxxxxxx> wrote:
Hi,

I am following http://bdr-project.org/docs/stable/index.html for setting up multimaster replication. 

Are you sure that's the documentation you were using?

You seem to have settings that only applied to the older 0.7.x versions:
 
# (BEGIN) BDR connection settings for node 1, port 5600
bdr.connections = 'secondarymasterport5601'
bdr.secondarymasterport5601_dsn = 'dbname=bdrdemo user=postgres port=5601'
# (END) BDR connection settings for node 1, port 5600

# (BEGIN) BDR connection settings for node 2, port 5601
#bdr.connections = '{DevEnvName}node01port5600'
#bdr.{DevEnvName}node01port5600_dsn = 'dbname={DevDBName} user=postgres port=5600'
#bdr.{DevEnvName}node01port5600_init_replica = on
#bdr.{DevEnvName}node01port5600_replica_local_dsn = 'dbname={DevDBName} user=postgres port=5601'
# (END) BDR connection settings for node 2, port 5601

The above is not used in BDR 0.9.x. Configuration is done at the SQL level.

--

Hi Craig,

Primary Master Postgresql Node ( IP :- 192.168.10.1)

1)psql --port 5600 --username postgres --dbname bdrdemo

2)CREATE EXTENSION btree_gist;
3)CREATE EXTENSION bdr;

4)SELECT bdr.bdr_group_create(local_node_name := 'node1',node_external_dsn := 'port=5600 dbname=bdrdemo');
5)SELECT bdr.bdr_node_join_wait_for_ready();


Secondary Master Postgresql Node ( IP :- 192.168.10.2)

6)psql --port 5601 --username postgres --dbname bdrdemo

7)CREATE EXTENSION btree_gist;
8)CREATE EXTENSION bdr;

9)SELECT bdr.bdr_group_join(local_node_name := 'node2',node_external_dsn := 'port=5601 dbname=bdrdemo', join_using_dsn := 'port=5600 dbname=bdrdemo' );
10)SELECT bdr.bdr_node_join_wait_for_ready();

Based on http://blog.2ndquadrant.com/dynamic-sql-level-configuration-for-bdr-0-9-0/ since my setup is hosted on two different servers. So if i execute the step no. 4 in Primary Master Node (IP :- 192.168.10.1) as below

SELECT bdr.bdr_group_create(local_node_name := 'node1',node_external_dsn := 'host 192.168.10.1 port=5600 dbname=bdrdemo');

and Step No. 9 in Secondary Master Postgresql Node ( IP :- 192.168.10.2) as below.

SELECT bdr.bdr_group_join(local_node_name := 'node2',node_external_dsn := 'port=5601 dbname=bdrdemo', join_using_dsn := 'host 192.168.10.2 port=5600 dbname=bdrdemo' );

Are those select statements highlighted in red are supported and correct and executed at the SQL Level meaning after adding host 192.168.10.1 in dsn of Primary Master and host 192.168.10.2 in dsn of Secondary Master?  

Please comment.

Thanks in Advance

Regards,

Kaushal



[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
[Index of Archives]     [Postgresql Jobs]     [Postgresql Admin]     [Postgresql Performance]     [Linux Clusters]     [PHP Home]     [PHP on Windows]     [Kernel Newbies]     [PHP Classes]     [PHP Books]     [PHP Databases]     [Postgresql & PHP]     [Yosemite]
  Powered by Linux