Unrecognized configuration parameter in bdr 0.9.3

From: Kaushal Shriyan <kaushalshriyan(at)gmail(dot)com>
To: "pgsql-general(at)postgresql(dot)org" <pgsql-general(at)postgresql(dot)org>
Subject: Unrecognized configuration parameter in bdr 0.9.3
Date: 2016-02-11 12:16:17
Message-ID: CAD7Ssm-J70K4sJk0idWyRuMVF8GK0cCTZb9fFfFpkaLLpb27Qw@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Hi,

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

*First Master box*

*cat postgresql.conf*
# Allow two other peer nodes, plus one for init_replica
max_replication_slots = 3

# Two peer nodes, plus two slots for pg_basebackup
max_wal_senders = 4

# Record data for logical replication
wal_level = 'logical'
track_commit_timestamp = on

# Load BDR
shared_preload_libraries = 'bdr'

# Make sure there are enough background worker slots for BDR to run
max_worker_processes = 10

# These aren't required, but are useful for diagnosing problems
#log_error_verbosity = verbose
#log_min_messages = debug1
#log_line_prefix = 'd=%d p=%p a=%a%q '

# Useful options for playing with conflicts
#bdr.default_apply_delay=2000 # milliseconds
#bdr.log_conflicts_to_table=on

# (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

cat postgresql.log
< 2016-02-11 07:03:09.431 EST >LOG: registering background worker "bdr
supervisor"
*< 2016-02-11 07:03:09.431 EST >WARNING: unrecognized configuration
parameter "bdr.connections"*
*< 2016-02-11 07:03:09.431 EST >WARNING: unrecognized configuration
parameter "bdr.secondarymasterport5601_dsn"*
< 2016-02-11 07:03:09.446 EST >LOG: redirecting log output to logging
collector process
< 2016-02-11 07:03:09.446 EST >HINT: Future log output will appear in
directory "pg_log".

*Second Master Box.*

*cat postgresql.conf*
# Allow two other peer nodes, plus one for init_replica
max_replication_slots = 3

# Two peer nodes, plus two slots for pg_basebackup
max_wal_senders = 4

# Record data for logical replication
wal_level = 'logical'
track_commit_timestamp = on

# Load BDR
shared_preload_libraries = 'bdr'

# Make sure there are enough background worker slots for BDR to run
max_worker_processes = 10

# These aren't required, but are useful for diagnosing problems
#log_error_verbosity = verbose
#log_min_messages = debug1
#log_line_prefix = 'd=%d p=%p a=%a%q '

# Useful options for playing with conflicts
#bdr.default_apply_delay=2000 # milliseconds
#bdr.log_conflicts_to_table=on

# (BEGIN) BDR connection settings for node 1, port 5600
#bdr.connections = 'primarymasterport5600'
#bdr.primarymasterport5600_dsn = 'dbname=bdrdemo user=postgres port=5600'
#bdr.primarymasterport5600_init_replica = on
#bdr.primarymasterport5600_replica_local_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 = 'primarymasterport5600'
bdr.primarymasterport5600_dsn = 'dbname=bdrdemo user=postgres port=5600'
bdr.primarymasterport5600_init_replica = on
bdr.primarymasterport5600_replica_local_dsn = 'dbname=bdrdemo user=postgres
port=5601'
#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

-bash-4.1$ cat postgresql.log
< 2016-02-11 07:03:17.231 EST >LOG: registering background worker "bdr
supervisor"
*< 2016-02-11 07:03:17.231 EST >WARNING: unrecognized configuration
parameter "bdr.connections"*
*< 2016-02-11 07:03:17.231 EST >WARNING: unrecognized configuration
parameter "bdr.primarymasterport5600_dsn"*
*< 2016-02-11 07:03:17.231 EST >WARNING: unrecognized configuration
parameter "bdr.primarymasterport5600_init_replica"*
*< 2016-02-11 07:03:17.231 EST >WARNING: unrecognized configuration
parameter "bdr.primarymasterport5600_replica_local_dsn"*
< 2016-02-11 07:03:17.247 EST >LOG: redirecting log output to logging
collector process
< 2016-02-11 07:03:17.247 EST >HINT: Future log output will appear in
directory "pg_log".
-bash-4.1$

On both the master postgresql box i have the below versions.

