[Pacemaker] pgsql agent won't start postgresql

[Andreas Kurz]

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.zhen at nextissuemedia.com
> <mailto: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"

... 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 at 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


-------------- next part --------------
A non-text attachment was scrubbed...
Name: signature.asc
Type: application/pgp-signature
Size: 222 bytes
Desc: OpenPGP digital signature
URL: <http://lists.clusterlabs.org/pipermail/pacemaker/attachments/20120201/b8a3b993/attachment-0002.sig>