Hello, On 01/25/2012 05:08 AM, Serge Dubrouski wrote: > Rex - > > To get quicker answer you should use this list. > > Anyway it's hard to tell what is the problem without log files and > crm_mon output. > > Does you drbd works all right? Are you able to start postgres outside of > Pacemaker? > > On Tue, Jan 24, 2012 at 1:50 PM, Rex Zhen <rex.z...@nextissuemedia.com > <mailto:rex.z...@nextissuemedia.com>> wrote: > > Hi Sir, > > The postgreSQL won't start through the resource agent. > > Here is my configure file > > node db-3 > node db-4 > primitive db_drbd ocf:linbit:drbd \ > params drbd_resource="drbd_pgsql" \ > op monitor interval="60"
... use two monitors with different intervals, one for Master and one for Slave role > primitive db_fs ocf:heartbeat:Filesystem \ > params device="/dev/drbd0" directory="/var/lib/postgresql" > fstype="ext4" \ > meta target-role="Started" > primitive db_ip ocf:heartbeat:IPaddr2 \ > params ip="192.168.100.63" \ > op monitor interval="10s" \ > meta target-role="Started" > primitive db_stonith stonith:external/ssh \ ... ssh stonith? this is hopefully only a test system ... how about IPMI? > params hostlist="db-3 db-4" > primitive pgsql ocf:heartbeat:pgsql \ > 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="" \ > op monitor interval="10s" timeout="20s" depth="0" \ > meta target-role="Started" > group postgres db_fs db_ip why not putting also pgsql into this group? > ms db_ms db_drbd \ > meta master-max="1" master-node-max="1" clone-max="2" > clone-node-max="1" notify="true" > clone fencing db_stonith \ > meta target-role="Started" > colocation fs-with-maskter inf: db_fs db_ms:Master > colocation ip-with-maskter inf: db_ip db_ms:Master > colocation pg-with-fs inf: pgsql db_fs > order drbd-after-fs inf: db_ms:promote postgres:start you definitely want to define an order to start postres group before pgsql resource > property $id="cib-bootstrap-options" \ > dc-version="1.0.9-unknown" \ I can also recommend an update to 1.1.6 Regards, Andreas -- Need help with Pacemaker? http://www.hastexo.com/services/remote > cluster-infrastructure="openais" \ > expected-quorum-votes="2" \ > default-resource-stickiness="100" \ > no-quorum-policy="ignore" > > > Rex Zhen > > > > > -- > Serge Dubrouski. > > > _______________________________________________ > Pacemaker mailing list: Pacemaker@oss.clusterlabs.org > http://oss.clusterlabs.org/mailman/listinfo/pacemaker > > Project Home: http://www.clusterlabs.org > Getting started: http://www.clusterlabs.org/doc/Cluster_from_Scratch.pdf > Bugs: http://bugs.clusterlabs.org
signature.asc
Description: OpenPGP digital signature
_______________________________________________ Pacemaker mailing list: Pacemaker@oss.clusterlabs.org http://oss.clusterlabs.org/mailman/listinfo/pacemaker Project Home: http://www.clusterlabs.org Getting started: http://www.clusterlabs.org/doc/Cluster_from_Scratch.pdf Bugs: http://bugs.clusterlabs.org
