Postgresql BDR Replication Setup Issue - Mailing list pgsql-general

Hi,

We are setting up 2-node Postgresql BDR replication at our place and I am getting the following error after bdr_init_copy command.

FYI, We have a production Postgres database and we are setting up the Master-Master BDR replication for the production database.

==== Postgres Version

Postgres Version: psql (9.4.2)

apimgtdb=# SELECT bdr.bdr_version();

bdr_version

0.9.1-2015-05-26-1519509

==== bdr_init_copy running from Node2

-bash-4.1$ /usr/pgsql-9.4/bin/bdr_init_copy -d "host=10.10.145.111 dbname=apimgtdb port=5432" --local-dbname="host=10.10.145.110 dbname=apimgtdb port=5432" -n nodeawswest -D  /postgres/pgsql-9.4/data

bdr_init_copy: starting ...

Getting remote server identification ...

Detected 1 BDR database(s) on remote server

Updating BDR configuration on the remote node:

apimgtdb: validating BDR configuration ...

apimgtdb: creating replication slot ...

apimgtdb: creating node entry for local node ...

Creating base backup of the remote node...

3616364/3616364 kB (100%), 1/1 tablespace

Creating restore point on remote node ...

Bringing local node to the restore point ...

Could not update security label: ERROR:  cannot execute DELETE in a read-only transaction

==== Recovery file on Node2

cat recovery.conf

standby_mode = 'on'

primary_conninfo = 'dbname=apimgtdb host=10.10.145.111 port=5432'

recovery_target_name = 'bdr_6158050998150972399'

recovery_target_inclusive = true

====== Data from Node2 log file

< 2015-06-08 10:08:45.957 PDT >LOG:  entering standby mode

< 2015-06-08 10:08:45.958 PDT >LOG:  starting up replication identifier with ckpt at 9/F9000028

< 2015-06-08 10:08:45.965 PDT >LOG:  redo starts at 9/F9000028

< 2015-06-08 10:08:45.969 PDT >LOG:  consistent recovery state reached at 9/F90000F0

< 2015-06-08 10:08:45.970 PDT >LOG:  database system is ready to accept read only connections

< 2015-06-08 10:08:45.980 PDT >LOG:  started streaming WAL from primary at 9/FA000000 on timeline 1

< 2015-06-08 10:08:46.180 PDT >LOG:  recovery stopping at restore point "bdr_6158052372057789529", time 2015-06-08 10:08:31.448384-07

< 2015-06-08 10:08:46.180 PDT >LOG:  recovery has paused

< 2015-06-08 10:08:46.180 PDT >HINT:  Execute pg_xlog_replay_resume() to continue.

< 2015-06-08 10:08:46.236 PDT >ERROR:  cannot execute DELETE in a read-only transaction

< 2015-06-08 10:08:46.236 PDT >STATEMENT:  DELETE FROM pg_catalog.pg_shseclabel WHERE provider = 'bdr';

< 2015-06-08 10:08:46.251 PDT >LOG:  received smart shutdown request

< 2015-06-08 10:08:46.253 PDT >FATAL:  terminating walreceiver process due to administrator command

< 2015-06-08 10:08:46.255 PDT >LOG:  shutting down

< 2015-06-08 10:08:46.317 PDT >LOG:  database system is shut down

Thanks for your help!