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

[Tatsuo Ishii]

Are you sure that postgresql on 10.0.3.12 is running?  If so, execute
"show pool_status" command and check value "backend_status1". That
will show the status of backend1 from the point of view of pgpool.  If
pgpool thinks backend1 is not healthy, it does not send create
database command to backend1.
--
Tatsuo Ishii
SRA OSS, Inc. Japan
English: http://www.sraoss.co.jp/index_en.php
Japanese: http://www.sraoss.co.jp

> 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.
> I have the following configuration for the pgpool.conf.
> 
> 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.
> 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.
> 
> Could you please help indicate why. Thanks!
> 
> backend_hostname0 = '10.0.3.12'
>                                    # 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
> balancinn
> 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
> DISALLOW_TO_FAILOVER
> backend_hostname1 = '10.0.3.186'
> 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,
> Barco