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

[Barco You]

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