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

[Tatsuo Ishii]

How was "show pool_status" output then?
--
Tatsuo Ishii
SRA OSS, Inc. Japan
English: http://www.sraoss.co.jp/index_en.php
Japanese: http://www.sraoss.co.jp

> Yes, it's sure that postgresql on two backends running, because I can use
> psql connect to them!
> 
> On Sun, May 27, 2012 at 4:42 PM, Tatsuo Ishii <ishii at postgresql.org> wrote:
> 
>> 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
>>
> 
> 
> 
> -- 
> 
> Best regards,
> Barco