Yes, it&#39;s sure that postgresql on two backends running, because I can use psql connect to them!<br><br><div class="gmail_quote">On Sun, May 27, 2012 at 4:42 PM, Tatsuo Ishii <span dir="ltr">&lt;<a href="mailto:ishii@postgresql.org" target="_blank">ishii@postgresql.org</a>&gt;</span> wrote:<br>
<blockquote class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex">Are you sure that postgresql on 10.0.3.12 is running?  If so, execute<br>
&quot;show pool_status&quot; command and check value &quot;backend_status1&quot;. 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>
<div class="HOEnZb"><div class="h5"><br>
&gt; I install pgpool-II 3.1.3 from source on machine 10.0.3.3 and I have to<br>
&gt; postgres backends (postgresql 9.1) at 10.0.3.12 and 10.0.3.186 respectively.<br>
&gt; I have the following configuration for the pgpool.conf.<br>
&gt;<br>
&gt; After I use &quot;psql -h 10.0.3.3 -p 9999 -U postgres&quot; to connect pgpool from<br>
&gt; another machine I can connect correctly and I do &quot;create database xxxxx<br>
&gt; with xxxx&quot; successfully.<br>
&gt; But if I check the backend DB server, only one server (backend_hostname0)<br>
&gt; has the databse xxxx create correctly, there is no this database at<br>
&gt; backend_hostname1.<br>
&gt;<br>
&gt; Could you please help indicate why. Thanks!<br>
&gt;<br>
&gt; backend_hostname0 = &#39;10.0.3.12&#39;<br>
&gt;                                    # Host name or IP address to connect to<br>
&gt; for bb<br>
&gt; ackend 0<br>
&gt; backend_port0 = 5432<br>
&gt;                                    # Port number for backend 0<br>
&gt; backend_weight0 = 1<br>
&gt;                                    # Weight for backend 0 (only in load<br>
&gt; balancinn<br>
&gt; g mode)<br>
&gt; backend_data_directory0 = &#39;/etc/postgresql/9.1/main&#39;<br>
&gt;                                    # Data directory for backend 0<br>
&gt; backend_flag0 = &#39;ALLOW_TO_FAILOVER&#39;<br>
&gt;                                    # Controls various backend behavior<br>
&gt;                                    # ALLOW_TO_FAILOVER or<br>
&gt; DISALLOW_TO_FAILOVER<br>
&gt; backend_hostname1 = &#39;10.0.3.186&#39;<br>
&gt; backend_port1 = 5432<br>
&gt; backend_weight1 = 1<br>
&gt; backend_data_directory1 = &#39;/etc/postgresql/9.1/main&#39;<br>
&gt; backend_flag1 = &#39;ALLOW_TO_FAILOVER&#39;<br>
&gt;<br>
&gt; .....<br>
&gt;<br>
&gt; replication_mode = on<br>
&gt; ....<br>
&gt; load_balance_mode = on<br>
&gt;                                    # Activate load balancing mode<br>
&gt;                                    # (change requires restart)<br>
&gt; ignore_leading_white_space = on<br>
&gt;<br>
&gt;<br>
&gt; --<br>
&gt;<br>
&gt; Best regards,<br>
&gt; Barco<br>
</div></div></blockquote></div><br><br clear="all"><br>-- <br><br>Best regards,<br>Barco<br><br>