[Pacemaker] pgsql agent won't start postgresql

[Serge Dubrouski]

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.zhen at 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"
> 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 \
> 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
> 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
> property $id="cib-bootstrap-options" \
> dc-version="1.0.9-unknown" \
> cluster-infrastructure="openais" \
> expected-quorum-votes="2" \
> default-resource-stickiness="100" \
> no-quorum-policy="ignore"
>
>
> Rex Zhen
>



-- 
Serge Dubrouski.
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.clusterlabs.org/pipermail/pacemaker/attachments/20120124/47cb6f67/attachment-0002.html>