Rex -<br><br>To get quicker answer you should use this list.<br><br>Anyway it's hard to tell what is the problem without log files and crm_mon output.<br><br>Does you drbd works all right? Are you able to start postgres outside of Pacemaker? <br>
<br><div class="gmail_quote">On Tue, Jan 24, 2012 at 1:50 PM, Rex Zhen <span dir="ltr"><<a href="mailto:rex.zhen@nextissuemedia.com">rex.zhen@nextissuemedia.com</a>></span> wrote:<br><blockquote class="gmail_quote" style="margin:0pt 0pt 0pt 0.8ex;border-left:1px solid rgb(204,204,204);padding-left:1ex">
<div style="font-size:14px;font-family:Calibri,sans-serif;word-wrap:break-word"><div>Hi Sir,</div><div><br></div><div>The postgreSQL won't start through the resource agent.</div><div><br></div><div>Here is my configure file</div>
<div><br></div><div><div>node db-3</div><div>node db-4</div><div>primitive db_drbd ocf:linbit:drbd \</div><div><span style="white-space:pre-wrap"> </span>params drbd_resource="drbd_pgsql" \</div><div><span style="white-space:pre-wrap"> </span>op monitor interval="60"</div>
<div>primitive db_fs ocf:heartbeat:Filesystem \</div><div><span style="white-space:pre-wrap"> </span>params device="/dev/drbd0" directory="/var/lib/postgresql" fstype="ext4" \</div><div><span style="white-space:pre-wrap"> </span>meta target-role="Started"</div>
<div>primitive db_ip ocf:heartbeat:IPaddr2 \</div><div><span style="white-space:pre-wrap"> </span>params ip="192.168.100.63" \</div><div><span style="white-space:pre-wrap"> </span>op monitor interval="10s" \</div>
<div><span style="white-space:pre-wrap"> </span>meta target-role="Started"</div><div>primitive db_stonith stonith:external/ssh \</div><div><span style="white-space:pre-wrap"> </span>params hostlist="db-3 db-4"</div>
<div>primitive pgsql ocf:heartbeat:pgsql \</div><div><span style="white-space:pre-wrap"> </span>params pgctl="/usr/lib/postgresql/9.1/bin/pg_ctl" psql="/usr/lib/postgresql/9.1/bin/psql" pgdata="/var/lib/postgresql/9.1/main" pgdba="postgres" start_opt="" \</div>
<div><span style="white-space:pre-wrap"> </span>op monitor interval="10s" timeout="20s" depth="0" \</div><div><span style="white-space:pre-wrap"> </span>meta target-role="Started"</div>
<div>group postgres db_fs db_ip</div><div>ms db_ms db_drbd \</div><div><span style="white-space:pre-wrap"> </span>meta master-max="1" master-node-max="1" clone-max="2" clone-node-max="1" notify="true"</div>
<div>clone fencing db_stonith \</div><div><span style="white-space:pre-wrap"> </span>meta target-role="Started"</div><div>colocation fs-with-maskter inf: db_fs db_ms:Master</div><div>colocation ip-with-maskter inf: db_ip db_ms:Master</div>
<div>colocation pg-with-fs inf: pgsql db_fs</div><div>order drbd-after-fs inf: db_ms:promote postgres:start</div><div>property $id="cib-bootstrap-options" \</div><div><span style="white-space:pre-wrap"> </span>dc-version="1.0.9-unknown" \</div>
<div><span style="white-space:pre-wrap"> </span>cluster-infrastructure="openais" \</div><div><span style="white-space:pre-wrap"> </span>expected-quorum-votes="2" \</div><div><span style="white-space:pre-wrap"> </span>default-resource-stickiness="100" \</div>
<div><span style="white-space:pre-wrap"> </span>no-quorum-policy="ignore" </div></div><span class="HOEnZb"><font color="#888888"><div><br></div><div><br></div><div>Rex Zhen</div></font></span></div>
</blockquote></div><br><br clear="all"><br>-- <br>Serge Dubrouski.<br>