[pgsql-jp: 39361] =?iso-2022-jp?B?cGdwb29sGyRCLTYhISROISEbKEJjdXJyZW50X2JhY2tlbmRfaG9zdA==?=

[AOKI KAZUYUKI]

$B ＠ DLZ$H?=$7$^$9!"$h$m$7$/$*4j$$$$$?$7$^$9!#(B
$B$5$C$=$/$G$9$,!"(Bpgpool$B-6$K$D$$$F<ALd$G$9!#(B

$BFCDj$N%F!<%V%k$G%G!<%??t$NIT0lCW$,5/$-$F$$$k$3$H$,$o$+$C$F$$$k>uBV$G$9!#(B
$B%j%+%P%j!<$r7W2hCf$J$N$G$9$,!"$I$A$i$,8=:_$N%^%9%?(BDB$B$J$N$+$o$+$i$:$K$*$j$^$9!#(B 



show pool_status; $B$N7k2L$O0J2<$NDL$j$G$9!#(B

current_backend_host $B$H$$$&9`L\$,8+$D$+$i$J$$$N$G$9$,!"(B
pgpool$B-6!!$N%9%F!<%?%9$G$OI=<($5$l$J$$$N$G$7$g$&$+!)(B

$B%5!<%P!<$O(B3$BBf9=@.$G(B1$BBf$,(Bpgpool$B!!;D$j(B2$BBf$G(BPostgreSQL$B$rF0$+$7$F$$$^$9!#(B
pg_pool$B!!1[$7$K8+$?>l9g$O!!(B192.168.***.150$B!!$r8+$F$$$k$h$&$J$N$G$9$,!"(B
192.168.***.160$B!!$NJ}$,%G!<%??t$,B?$$$N$G!"G:$s$G$7$^$C$F$$$^$9!#(B

$B$^$?!"(Bbackend status0  ==$B!!(B2$B!!$H$$$&$N$,$I$&$$$&>uBV$J$N$+!)(B
$B%0%0%C$?$N$G$9$,!"2r$r8+$D$1$i$l$:$K$*$j$^$9!#(B

 replication_mode             | 1
 replication_enabled          | 1

$B$H$$$&$3$H$J$N$G!"%l%W%j%1!<%7%g%s$O9T$o$l$F$$$k$HH=CG$7$F$$$^$9$,!"(B
$B8=:_$N>uBV$G=EBg$JLdBj$,5/$-$F$$$J$$$N$+!"H=CG$7$+$M$F$$$^$9!#(B

             item             |                        value
------------------------------+-------------------------
 listen_addresses             | *
 port                         | 5432
 socket_dir                   | /tmp
 num_init_children            | 32
 child_life_time              | 300
 connection_life_time         | 0
 client_idle_limit            | 0
 child_max_connections        | 0
 max_pool                     | 4
 authentication_timeout       | 60
 logdir                       | /tmp
 backend_socket_dir           | /tmp
 replication_mode             | 1
 replication_timeout          | 5000
 load_balance_mode            | 0
 replication_stop_on_mismatch | 0
 replicate_select             | 0
 reset_query_list             | ABORT; RESET ALL; SET SESSION AUTHORIZATION
DEFAULT;
 print_timestamp              | 1
 master_slave_mode            | 0
 connection_cache             | 1
 health_check_timeout         | 20
 health_check_period          | 0
 health_check_user            | nobody
 failover_command             |
 failback_command             |
 insert_lock                  | 0
 ignore_leading_white_space   | 1
 replication_enabled          | 1
 master_slave_enabled         | 0
 num_reset_queries            | 3
 pcp_port                     | 9898
 pcp_socket_dir               | /tmp
 pcp_timeout                  | 10
 log_statement                | 0
 log_connections              | 0
 log_hostname                 | 0
 enable_pool_hba              | 0
 recovery_user                | nobody
 recovery_password            |
 recovery_1st_stage_command   |
.
 recovery_2nd_stage_command   |
 parallel_mode                | 0
 enable_query_cache           | 0
 pgpool2_hostname             | intra1.*****.com
 system_db_hostname           | localhost
 system_db_port               | 5432
 system_db_dbname             | pgpool
 system_db_schema             | pgpool_catalog
 system_db_user               | pgpool
 system_db_password           |
 backend_hostname0            | 192.168.***.150
 backend_port0                | 5432
 backend_weight0              | 1073741823.500000
 backend status0              | 2
 backend_hostname1            | 192.168.***.160
 backend_port1                | 5432
 backend_weight1              | 1073741823.500000
 backend status1              | 2


==========================
mode-A ($B%b!<%I!&%(!<(B)
$B!!!!!!!!!!!!!!!!!!!!!!!!@DLZ0lG7(B
==========================