[pgpool-general: 512] [pgpoo-II general] Why use pgpool-II in replication mode can not createdb simultaneously to two backend postgres server

Barco You barco.you at bestv-intl.com
Sun May 27 16:31:25 JST 2012

Dear Forks,

I install pgpool-II 3.1.3 from source on machine and I have to
postgres backends (postgresql 9.1) at and respectively.
I have the following configuration for the pgpool.conf.

After I use "psql -h -p 9999 -U postgres" to connect pgpool from
another machine I can connect correctly and I do "create database xxxxx
with xxxx" successfully.
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

Could you please help indicate why. Thanks!

backend_hostname0 = ''
                                   # Host name or IP address to connect to
for bb
ackend 0
backend_port0 = 5432
                                   # Port number for backend 0
backend_weight0 = 1
                                   # Weight for backend 0 (only in load
g mode)
backend_data_directory0 = '/etc/postgresql/9.1/main'
                                   # Data directory for backend 0
backend_flag0 = 'ALLOW_TO_FAILOVER'
                                   # Controls various backend behavior
                                   # ALLOW_TO_FAILOVER or
backend_hostname1 = ''
backend_port1 = 5432
backend_weight1 = 1
backend_data_directory1 = '/etc/postgresql/9.1/main'
backend_flag1 = 'ALLOW_TO_FAILOVER'


replication_mode = on
load_balance_mode = on
                                   # Activate load balancing mode
                                   # (change requires restart)
ignore_leading_white_space = on


Best regards,
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://www.sraoss.jp/pipermail/pgpool-general/attachments/20120527/76917f73/attachment.html>

More information about the pgpool-general mailing list