<div>$BF#AR$H?=$7$^$9!#(B</div><div>$B%9%H%j!<%_%s%0%l%W%j%1!<%7%g%s$7$F$$$k(Bpostgresql$B!J(Bmaster/slave)$B$K(Bpgpool$B$r@\B3$5$;%m!<%I%P%i%s%9$5$;$k$H0J2<$N$h$&$J%(%i!<$,=PNO$5$l!"(B</div><div>$B%"%W%j%1!<%7%g%s$K$O%(%i!<$,JV$C$F$/$k>uBV$G$9!#(B</div><div><br></div><div><br></div><div>$B"#<B9T$7$?%3%^%s%I(B</div><div>$ createdb -e -p 5432 -h db -U postgres -E UTF8 -T template0 --lc-collate 'C' --lc-ctype 'ja_JP.UTF8' <database_name></div>
<div>$ psql -h db -U postgres < /tmp/schema.sql</div><div>$B"(!!(Bschema.sql$B$OCf?H$,2?$G$b%(%i!<$K$J$j$^$9(B</div><div>$B"(!!(Bcreatedb$B$H(Bpsql$B$N4V$K(Bsleep$B$r$O$5$`$H%(%i!<$,=P$J$/$J$j$^$9(B</div><div><br></div><div><br></div><div>$B"~(Bpgpool.log</div><div>2012-09-06 17:50:45 ERROR: pid 5278: pool_read_kind: kind does not match between master(53) slot[1] (45)</div>
<div>2012-09-06 17:50:45 LOG: pid 5278: pool_read_kind: error message from 1 th backend:database "<database_name>" does not exist</div><div>2012-09-06 17:50:45 ERROR: pid 5278: pool_do_auth: failed to read kind before BackendKeyData</div>
<div><br></div><div><br></div><div><br></div><div>$B%9%l!<%VB&$N(Bpostgres$B$G$O0J2<$N$h$&$J%m%0$,=PNO$5$l$F$$$^$7$?!#(B</div><div>$B"~(Bpostgresql</div><div>Sep 6 17:50:45 slave-server postgres[5468]: [2-1] [unknown] [5468]:0 ()LOG: connection received: host=localhost.localdomain port=41516</div>
<div>Sep 6 17:50:45 slave-server postgres[5468]: [3-1] <database_name> localhost.localdomain(41516) [5468]:0 (authentication)LOG: connection authorized: user=postgres database=<database_name></div><div>Sep 6 17:50:45 slave-server postgres[5468]: [4-1] <database_name> localhost.localdomain(41516) [5468]:0 (startup)FATAL: database "<database_name>" does not exist</div>
<div><br></div><div><br></div><div><br></div><div>$B"#4D6-(B</div><div> CentOS 5.x (64bit)</div><div> - pgpool-ii 3.2.0</div><div><span class="Apple-tab-span" style="white-space:pre"> </span>port = 5432</div><div><span class="Apple-tab-span" style="white-space:pre"> </span>master_slave_mode = on</div>
<div><span class="Apple-tab-span" style="white-space:pre"> </span>master_slave_sub_mode = 'stream'</div><div><span class="Apple-tab-span" style="white-space:pre"> </span>connection_cache = on</div><div><span class="Apple-tab-span" style="white-space:pre"> </span>load_balance_mode = on</div>
<div><span class="Apple-tab-span" style="white-space:pre"> </span>replication_mode = off</div><div><span class="Apple-tab-span" style="white-space:pre"> </span>replicate_select = off</div><div><br></div><div>$B!!"(!!(Bpgpool$B$N%P!<%8%g%s(B3.1.3-2/3.0.5$B$K$7$F$bF1MM$NLdBj$OH/@8$7$^$7$?(B</div>
<div><span class="Apple-tab-span" style="white-space:pre"> </span></div><div> - PostgreSQL 9.1.5</div><div>$B!!"(!!%m!<%+%k$K%^%9%?!<(B/$B%9%l!<%V$rN)$F$F%9%H%j!<%_%s%0%l%W%j%1!<%7%g%s$7$F$$$^$9(B</div><div>$B!!(Bmaster port = 5442</div><div>$B!!(Bslave port = 5443</div><div><br>
</div><div>postgres=# SHOW pool_nodes;</div><div> node_id | hostname | port | status | lb_weight | role </div><div>---------+-----------+------+--------+-----------+---------</div><div> 0 | 127.0.0.1 | 5442 | 2 | 0.500000 | primary</div>
<div> 1 | 127.0.0.1 | 5443 | 2 | 0.500000 | standby</div><div>$B!!"(!!(Blb_weight$B$r(B1/0 1/1 0/1$B$KJQ99$7$FF1MM$NLdBj$O:F8=$7$^$7$?(B</div><div>$B!!!!!!(Bnode_id 1$B$r(Bdetach$B$7$F$$$k>uBV$G$OLdBj$O:F8=$7$^$;$s$G$7$?!J8=>]$OH/@8$7$J$$!K(B</div><div><br></div><div><br></div><div>postgres=# psql -x -U postgres -h localhost -c "SELECT * FROM pg_stat_replication"</div>
<div>-[ RECORD 1 ]----+------------------------------</div><div>procpid | 18398</div><div>usesysid | 10</div><div>usename | postgres</div><div>application_name | walreceiver</div><div>client_addr | 127.0.0.1</div>
<div>client_hostname | </div><div>client_port | 59479</div><div>backend_start | 2012-09-06 17:26:15.112519+09</div><div>state | streaming</div><div>sent_location | 6/CF00ED50</div><div>write_location | 6/CF00ED50</div>
<div>flush_location | 6/CF00ED50</div><div>replay_location | 6/CF00ED50</div><div>sync_priority | 0</div><div>sync_state | async</div><div>$B!!"(!!(Bsync_state$B$r(Bsync$B$K$7$F$bF1MM$NLdBj$O:F8=$7$^$7$?(B</div><div><br></div><div><br></div>
<div>PostgreSQL$B%9%H%j!<%_%s%0%l%W%j%1!<%7%g%s$G$O(Bsync$B$G$"$C$F$b%9%l!<%VB&$X$NCY1d$,$"$kDxEY5vMF$5$l$F$$$k$H9M$($F$*$j$^$9$,!"(B</div><div>pgpool$BB&$G$O(Bmaster_slave_sub_mode = 'stream'$B$G$"$C$F$b>/$7$NCY1d$b5vMF$5$l$J$$>uBV$K$J$C$F$$$k$h$&$K8+$($^$9!#(B</div><div>delay_threshold $B$NCM$r(B0$B$b$7$/$O?t(BGB$B$r@_Dj$7$F$b2~A1$,8+$i$l$^$;$s$G$7$?!#(B</div>
<div><br></div><div>$B0J>e$N$h$&$J>u67$J$N$G$9$,!"$I$J$?$+2sHr:v$J$I$4B8CN$G$7$?$i$465<($*4j$$CW$7$^$9!#(B</div><div><br></div><div>$B$h$m$7$/$*4j$$?=$7$"$2$^$9!#(B</div><div><br></div><div>$BF#AR(B</div>