<div dir="ltr"><br><div class="gmail_extra"><div class="gmail_quote">On 13 June 2013 10:51, Takatoshi MATSUO <span dir="ltr"><<a href="mailto:matsuo.tak@gmail.com" target="_blank">matsuo.tak@gmail.com</a>></span> wrote:<br>
<blockquote class="gmail_quote" style="margin:0px 0px 0px 0.8ex;border-left-width:1px;border-left-color:rgb(204,204,204);border-left-style:solid;padding-left:1ex">Hi<br>
<div class="im"><br>
> As far the logs go, anything specific I should be grepping for ?<br>
<br>
</div>Please grep pgsql<br>
<br>
> node_list="hanode01 hanode02" \<br>
<br>
You need to add all node names whose replication is controlled by Pacemaker.<br>
<div class="im"><br>
> pcs resource master msPostgresql pgsql master-max=1 master-node-max=1 clone-max=10 clone-node-max=10 notify=true<br>
<br>
</div>Why do you use clone-node-max=10 ?<br>
Please use clone-node-max=1<br>
<div class="im"><br>
> pcs constraint order start master-group then promote msPostgresql symmetrical=false score=2<br>
<br>
</div>You should start master-group after promote msPostgresql.<br>
<br>
I am not good at pcs.<br>
Please see <a href="https://github.com/t-matsuo/resource-agents/wiki/Resource-Agent-for-PostgreSQL-9.1-streaming-replication" target="_blank">https://github.com/t-matsuo/resource-agents/wiki/Resource-Agent-for-PostgreSQL-9.1-streaming-replication</a><br>
<br></blockquote><div style>Thank you. That change however didnt seem to have helped. </div><div style>I installed crmsh, and here's the config dump in crm format: </div><div style><br></div><div style><br></div><div>
node hanode01</div><div>node hanode02</div><div>node hanode03</div><div><br></div><div>primitive pgsql ocf:heartbeat:pgsql \</div><div> params pgctl="/usr/pgsql-9.2/bin/pg_ctl" psql="/usr/pgsql-9.2/bin/psql" pgdata="/var/lib/pgsql/9.2/data/" restore_command="cp /var/lib/pgsql/9.2/data/pg_archive/\%f \%p" start_opt="-p 5432" rep_mode="async" node_list="hanode01 hanode02" master_ip="10.0.1.100" stop_escalate="0" repuser="replicator" monitor_password="lemon31ee7" monitor_user="monitor" \</div>
<div> op start interval="0s" role="Master" timeout="60s" on-fail="block"</div><div> </div><div>primitive vip-master ocf:heartbeat:IPaddr2 \</div><div> params ip="10.0.0.100" nic="eth1:0" cidr_netmask="24" migration-threshold="0" \</div>
<div> op start interval="0s" timeout="60s" on-fail="block"</div><div> </div><div>primitive vip-rep ocf:heartbeat:IPaddr2 \</div><div> params ip="10.0.1.100" nic="eth2:0" cidr_netmask="24" migration-threshold="0" \</div>
<div> op start interval="0s" timeout="60s" on-fail="block"</div><div> </div><div>group master-group vip-master vip-rep</div><div><br></div><div>ms msPostgresql pgsql \</div><div>
meta master-max="1" master-node-max="1" clone-max="10" clone-node-max="1" notify="true" target-role="Master"</div><div><br></div><div>location location-master-group-hanode01-5000 master-group 5000: hanode01</div>
<div><br></div><div>order order-master-group-msPostgresql-3 3: master-group:stop msPostgresql:demote symmetrical=false</div><div>order order-msPostgresql-master-group-2 2: msPostgresql:promote master-group:start symmetrical=false</div>
<div><br></div><div>property $id="cib-bootstrap-options" \</div><div> expected-quorum-votes="3" \</div><div> stonith-enabled="false" \</div><div> no-quorum-policy="ignore"</div>
<div><br></div><div>rsc_defaults $id="rsc_defaults-options" \</div><div> resource-stickiness="INFINITY" \</div><div> migration-threshold="1"</div><div style><br></div><div style>
<br></div><div style>Attached are the logs from Today (I was changing the configuration, starting stoping, removing and readding things in the mean time). </div><div style><br></div><div style>this is what I got after: grep pgsql /var/log/messages</div>
<div style> </div></div></div></div>