Hi, Serge. Thank you for a revision. I test it.
I do not have the authority of the commitment. I tell a mailing list about a result. Regards, Hideo Yamauchi. --- Serge Dubrouski <[EMAIL PROTECTED]> wrote: > Attached is a patch for pgsql RA that should fix these and some other > problems. Please test them and commit to an appropriate repository. > > On Jan 31, 2008 8:32 AM, Serge Dubrouski <[EMAIL PROTECTED]> wrote: > > Actually you are talking about "status" operation, not "monitor". You > > can monitor any particular instance of PostgreSQL by supplying > > particular port and host parameters to which that RA will connect to > > check the health status of the instance. > > > > I had to remove the code that worked with a PID file to make RA able > > to run "status" function as a non root and non pgdba user, PID file is > > usually sits in a directory which isn't readable for everybody. > > > > But adding one more parameter which would control a pattern for pgrep > > sound like a good idea and I'll add it. > > > > 2008/1/30 HIDEO YAMAUCHI <[EMAIL PROTECTED]>: > > > > > Hi, All > > > > > > I think that there is a problem for the monitoring of the current pgsql > > > resource. > > > It is two problems. > > > > > > 1)A monitor cannot judge that plural PostgreSQL instance works in the > > > same node. > > > > > > This is because monitor judge it by an instance name of PostgreSQL with > > > pgrep. > > > > > > For example, this problem occurs when consist of plural nodes. > > > When all PostgreSQL is started in one last node, it occurs. > > > > > > 2)pgrep of the monitor cannot judge PostgreSQL instance done swap out. > > > > > > This may not occur very much. > > > But, it cannot be said that it never occurs. > > > > > > I watched the manual. > > > /proc/pid/cmdline seems to disappear in swap out. > > > But, pgrep seems to watch cmdline. > > > > > > For the solution of the problem, a change of pgsql is necessary. > > > > > > For example, > > > 1) Use the PID file as before. > > > 2) But use pgrep when monitor can not see a PID file. > > > 3) Furthermore, I appoint the required parameter that pgsql can judge in > > > pgrep. > > > -> By a parameter, the monitor can judge the plural instance. > > > > > > The situation of the worst swap out may not evade even this example. > > > But, I think that this example is improved than present pgsql. > > > > > > Please show me an opinion of all of you. > > > > > > Best Regards, > > > Hideo Yamauchi. > > > > > > _______________________________________________ > > > Linux-HA mailing list > > > [email protected] > > > http://lists.linux-ha.org/mailman/listinfo/linux-ha > > > See also: http://linux-ha.org/ReportingProblems > > > > > > > > > > > -- > > Serge Dubrouski. > > > > > > -- > Serge Dubrouski. > > _______________________________________________ > Linux-HA mailing list > [email protected] > http://lists.linux-ha.org/mailman/listinfo/linux-ha > See also: http://linux-ha.org/ReportingProblems _______________________________________________ Linux-HA mailing list [email protected] http://lists.linux-ha.org/mailman/listinfo/linux-ha See also: http://linux-ha.org/ReportingProblems
