My answers are inline..

On 7/25/2011 8:30 PM, Serge Dubrouski wrote:
> Hello -
>
> AFAIK pgpool OCF RA isn't shipped with Pacemaker so you need to work 
> with whoever created it and find out why it doesn't start. There are 
> some other strange things about your cluster though:
>
> 1. It looks like it's one node cluster. Is it true? What's the point 
> in a such strange configuration.
> 2. If you have just one instance of PostgreSQL why do you need pgpool 
> then?
I just wanted to start test with one node cluster. lf it works fine then 
I will add more nodes.
> 3. You probably should start with building a cluster that runs pgsql, 
> mae sure that it works fine and then add pgpool if needed. There is a 
> pretty good HOW-TO document describing how to build pgsql cluster 
> using Pacemaker:
>
> http://www.clusterlabs.org/wiki/PostgresHowto
> http://www.clusterlabs.org/wiki/DRBD_PgSQL_HowTo
Both these articles talk about DRBD, I want to use pgpool instead. Would 
you like to suggest any preference ?
>
> On Sun, Jul 24, 2011 at 7:26 AM, Sanjay Rao 
> <[email protected] <mailto:[email protected]>> 
> wrote:
>
>     Hi
>
>     I am working on pgpool /postgresql/linux first time. All these
>     three are
>     new to me.
>
>     pgpool-HA is is an OCF compliant agent script for pgpool and pgpool-II
>     on the ha-cluster software Heartbeat 2.x
>
>     I am running pgpool-HA using pacemaker-corosync.
>     I am having following error in my setup. Does any body have any idea
>     about the warning highlighted in logs ? Any type of help would be
>     appreciated a lot...
>
>     Jul 24 18:40:41 squarepant attrd: [3772]: info: attrd_perform_update:
>     Sent update 1010: probe_complete=true
>     Jul 24 18:40:41 squarepant cib: [3770]: WARN: cib_process_request:
>     Operation complete: op cib_modify for section status
>     (origin=local/attrd/1010, version=0.52.352): The object/attribute does
>     not exist (rc=-22)
>     Jul 24 18:40:41 squarepant attrd: [3772]: WARN: attrd_cib_callback:
>     Update 1010 for probe_complete=true failed: The object/attribute does
>     not exist
>     Jul 24 18:40:41 squarepant pgpool[7635]: INFO: pgpoolRA: request stop,
>     but not running.
>     Jul 24 18:40:41 squarepant crmd: [3896]: info: process_lrm_event: LRM
>     operation pgpool_stop_0 (call=339, rc=0, cib-update=472,
>     confirmed=true) ok
>     Jul 24 18:40:41 squarepant crmd: [3896]: info: match_graph_event:
>     Action
>     pgpool_stop_0 (2) confirmed on squarepant (rc=0)
>     Jul 24 18:40:41 squarepant crmd: [3896]: info: te_rsc_command:
>     Initiating action 12: start pgpool_start_0 on squarepant (local)
>     Jul 24 18:40:41 squarepant crmd: [3896]: info: do_lrm_rsc_op:
>     Performing
>     key=12:112:0:6d68acf3-ab99-409f-b686-8533e4b24ca0 op=pgpool_start_0 )
>     Jul 24 18:40:41 squarepant lrmd: [3771]: info: rsc:pgpool:340: start
>     Jul 24 18:40:41 squarepant crmd: [3896]: info: te_pseudo_action:
>     Pseudo
>     action 5 fired and confirmed
>
>
>     ouput of crm_mon command is
>
>
>     ============
>     Last updated: Sun Jul 24 18:15:59 2011
>     Stack: Heartbeat
>     Current DC: squarepant (85f4f3d6-650e-4620-8cbb-edb1bc9d389c) -
>     partition with quorum
>     Version: 1.1.5-1.fc14-01e86afaaa6d4a8c4836f68df80ababd6ca3902f
>     1 Nodes configured, unknown expected votes
>     3 Resources configured.
>     ============
>
>     Online: [ squarepant ]
>
>      DBIP   (ocf::heartbeat:IPaddr2):       Started squarepant
>      postgresql     (ocf::heartbeat:pgsql): Started squarepant
>      pgpool (ocf::heartbeat:pgpool):        Started squarepant FAILED
>
>     Failed actions:
>         pgpool_monitor_30000 (node=squarepant, call=1874, rc=7,
>     status=complete): not running
>
>
>     Thanks & Regards
>     Sanjay
>
>
>     _______________________________________________
>     Linux-HA mailing list
>     [email protected] <mailto:[email protected]>
>     http://lists.linux-ha.org/mailman/listinfo/linux-ha
>     See also: http://linux-ha.org/ReportingProblems
>
>
>
>
> -- 
> Serge Dubrouski.


_______________________________________________
Linux-HA mailing list
[email protected]
http://lists.linux-ha.org/mailman/listinfo/linux-ha
See also: http://linux-ha.org/ReportingProblems

Reply via email to