<div class="moz-text-plain" style="font-family: -moz-fixed; font-size: 16px;" lang="ja"><pre>$B$*@$OC$K$J$j$^$9!#>.@t$H?=$7$^$9!#(B<br><br>$B8=:_0J2<$N9=@.$G1?MQ$7$F$$$^$9!#(B<br>CentOS release 5.2 (Final)<br>httpd-2.2.10-1<br>tomcat5-5.5.23<br>pgpool-II-2.1-15<br>
postgresql-8.3.6<br>$B0lBf$NJ*M}%5!<%P$G(Bpostgres$B$r%]!<%H$rJQ$($F(B2$B$D5/F0$7!">iD92=$7$F$$$^$9!#(B<br>$B"(%]!<%H(B5433($B%^%9%?(B)$B!"(B5434($B%9%l!<%V(B)$B!#(B<br>$B0lBf$G!"(B2$B$D$N(Bpostgres$B$rF0:n$5$;$F$$$kM}M3$H$7$F$O!">iD92=$K$h$jBQ>c32@-(B<br>$B$r9b$a$k$?$a$G$9!#(B<br><br>$B@hF|!"%^%9%?B&$,(Bpgpool$B$+$i@Z$jN%$5$l$^$7$?!#(B<br>$B%^%9%?B&$,@Z$jN%$5$l$?860x$rDI$C$F$$$^$9$,!"(BDB$B$NIT@09g$,860x$J$N$+(BDB$B$+$i(B<br>
$B$N1~Ez$,$J$+$C$?$N$+!"@Z$jJ,$1$,=PMh$F$$$J$$>uBV$G$9!#(B<br><br>$B%^%9%?B&$,@Z$jN%$5$l$?;~$N(Bpgpool$B$N%m%0$O0J2<$K$J$j$^$9!#(B<br>-------------------------------------------------------------------------------------<br>pgpool: 2011-04-07 04:02:16 LOG: pid 9939: connection received:<br>
host=localhost.localdomain port=37825<br>pgpool: 2011-04-07 04:02:16 LOG: pid 9939: statement: set<br>client_encoding to 'LATIN1'<br>pgpool: 2011-04-07 04:02:16 LOG: pid 9939: statement: SELECT forw_addr<br>FROM aliases WHERE alias='root'<br>
pgpool: 2011-04-07 04:02:16 LOG: pid 9939: statement: SELECT forw_addr<br>FROM aliases WHERE alias='owner-root'<br>pgpool: 2011-04-07 04:02:17 LOG: pid 10879: notice_backend_error: 0 fail<br>over request from pid 10879<br>
pgpool: 2011-04-07 04:02:17 LOG: pid 18594: starting degeneration.<br>shutdown host localhost(5433)<br>pgpool: 2011-04-07 04:02:17 LOG: pid 18594: failover_handler: set new<br>master node: 1<br>pgpool: 2011-04-07 04:02:17 LOG: pid 18594: failover done. shutdown host<br>
localhost(5433)<br>-------------------------------------------------------------------------------------<br><br>$B$=$N:]$N(Bpostgresql$B$N%m%0$O0J2<$NDL$j$G$9!#(B<br>$B%^%9%?(B<br>-------------------------------------------------------------------------------------<br>
04:02:16 postgres[10723]: [3-1] LOG: unexpected EOF within message<br>length word<br>04:02:17 postgres[29102]: [8-1] FATAL: terminating connection due to<br>administrator command<br>04:02:17 postgres[13997]: [11-1] LOG: unexpected EOF on client connection<br>
04:02:17 postgres[28330]: [6-1] LOG: unexpected EOF on client connection<br>04:02:17 postgres[10196]: [2-1] LOG: unexpected EOF on client connection<br>04:02:17 postgres[10717]: [2-1] LOG: unexpected EOF on client connection<br>
04:02:17 postgres[10270]: [2-1] LOG: unexpected EOF on client connection<br>04:02:17 postgres[10265]: [2-1] LOG: unexpected EOF on client connect<br>-------------------------------------------------------------------------------------<br>
<br>$B%9%l!<%V(B<br>-------------------------------------------------------------------------------------<br>04:02:16 postgres2[10724]: [3-1] LOG: unexpected EOF within message<br>length word<br>04:02:17 postgres2[28331]: [3-1] LOG: unexpected EOF on client connection<br>
04:02:17 postgres2[13996]: [9-1] LOG: unexpected EOF on client connection<br>04:02:17 postgres2[10718]: [2-1] LOG: unexpected EOF on client connection<br>04:02:17 postgres2[29103]: [7-1] LOG: unexpected EOF on client connection<br>
04:02:17 postgres2[10197]: [2-1] LOG: unexpected EOF on client connection<br>04:02:17 postgres2[10271]: [2-1] LOG: unexpected EOF on client connection<br>04:02:17 postgres2[10266]: [2-1] LOG: unexpected EOF on client connection<br>
-------------------------------------------------------------------------------------<br><br>pgpool$B$N@_Dj%U%!%$%k(B<br>-------------------------------------------------------------------------------------<br>listen_addresses = '*'<br>
port = 9999<br>pcp_port = 9898<br>socket_dir = '/tmp'<br>pcp_socket_dir = '/tmp'<br>backend_socket_dir = '/tmp'<br>pcp_timeout = 10<br>num_init_children = 220<br>child_life_time = 300<br>child_max_connections = 440<br>
client_idle_limit = 0<br>authentication_timeout = 60<br>logdir = '/var/log/pgpool'<br>replication_mode = true<br>replication_timeout = 5000<br>load_balance_mode = true<br>replication_stop_on_mismatch = false<br>replicate_select = false<br>
print_timestamp = true<br>master_slave_mode = false<br>connection_cache = true<br>health_check_timeout = 20<br>health_check_period = 1<br>health_check_user = 'postgres'<br>failback_command = ''<br>insert_lock = false<br>
ignore_leading_white_space = true<br>log_statement = true<br>log_connections = true<br>log_hostname = true<br>parallel_mode = false<br>enable_query_cache = false<br>pgpool2_hostname = 'uname -n$B$N7k2L$HF1MM$N$b$N(B'<br>backend_hostname0 = 'localhost'<br>
backend_port0 = 5433<br>backend_weight0 = 1<br>backend_data_directory0 = '/var/lib/pgsql/data'<br>backend_hostname1 = 'localhost'<br>backend_port1 = 5434<br>backend_weight1 = 1<br>backend_data_directory1 = '/var/lib/pgsql/data2'<br>
enable_pool_hba = true<br>-------------------------------------------------------------------------------------<br><br>$B!Z<ALd![(B<br>1.04:02:16$B$K<B9T$5$l$?(BSELECT$BJ8$,@Z$jN%$5$l$?$-$C$+$1$H$$$&G'<1$G@5$7$$$G(B<br>$B$7$g$&$+!#(B<br><br>2.$B@Z$jN%$5$l$?M}M3$,!"(BDB$B$NIT@09g$J$N$+!"(BDB$B$+$i$N1~Ez$,$J$+$C$?$N$+!"H=JL(B<br>
$B$9$kJ}K!$O$"$j$^$9$G$7$g$&$+!#(B<br><br>$B0J>e!"$*<j?t$G$9$,$42sEz$r$*4j$$CW$7$^$9!#(B<br><br><br></pre></div>