Search Postgresql Archives

Postgresql BDR Replication Setup Issue

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

 



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!

Regards,

ravi

 

 

________________________________________________________________________
The preceding e-mail message (including any attachments) contains
information that may be confidential, be protected by the
attorney-client or other applicable privileges, or constitute non-public
information. It is intended to be read only by the individual or entity
to whom it is addressed or by their designee. If you are not an intended
recipient of this message, please notify the sender by replying to this
message and then delete it from your system. You are on notice that
further use, dissemination, distribution, or reproduction of this
message is strictly prohibited and may be unlawful.


[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