$rpm -qa | grep bdr
postgresql-bdr94-2ndquadrant-redhat-1.0-2.noarch
postgresql-bdr94-contrib-9.4.5_bdr1-1_2ndQuadrant.el6.x86_64
libdrm-2.4.52-4.el6.x86_64
postgresql-bdr94-libs-9.4.5_bdr1-1_2ndQuadrant.el6.x86_64
postgresql-bdr94-server-9.4.5_bdr1-1_2ndQuadrant.el6.x86_64
postgresql-bdr94-bdr-0.9.3-1_2ndQuadrant.el6.x86_64
postgresql-bdr94-9.4.5_bdr1-1_2ndQuadrant.el6.x86_64
-bash-4.1$ rpm -qil postgresql-bdr94-bdr-0.9.3-1_2ndQuadrant.el6.x86_64
Name : postgresql-bdr94-bdr Relocations: (not relocatable)
Version : 0.9.3 Vendor: (none)
Release : 1_2ndQuadrant.el6 Build Date: Wed 21 Oct 2015
02:36:18 AM EDT
Install Date: Mon 01 Feb 2016 03:47:27 AM EST Build Host:
ip-10-169-124-243.ec2.internal
Group : Applications/Databases Source RPM:
postgresql-bdr94-bdr-0.9.3-1_2ndQuadrant.el6.src.rpm
Size : 1487220 License: PostgreSQL
Signature : RSA/SHA1, Wed 21 Oct 2015 02:36:46 AM EDT, Key ID
a879b7346e192b0e
URL : http://2ndquadrant.com/bdr
Summary : BDR - Bi-Directional Replication for PostgreSQL
Description :
postgresql-bdr94-bdr installs the 'bdr' extension for bi-directional
asynchronous multi-master replication in PostgreSQL.

This package contains BDR 0.9.3 built with PostgreSQL postgresql-bdr94 plus
BDR support patches.
/usr/pgsql-9.4/bin/bdr_dump
/usr/pgsql-9.4/bin/bdr_init_copy
/usr/pgsql-9.4/bin/bdr_initial_load
/usr/pgsql-9.4/bin/bdr_resetxlog
/usr/pgsql-9.4/lib/bdr.so
/usr/pgsql-9.4/share/extension/bdr--0.7--0.7.1.sql
/usr/pgsql-9.4/share/extension/bdr--0.7.1--0.8.0.sql
/usr/pgsql-9.4/share/extension/bdr--0.8.0--0.8.0.1.sql
/usr/pgsql-9.4/share/extension/bdr--0.8.0.1--0.8.0.2.sql
/usr/pgsql-9.4/share/extension/bdr--0.8.0.1.sql
/usr/pgsql-9.4/share/extension/bdr--0.8.0.2--0.8.0.3.sql
/usr/pgsql-9.4/share/extension/bdr--0.8.0.2.sql
/usr/pgsql-9.4/share/extension/bdr--0.8.0.3--0.8.0.4.sql
/usr/pgsql-9.4/share/extension/bdr--0.8.0.3.sql
/usr/pgsql-9.4/share/extension/bdr--0.8.0.4--0.8.0.5.sql
/usr/pgsql-9.4/share/extension/bdr--0.8.0.4.sql
/usr/pgsql-9.4/share/extension/bdr--0.8.0.5--0.8.0.6.sql
/usr/pgsql-9.4/share/extension/bdr--0.8.0.5.sql
/usr/pgsql-9.4/share/extension/bdr--0.8.0.6--0.8.0.7.sql
/usr/pgsql-9.4/share/extension/bdr--0.8.0.6.sql
/usr/pgsql-9.4/share/extension/bdr--0.8.0.7--0.9.0.0.sql
/usr/pgsql-9.4/share/extension/bdr--0.8.0.7.sql
/usr/pgsql-9.4/share/extension/bdr--0.8.0.sql
/usr/pgsql-9.4/share/extension/bdr--0.9.0.0--0.9.0.1.sql
/usr/pgsql-9.4/share/extension/bdr--0.9.0.0.sql
/usr/pgsql-9.4/share/extension/bdr--0.9.0.1--0.9.0.2.sql
/usr/pgsql-9.4/share/extension/bdr--0.9.0.1.sql
/usr/pgsql-9.4/share/extension/bdr--0.9.0.2--0.9.0.3.sql
/usr/pgsql-9.4/share/extension/bdr--0.9.0.2.sql
/usr/pgsql-9.4/share/extension/bdr--0.9.0.3--0.9.0.4.sql
/usr/pgsql-9.4/share/extension/bdr--0.9.0.3.sql
/usr/pgsql-9.4/share/extension/bdr--0.9.0.4--0.9.0.5.sql
/usr/pgsql-9.4/share/extension/bdr--0.9.0.4.sql
/usr/pgsql-9.4/share/extension/bdr--0.9.0.5--0.9.1.0.sql
/usr/pgsql-9.4/share/extension/bdr--0.9.0.5.sql
/usr/pgsql-9.4/share/extension/bdr--0.9.1.0--0.9.2.0.sql
/usr/pgsql-9.4/share/extension/bdr--0.9.1.0.sql
/usr/pgsql-9.4/share/extension/bdr--0.9.2.0--0.9.3.0.sql
/usr/pgsql-9.4/share/extension/bdr--0.9.2.0.sql
/usr/pgsql-9.4/share/extension/bdr--0.9.3.0.sql
/usr/pgsql-9.4/share/extension/bdr.control
/usr/share/doc/pgsql/extension/README.bdr
/usr/share/doc/pgsql/extension/bdr.conf.sample
-bash-4.1$

Please do let me know if anyone needs any information related to configs or
logs.
Any help will be highly appreciable.

Regards,

Kaushal

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Pierre Chevalier Géologue 2016-02-11 12:41:33 Re: PostgreSQL vs Firebird SQL
Previous Message Enrico Pirozzi 2016-02-11 12:11:43 memory problem with refresh materialized view