Re: Unrecognized configuration parameter in bdr 0.9.3

[Kaushal Shriyan <kaushalshriyan@xxxxxxxxx>]

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