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

[Barco You]

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
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://www.sraoss.jp/pipermail/pgpool-general/attachments/20120527/412ec4fd/attachment.html>