Know the problem now! The backed no. Can not be configured as 0. After I changed one with 1and another with 2, it works already with both ends having database created correctly .<div><br></div><div><br></div><div>Barco<span></span><br>
<div><br>On Monday, May 28, 2012, Tatsuo Ishii wrote:<br><blockquote class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex">> psql -h 10.0.3.3 -p 9999 -U postgres<br>
> postgres>show pool_status;<br>
<br>
Nothing showed? Looks like you have basic problem with pgpool<br>
installation. You might want to look into pgpool log.<br>
--<br>
Tatsuo Ishii<br>
SRA OSS, Inc. Japan<br>
English: <a href="http://www.sraoss.co.jp/index_en.php" target="_blank">http://www.sraoss.co.jp/index_en.php</a><br>
Japanese: <a href="http://www.sraoss.co.jp" target="_blank">http://www.sraoss.co.jp</a><br>
<br>
> On Sun, May 27, 2012 at 5:48 PM, Tatsuo Ishii <<a>ishii@postgresql.org</a>> wrote:<br>
><br>
>> How was "show pool_status" output then?<br>
>> --<br>
>> Tatsuo Ishii<br>
>> SRA OSS, Inc. Japan<br>
>> English: <a href="http://www.sraoss.co.jp/index_en.php" target="_blank">http://www.sraoss.co.jp/index_en.php</a><br>
>> Japanese: <a href="http://www.sraoss.co.jp" target="_blank">http://www.sraoss.co.jp</a><br>
>><br>
>> > Yes, it's sure that postgresql on two backends running, because I can use<br>
>> > psql connect to them!<br>
>> ><br>
>> > On Sun, May 27, 2012 at 4:42 PM, Tatsuo Ishii <<a>ishii@postgresql.org</a>><br>
>> wrote:<br>
>> ><br>
>> >> Are you sure that postgresql on 10.0.3.12 is running? If so, execute<br>
>> >> "show pool_status" command and check value "backend_status1". That<br>
>> >> will show the status of backend1 from the point of view of pgpool. If<br>
>> >> pgpool thinks backend1 is not healthy, it does not send create<br>
>> >> database command to backend1.<br>
>> >> --<br>
>> >> Tatsuo Ishii<br>
>> >> SRA OSS, Inc. Japan<br>
>> >> English: <a href="http://www.sraoss.co.jp/index_en.php" target="_blank">http://www.sraoss.co.jp/index_en.php</a><br>
>> >> Japanese: <a href="http://www.sraoss.co.jp" target="_blank">http://www.sraoss.co.jp</a><br>
>> >><br>
>> >> > I install pgpool-II 3.1.3 from source on machine 10.0.3.3 and I have<br>
>> to<br>
>> >> > postgres backends (postgresql 9.1) at 10.0.3.12 and 10.0.3.186<br>
>> >> respectively.<br>
>> >> > I have the following configuration for the pgpool.conf.<br>
>> >> ><br>
>> >> > After I use "psql -h 10.0.3.3 -p 9999 -U postgres" to connect pgpool<br>
>> from<br>
>> >> > another machine I can connect correctly and I do "create database<br>
>> xxxxx<br>
>> >> > with xxxx" successfully.<br>
>> >> > But if I check the backend DB server, only one server<br>
>> (backend_hostname0)<br>
>> >> > has the databse xxxx create correctly, there is no this database at<br>
>> >> > backend_hostname1.<br>
>> >> ><br>
>> >> > Could you please help indicate why. Thanks!<br>
>> >> ><br>
>> >> > backend_hostname0 = '10.0.3.12'<br>
>> >> > # Host name or IP address to<br>
>> connect<br>
>> >> to<br>
>> >> > for bb<br>
>> >> > ackend 0<br>
>> >> > backend_port0 = 5432<br>
>> >> > # Port number for backend 0<br>
>> >> > backend_weight0 = 1<br>
>> >> > # Weight for backend 0 (only in<br>
>> load<br>
>> >> > balancinn<br>
>> >> > g mode)<br>
>> >> > backend_data_directory0 = '/etc/postgresql/9.1/main'<br>
>> >> > # Data directory for backend 0<br>
>> >> > backend_flag0 = 'ALLOW_TO_FAILOVER'<br>
>> >> > # Controls various backend behavior<br>
>> >> > # ALLOW_TO_FAILOVER or<br>
>> >> > DISALLOW_TO_FAILOVER<br>
>> >> > backend_hostname1 = '10.0.3.186'<br>
>> >> > backend_port1 = 5432<br>
>> >> > backend_weight1 = 1<br>
>> >> > backend_data_directory1 = '/etc/postgresql/9.1/main'<br>
>> >> > backend_flag1 = 'ALLOW_TO_FAILOVER'<br></blockquote></div></div><br><br>-- <br><br>Best regards,<br>Barco<br><br>