Re: Postgresql BDR Replication Setup Issue
От | Ravi Tammineni |
---|---|
Тема | Re: Postgresql BDR Replication Setup Issue |
Дата | |
Msg-id | 7de0dad1a8014e1285db3a4ac1e03825@prscexmbx02.aligntech.com обсуждение исходный текст |
Список | 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.
В списке pgadmin-support по дате отправления: