Re: Postgresql BDR Replication Setup Issue - Mailing list pgadmin-support

<div class="WordSection1"><p class="MsoNormal"><span style="font-size:10.0pt;font-family:"Times New
Roman","serif";color:#002060">Hi,</span><pstyle="margin-bottom:12.0pt;line-height:16.8pt;background:white"><span
style="font-size:10.5pt;font-family:"Helvetica","sans-serif";color:#333333">Weare setting up 2-node Postgresql BDR
replicationat our place and I am getting the following error after bdr_init_copy command.</span><p
class="MsoNormal"><spanstyle="font-size:10.0pt;font-family:"Times New Roman","serif";color:#002060">FYI, We have a
productionPostgres database and we are setting up the Master-Master BDR replication for the production
database.</span><pclass="MsoNormal"><span style="font-size:10.0pt;font-family:"Times New
Roman","serif";color:#002060"> </span><pclass="MsoNormal"><span style="font-size:10.0pt;font-family:"Times New
Roman","serif";color:#002060">====Postgres Version</span><p class="MsoNormal"><span
style="font-size:10.0pt;font-family:"TimesNew Roman","serif";color:#002060">Postgres Version: psql (9.4.2)</span><p
class="MsoNormal"><spanstyle="font-size:10.0pt;font-family:"Times New Roman","serif";color:#002060"> </span><p
class="MsoNormal"><spanstyle="font-size:10.0pt;font-family:"Times New Roman","serif";color:#002060">apimgtdb=# SELECT
bdr.bdr_version();</span><pclass="MsoNormal"><span style="font-size:10.0pt;font-family:"Times New
Roman","serif";color:#002060"> </span><pclass="MsoNormal"><span style="font-size:10.0pt;font-family:"Times New
Roman","serif";color:#002060">bdr_version</span><pclass="MsoNormal"><span style="font-size:10.0pt;font-family:"Times
NewRoman","serif";color:#002060">0.9.1-2015-05-26-1519509</span><p class="MsoNormal"><span
style="font-size:10.0pt;font-family:"TimesNew Roman","serif";color:#002060"> </span><p class="MsoNormal"><span
style="font-size:10.0pt;font-family:"TimesNew Roman","serif";color:#002060">==== bdr_init_copy running from
Node2</span><pclass="MsoNormal"><span style="font-size:10.0pt;font-family:"Times New
Roman","serif";color:#002060">-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</span><pclass="MsoNormal"><span style="font-size:10.0pt;font-family:"Times New
Roman","serif";color:#002060">bdr_init_copy:starting ...</span><p class="MsoNormal"><span
style="font-size:10.0pt;font-family:"TimesNew Roman","serif";color:#002060">Getting remote server identification
...</span><pclass="MsoNormal"><span style="font-size:10.0pt;font-family:"Times New
Roman","serif";color:#002060">Detected1 BDR database(s) on remote server</span><p class="MsoNormal"><span
style="font-size:10.0pt;font-family:"TimesNew Roman","serif";color:#002060">Updating BDR configuration on the remote
node:</span><pclass="MsoNormal"><span style="font-size:10.0pt;font-family:"Times New
Roman","serif";color:#002060">apimgtdb:validating BDR configuration ...</span><p class="MsoNormal"><span
style="font-size:10.0pt;font-family:"TimesNew Roman","serif";color:#002060">apimgtdb: creating replication slot
...</span><pclass="MsoNormal"><span style="font-size:10.0pt;font-family:"Times New
Roman","serif";color:#002060">apimgtdb:creating node entry for local node ...</span><p class="MsoNormal"><span
style="font-size:10.0pt;font-family:"TimesNew Roman","serif";color:#002060">Creating base backup of the remote
node...</span><pclass="MsoNormal"><span style="font-size:10.0pt;font-family:"Times New
Roman","serif";color:#002060">3616364/3616364kB (100%), 1/1 tablespace</span><p class="MsoNormal"><span
style="font-size:10.0pt;font-family:"TimesNew Roman","serif";color:#002060">Creating restore point on remote node
...</span><pclass="MsoNormal"><span style="font-size:10.0pt;font-family:"Times New
Roman","serif";color:#002060">Bringinglocal node to the restore point ...</span><p class="MsoNormal"><span
style="font-size:10.0pt;font-family:"TimesNew Roman","serif";color:#002060">Could not update security label: ERROR: 
cannotexecute DELETE in a read-only transaction</span><p class="MsoNormal"><span
style="font-size:10.0pt;font-family:"TimesNew Roman","serif";color:#002060"> </span><p class="MsoNormal"><span
style="font-size:10.0pt;font-family:"TimesNew Roman","serif";color:#002060"> </span><p class="MsoNormal"><span
style="font-size:10.0pt;font-family:"TimesNew Roman","serif";color:#002060">==== Recovery file on Node2</span><p
class="MsoNormal"><spanstyle="font-size:10.0pt;font-family:"Times New Roman","serif";color:#002060">cat
recovery.conf</span><pclass="MsoNormal"><span style="font-size:10.0pt;font-family:"Times New
Roman","serif";color:#002060">standby_mode= 'on'</span><p class="MsoNormal"><span
style="font-size:10.0pt;font-family:"TimesNew Roman","serif";color:#002060">primary_conninfo = 'dbname=apimgtdb
host=10.10.145.111port=5432'</span><p class="MsoNormal"><span style="font-size:10.0pt;font-family:"Times New
Roman","serif";color:#002060">recovery_target_name= 'bdr_6158050998150972399'</span><p class="MsoNormal"><span
style="font-size:10.0pt;font-family:"TimesNew Roman","serif";color:#002060">recovery_target_inclusive = true</span><p
class="MsoNormal"><spanstyle="font-size:10.0pt;font-family:"Times New Roman","serif";color:#002060"> </span><p
class="MsoNormal"><spanstyle="font-size:10.0pt;font-family:"Times New Roman","serif";color:#002060"> </span><p
class="MsoNormal"><spanstyle="font-size:10.0pt;font-family:"Times New Roman","serif";color:#002060">====== Data from
Node2log file</span><p class="MsoNormal"><span style="font-size:10.0pt;font-family:"Times New
Roman","serif";color:#002060"><2015-06-08 10:08:45.957 PDT >LOG:  entering standby mode</span><p
class="MsoNormal"><spanstyle="font-size:10.0pt;font-family:"Times New Roman","serif";color:#002060">< 2015-06-08
10:08:45.958PDT >LOG:  starting up replication identifier with ckpt at 9/F9000028</span><p class="MsoNormal"><span
style="font-size:10.0pt;font-family:"TimesNew Roman","serif";color:#002060">< 2015-06-08 10:08:45.965 PDT >LOG: 
redostarts at 9/F9000028</span><p class="MsoNormal"><span style="font-size:10.0pt;font-family:"Times New
Roman","serif";color:#002060"><2015-06-08 10:08:45.969 PDT >LOG:  consistent recovery state reached at
9/F90000F0</span><pclass="MsoNormal"><span style="font-size:10.0pt;font-family:"Times New
Roman","serif";color:#002060"><2015-06-08 10:08:45.970 PDT >LOG:  database system is ready to accept read only
connections</span><pclass="MsoNormal"><span style="font-size:10.0pt;font-family:"Times New
Roman","serif";color:#002060"><2015-06-08 10:08:45.980 PDT >LOG:  started streaming WAL from primary at
9/FA000000on timeline 1</span><p class="MsoNormal"><span style="font-size:10.0pt;font-family:"Times New
Roman","serif";color:#002060"><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</span><p class="MsoNormal"><span
style="font-size:10.0pt;font-family:"TimesNew Roman","serif";color:#002060">< 2015-06-08 10:08:46.180 PDT >LOG: 
recoveryhas paused</span><p class="MsoNormal"><span style="font-size:10.0pt;font-family:"Times New
Roman","serif";color:#002060"><2015-06-08 10:08:46.180 PDT >HINT:  Execute pg_xlog_replay_resume() to
continue.</span><pclass="MsoNormal"><span style="font-size:10.0pt;font-family:"Times New
Roman","serif";color:#002060"><2015-06-08 10:08:46.236 PDT >ERROR:  cannot execute DELETE in a read-only
transaction</span><pclass="MsoNormal"><span style="font-size:10.0pt;font-family:"Times New
Roman","serif";color:#002060"><2015-06-08 10:08:46.236 PDT >STATEMENT:  DELETE FROM pg_catalog.pg_shseclabel
WHEREprovider = 'bdr';</span><p class="MsoNormal"><span style="font-size:10.0pt;font-family:"Times New
Roman","serif";color:#002060"><2015-06-08 10:08:46.251 PDT >LOG:  received smart shutdown request</span><p
class="MsoNormal"><spanstyle="font-size:10.0pt;font-family:"Times New Roman","serif";color:#002060">< 2015-06-08
10:08:46.253PDT >FATAL:  terminating walreceiver process due to administrator command</span><p
class="MsoNormal"><spanstyle="font-size:10.0pt;font-family:"Times New Roman","serif";color:#002060">< 2015-06-08
10:08:46.255PDT >LOG:  shutting down</span><p class="MsoNormal"><span style="font-size:10.0pt;font-family:"Times New
Roman","serif";color:#002060"><2015-06-08 10:08:46.317 PDT >LOG:  database system is shut down</span><p
class="MsoNormal"><spanstyle="font-size:10.0pt;font-family:"Times New Roman","serif";color:#002060"> </span><p
class="MsoNormal"><spanstyle="font-size:10.0pt;font-family:"Times New Roman","serif";color:#002060">Thanks for your
help!</span><tableborder="0" cellpadding="0" cellspacing="0" class="MsoNormalTable"><tbody><tr><td colspan="2"
style="padding:0in0in 0in 0in" valign="top"></td></tr><tr style="height:12.0pt"><td rowspan="2"
style="width:33.75pt;padding:0in0in 0in 0in;height:12.0pt" valign="top" width="45"></td><td
style="width:280.5pt;padding:0in0in 0in 0in;height:12.0pt" valign="top" width="374"></td></tr><tr><td
style="padding:0in0in 0in 0in" valign="top"><p class="MsoNormal" style="margin-bottom:5.25pt"><b><span
style="font-size:10.0pt;font-family:"TimesNew Roman","serif";color:#00B0F0">Regards,</span></b><p class="MsoNormal"
style="margin-bottom:5.25pt"><b><spanstyle="font-size:10.0pt;font-family:"Times New
Roman","serif";color:#00B0F0">ravi</span></b><b><spanstyle="font-size:7.5pt;font-family:"Times New
Roman","serif";color:#00B0F0;text-transform:uppercase"></span></b></td></tr></tbody></table><pclass="MsoNormal"><span
style="color:#002060"> </span><p
class="MsoNormal"> </div><p>________________________________________________________________________<br/> The preceding
e-mailmessage (including any attachments) contains<br /> information that may be confidential, be protected by the<br
/>attorney-client or other applicable privileges, or constitute non-public<br /> information. It is intended to be read
onlyby the individual or entity<br /> to whom it is addressed or by their designee. If you are not an intended<br />
recipientof this message, please notify the sender by replying to this<br /> message and then delete it from your
system.You are on notice that<br /> further use, dissemination, distribution, or reproduction of this<br /> message is
strictlyprohibited and may be unlawful.