<html>
<head>
<style><!--
.hmmessage P
{
margin:0px;
padding:0px
}
body.hmmessage
{
font-size: 10pt;
font-family:$B%a%$%j%*(B
}
--></style>
</head>
<body class='hmmessage'>
$B@P0fMM(B<br><br>$B5\:j$G$9!#JV?.$"$j$,$H$&$4$6$$$^$9!#(B<br>$B:G?7(Bfix$BEy$N>pJs$b3NG'$7$F$_$^$9!#(B<br><br>> Date: Mon, 16 Nov 2009 22:29:38 +0900<br>> To: pgpool-general-jp@sraoss.jp; miyazaki_1999@hotmail.com<br>> Subject: Re: [pgpool-general-jp: 635] $BF1:-$N<+F05/F0%9%/%j%W%H$O@5$7$$$N$G$7$g$&$+!)(B<br>> From: ishii@sraoss.co.jp<br>> <br>> $B@P0f$G$9!#(B<br>> <br>> > CentOS 5.3$B$K(B yum install $B$G(B $B%P!<%8%g%s(B2.2.4<br>> > $B!!(Bpgpool-II-2.2.4-1.rhel5 $B!&!&!&(B pgpool-II version 2.2.4 (urukiboshi)<br>> > $B$r%$%s%9%H!<%k$7$FMxMQ$5$;$FD:$$$F$$$^$9$,!"(B<br>> > $B$3$N:]%$%s%9%H!<%k$5$l$k<+F05/F0%9%/%j%W%H(B"/etc/init.d/pgpool"$B$N$^$^$G$O(B<br>> > $B%m%0$,=PNO$5$l$J$$$H$$$&$3$H$OL5$$$G$7$g$&$+!)(B<br>> <br>> $B$O$$!"$=$NDL$j$G$9!#(B<br>> <br>> > "/etc/sysconfig/pgpool"$B$K(B<br>> > $B!!(BOPTS="-n"<br>> > $B$r@_Dj$7!"%G!<%b%s%b!<%I$G5/F0$7$J$$$h$&$K$7$F3NG'$7$?$N$G$9$,!"(B<br>> > $B<+F05/F0%9%/%j%W%H(B"/etc/init.d/pgpool"$B$KDj5A$5$l$F$$$k%m%0%U%!%$%k(B<br>> > $B!!(BPGPOOLLOG=/var/log/pgpool.log<br>> > $B$K$OA4$/%m%0$,=PNO$5$l$^$;$s!#(B<br>> > <br>> > $B$=$3$G!"<+F05/F0%9%/%j%W%H(B"/etc/init.d/pgpool"$B$N(B88$B9TL\$NFbMF$r3NG'$7$?$H$3$m!"(B<br>> > $B!!(B $PGPOOLDAEMON -f $PGPOOLCONF $OPTS &>> "$PGPOOLLOG" 2>&1 < /dev/null<br>> > $B$H=q$+$l$F$*$j!"(B"&"$B$G%P%C%/%0%i%&%s%I5/F0$7$?8e$+$i(B ">>" $B$G(B<br>> > $B%m%0%U%!%$%k$K%j%@%$%l%/%H$7$F$$$^$9!#$3$l$,860x$J$N$@$m$&$H9M$(!"(B<br>> > $B0J2<$N$h$&$K=$@5$7$F5/F0$7$?$H$3$m%m%0%U%!%$%k$K=PNO$5$l$k$h$&$K$J$j$^$7$?!#(B<br>> > $B!!(B# $PGPOOLDAEMON -f $PGPOOLCONF $OPTS &>> "$PGPOOLLOG" 2>&1 < /dev/null<br>> > $B!!(B $PGPOOLDAEMON -f $PGPOOLCONF $OPTS>> "$PGPOOLLOG" 2>&1 < /dev/null &<br>> > <br>> > $B$3$N=$@5$,@5$7$$$N$+$I$&$+3N?.$,;}$F$:!"$b$7$+$7$?$i!"(B<br>> > $B%$%s%9%H!<%k$5$l$k<+F05/F0%9%/%j%W%H(B"/etc/init.d/pgpool"$B$O@5$7$/!"(B<br>> > $B;d$N(Bpgpool$B$N@_DjJ}K!$,8m$C$F$$$k$N$,860x$J$N$+$b$7$l$J$$$H9M$(!"(B<br>> > $B3'MM$O$I$N$h$&$K@_Dj$5$l$F$$$i$C$7$c$k$N$+!"$465<x4j$$$?$/59$7$/$*4j$$CW$7$^$9!#(B<br>> <br>> $B4pK\E*$K>e5-$G$"$C$F$$$k$H;W$$$^$9!#(B<br>> <br>> $B:G?7(Bfix$B$K4X$7$F$O!"(BCVS HEAD$B$+$i%=!<%9$r%@%&%s%m!<%I$7$F3NG'$$$?$@$/$N(B<br>> $B$,NI$$$H;W$$$^$9$,!"$H$j$"$($:(Bpgpool.init$B$O$3$s$J46$8$K$J$C$F$^$9!#(B<br>> <br>> #!/bin/sh<br>> # pgpool This is the init script for starting up pgpool-II<br>> #<br>> # chkconfig: - 64 36<br>> # description: Starts and stops the pgpool daemon<br>> # processname: pgpool<br>> # pidfile:        /var/run/pgpool.pid<br>> #<br>> # v1.0.0 Devrim GUNDUZ <devrim@CommandPrompt.com><br>> # - Initial version of Red Hat / Fedora init script<br>> #<br>> # v2.2 Devrim GUNDUZ <devrim@CommandPrompt.com><br>> # - New and improved version which has some fixes.<br>> #<br>> # v2.2.5 Devrim GUNDUZ <devrim@CommandPrompt.com><br>> # - Fix logging.<br>> <br>> if [ -r /etc/sysconfig/pgpool ]; then<br>> . /etc/sysconfig/pgpool<br>> fi<br>> <br>> # Source function library.<br>> INITD=/etc/rc.d/init.d<br>> . $INITD/functions<br>> <br>> # Get function listing for cross-distribution logic.<br>> TYPESET=`typeset -f|grep "declare"`<br>> <br>> # Get config.<br>> . /etc/sysconfig/network<br>> <br>> # Check that networking is up.<br>> # We need it for pgpool<br>> [ "${NETWORKING}" = "no" ] && exit 0<br>> <br>> # Find the name of the script<br>> NAME=`basename $0`<br>> if [ ${NAME:0:1} = "S" -o ${NAME:0:1} = "K" ]<br>> then<br>>         NAME=${NAME:3}<br>> fi<br>> <br>> # For SELinux we need to use 'runuser' not 'su'<br>> if [ -x /sbin/runuser ]<br>> then<br>> SU=runuser<br>> else<br>> SU=su<br>> fi<br>> <br>> # Set defaults for configuration variables<br>> PGPOOLENGINE=/usr/bin<br>> PGPOOLDAEMON=$PGPOOLENGINE/pgpool<br>> PGPOOLCONF=/etc/pgpool-II/pgpool.conf<br>> PGPOOLPIDDIR=/var/run/pgpool<br>> PGPOOLLOG=/var/log/pgpool.log<br>> <br>> test -x $PGPOOLDAEMON || exit 5<br>> <br>> # Check whether the config file exists or not<br>> if [ ! -r $PGPOOLCONF ]<br>> then<br>>         echo "$PGPOOLCONF not found"<br>>         RETVAL=1<br>>         failure        <br>>         exit<br>> fi<br>> <br>> # Create the log file if it does not exist<br>> if [ ! -x $PGPOOLLOG ]<br>> then<br>>         touch $PGPOOLLOG<br>>         chown postgres: $PGPOOLLOG<br>> fi<br>> <br>> if [ ! -d $PGPOOLPIDDIR ]<br>> then<br>>         mkdir $PGPOOLPIDDIR<br>>         chown postgres: $PGPOOLPIDDIR<br>> fi<br>> <br>> script_result=0<br>> <br>> start(){<br>>         pid=`pidof -s "$PGPOOLDAEMON"`<br>>         if [ $pid ]<br>>         then<br>>                 echo "pgpool is already running with pid $pid"<br>>                 failure "$PGPOQL_START"<br>>                 echo<br>>                 script_result=1<br>>                 exit 1<br>>         fi<br>> <br>>         PGPOOL_START=$"Starting ${NAME} service: "<br>> <br>>         echo -n "$PGPOOL_START"<br>> <br>>         $SU -l postgres -c "$PGPOOLDAEMON -f $PGPOOLCONF $OPTS & " >> "$PGPOOLLOG" 2>&1 < /dev/null<br>>         sleep 2<br>> <br>>         pid=`pidof -s "$PGPOOLDAEMON"`<br>>         if [ $pid ] <br>>         then<br>>                 success "$PGPOOL_START"<br>>                 touch /var/lock/subsys/${NAME}<br>>                 echo<br>>         else<br>>                 failure "$PGPOQL_START"<br>>                 echo<br>>                 script_result=1<br>>         fi<br>> }<br>> <br>> stop(){<br>>         echo -n $"Stopping ${NAME} service: "<br>> if [ $UID -ne 0 ]; then<br>> RETVAL=1<br>> failure<br>> else<br>>                 killproc /usr/bin/pgpool<br>> #                $PGPOOLDAEMON stop & >> "$PGPOOLLOG" 2>&1 < /dev/null<br>> RETVAL=$?<br>> [ $RETVAL -eq 0 ] && rm -f /var/lock/subsys/${NAME}<br>> fi;<br>> echo<br>> return $RETVAL<br>> }<br>> <br>> switch() {<br>>         echo -n $"Sending switchover request to $NAME "<br>>         $PGPOOLDAEMON -f $PGPOOLCONF switch >> "$PGPOOLLOG" 2>&1 < /dev/null<br>>         RETVAL=$?<br>>         echo<br>>         if [ $RETVAL -eq 0 ] <br>>         then<br>>                 echo_success<br>>         else<br>>                 echo_failure<br>>         fi<br>>         echo<br>> }<br>> <br>> restart(){<br>> stop<br>> start<br>> }<br>> <br>> reload(){<br>>         echo -n $"Reloading ${NAME}: "<br>> <br>>         if [ -n "`pidfileofproc $PGPOOLDAEMON`" ] ; then<br>>                 killproc $PGPOOLDAEMON -HUP<br>>         else<br>>                 failure $"Reloading ${NAME}"<br>>         fi<br>>         RETVAL=$?<br>>         echo<br>> }<br>> <br>> condrestart(){<br>>         [ -e /var/lock/subsys/${NAME} ] && restart<br>> }<br>> <br>> condstop(){<br>>         [ -e /var/lock/subsys/${NAME} ] && stop<br>> }<br>> <br>> # See how we were called.<br>> case "$1" in<br>> start)<br>> start<br>> ;;<br>> stop)<br>> stop<br>> ;;<br>> switch)<br>> switch<br>> ;;<br>> status)<br>> status pgpool<br>> script_result=$?<br>> ;;<br>> restart)<br>> restart<br>> ;;<br>> reload|force-reload)<br>> reload<br>> ;;<br>> condrestart)<br>> condrestart<br>> ;;<br>> condstop)<br>> condstop<br>> ;;<br>> *)<br>> echo $"Usage: $0 {start|stop|switch|status|restart|condrestart|condstop|reload|force-reload}"<br>> exit 1<br>> esac<br>> <br>> exit $script_result<br>> <br>                                            <br /><hr />$B%a!<%k0l3g%A%'%C%/!*B>$NL5NA%a!<%k$b%W%m%P%$%@!<%a!<%k$b!#(B <a href='http://clk.atdmt.com/GBL/go/165609199/direct/01/' target='_new'>$B%a!<%k$r0l3g%A%'%C%/$7$?$$J}$O!"$3$A$i!#(B</a></body>
</html>