[pgpool-general-jp: 923] フェイルオーバーの設定が出来ない

小泉 美加 koizumi.mika @ futuregiken.co.jp
2011年 4月 20日 (水) 15:48:15 JST


$B=i$a$^$7$F>. @ t$H?=$7$^$9!#(B

$B8=:_!"(BPostgreSQL9$B$r;HMQ$7$F%[%C%H%9%?%s%P%$!&%9%H%j!<%_%s%0%l%W%j%1!<%7(B
$B%g%s$r<B8=$7$F$$$^$9!#(B
$B>e5-$K(Bpgpool-ii$B$r;HMQ$7$F%U%'%$%k%*!<%P!<$r<B8=$7$?$$$H9M$($F$$$^$9$,!"(B
$B$&$^$/$$$+$J$$>uBV$G$9!#(B

------------------------------------------------------------
$B!Z4D6-![(B
$B%W%i%$%^%j%5!<%P!'(B192.168.10.216
$B%9%?%s%P%$%5!<%P!'(B192.168.10.217

pgpool-ii$B$r%9%?%s%P%$%5!<%P$K%$%s%9%H!<%k$7$F$$$^$9!#(B

$B!Z3F<o @ _Dj%U%!%$%k$N>uBV![(B
$B!&(Bpcp.conf

$B0J2<$N$_ @ _Dj(B
postgres:e8a48653851e28c69d0506508fb27fc5

$B!&(Bpgpool.conf

listen_addresses = '*'
port = 9999

pcp_port = 9898

pid_file_name = '/usr/local/pgsql/data/pgpool.pid'

replication_mode = false
master_slave_mode = false


#$B%W%i%$%^%j%5!<%P @ _Dj(B
backend_hostname0 = '192.168.10.216'
backend_port0 = 5432
backend_weight0 = 1
backend_data_directory0 = '/usr/local/pgsql/archive'
#$B%9%?%s%P%$%5!<%P @ _Dj(B
backend_hostname1 = '192.168.10.217'
backend_port1 = 5432
backend_weight1 = 1
backend_data_directory1 = '/usr/local/pgsql/archive'

health_check_period = 20
health_check_timeout = 20
health_check_user = 'postgres'

failover_command = '/usr/local/pgsql/bin/failover_stream.sh %d %H /tmp/
trigger'

$B!&(Bpool_hba.conf

host    all         all         192.168.10.0/24       trust


$B!Z(Bpgpool$B5/F0;~%m%0![(B
pid 21449: pgpool-II successfully started. version 3.0.3 (umiyameboshi)

$B!Z>uBV![(B
$B-!(Bpsql -p 9999$B$G%"%/%;%9$r9T$&$H%9%?%s%P%$%5!<%P$X%"%/%;%9$5$l$F$$$k!#(B
$B!!$J$<%W%i%$%^%j%5!<%P$X%"%/%;%9$r9T$o$J$$$N$G$7$g$&$+!#(B

$B-"%W%i%$%^%j%5!<%P$rDd;_!#%H%j%,!<%U%!%$%k$,:n @ .$5$l$F$$$J$$(B

------------------------------------------------------------
$B8=:_>e5-$N#2E@$K4X$7$F$J$<$=$N$h$&$JF0:n$r9T$C$F$7$^$&$N$+$,J,$+$i$J$$>u(B
$BBV$G$9!#(B
$B$I$J$?$+$465<xD:$1$J$$$G$7$g$&$+!#(B


pgpool-general-jp メーリングリストの案内