[pgpool-general: 518] Re: [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 19:21:13 JST 2012


I think it's not the problem of postgresql servers, because I change the
position of these two servers on backend_hostname0 and backend_hostname1,
only the server at position 0 having the database created.

On Sun, May 27, 2012 at 6:18 PM, Barco You <barco.you at bestv-intl.com> wrote:

> psql -h 10.0.3.3 -p 9999 -U postgres
> postgres>show pool_status;
>
>
>
>
> On Sun, May 27, 2012 at 5:48 PM, Tatsuo Ishii <ishii at postgresql.org>wrote:
>
>> 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
>>
>
>
>
> --
>
> Best regards,
> Barco
>
>


-- 

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


More information about the pgpool-general mailing list