Dear Forks,<br><br>I install pgpool-II 3.1.3 from source on machine 10.0.3.3 and I have to postgres backends (postgresql 9.1) at 10.0.3.12 and 10.0.3.186 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 from another machine I can connect correctly and I do "create database xxxxx with xxxx" successfully.<br>But if I check the backend DB server, only one server (backend_hostname0) has the databse xxxx create correctly, there is no this database at 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 connect to 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 load 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 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><br>.....<br><br>replication_mode = on<br>....<br>load_balance_mode = on<br>
# Activate load balancing mode<br> # (change requires restart)<br>ignore_leading_white_space = on<br><br clear="all"><br>-- <br><br>Best regards,<br>Barco<br>
<br>