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

Dejan Muhamedagic dejanmm at fastmail.fm
Tue Dec 11 01:50:07 MST 2007


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



More information about the Linux-HA-Dev mailing list