pgsql ra (WAS: Re: [Linux-ha-dev] ids ra)

[Andrew Beekhof]

On Dec 11, 2007, at 9:50 AM, Dejan Muhamedagic wrote:

> Hi Serge,
>
> On Mon, Dec 10, 2007 at 08:52:53PM -0700, Serge Dubrouski wrote:
>> This is a patch that I believe make pgsql RA compatible with those  
>> rules.
>>
>> On Dec 10, 2007 3:51 PM, Serge Dubrouski <sergeyfd at gmail.com> wrote:
>>> Ok, I think I got where the problem is. Before calling "monitor" or
>>> "stop" it should check if the resource is stopped and if it is it
>>> should return 0, not 1 as it does now when called not by root.  
>>> Right?
>
> Not exactly. In case a prerequisite is missing (such as, say, the
> pgctl program), the monitor and stop operations should not report
> error but that the resource is stopped.

or fall back to some other method (such as grepping the process table)

> The reason for all this
> is that the RA should succeed on stop and return stopped (rc 7)
> in case the software is not installed. That's common in case the
> software is installed on a shared storage, but not on a clustered
> filesystem. Or in case some nodes are never meant to run some
> resource. See for example the apache or db2 or oracle resource
> agents.
>
> Thanks,
>
> Dejan
>
>>>
>>> On Dec 10, 2007 2:54 PM, Lars Marowsky-Bree <lmb at suse.de> wrote:
>>>> On 2007-12-10T12:38:34, Serge Dubrouski <sergeyfd at gmail.com> wrote:
>>>>
>>>>> Both operations include calling pg_ctl or psql. validate_all  
>>>>> checks
>>>>> that they are set in the right way.
>>>>
>>>> /usr/sbin/ocf-tester can very quickly show whether everything  
>>>> works as
>>>> it should ;-)
>>>>
>>>> I can see an option to ocf-tester: --live <rsc_id>
>>>>
>>>> Which would pull the resource data from the CIB (making sure it's
>>>> stopped & unmanaged) and would try to run it where the user  
>>>> invoked the
>>>> command.
>>>>
>>>> And then the GUI could call out to that script via a button.
>>>>
>>>> Wouldn't that be nice.
>>>>
>>>>
>>>> Regards,
>>>>    Lars
>>>>
>>>> --
>>>> Teamlead Kernel, SuSE Labs, Research and Development
>>>> SUSE LINUX Products GmbH, GF: Markus Rex, HRB 16746 (AG N?rnberg)
>>>> "Experience is the name everyone gives to their mistakes." --  
>>>> Oscar Wilde
>>>>
>>>>
>>>> _______________________________________________________
>>>> Linux-HA-Dev: Linux-HA-Dev at lists.linux-ha.org
>>>> http://lists.linux-ha.org/mailman/listinfo/linux-ha-dev
>>>> Home Page: http://linux-ha.org/
>>>>
>>>
>>>
>>>
>>> --
>>> Serge Dubrouski.
>>>
>>
>>
>>
>> -- 
>> Serge Dubrouski.
>
>
>> _______________________________________________________
>> Linux-HA-Dev: Linux-HA-Dev at lists.linux-ha.org
>> http://lists.linux-ha.org/mailman/listinfo/linux-ha-dev
>> Home Page: http://linux-ha.org/
>
> _______________________________________________________
> Linux-HA-Dev: Linux-HA-Dev at lists.linux-ha.org
> http://lists.linux-ha.org/mailman/listinfo/linux-ha-dev
> Home Page: http://linux-ha.org/