[pgpool-general: 526] 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
Mon May 28 17:19:36 JST 2012


Know the problem now! The backed no. Can not be configured as 0. After I
changed one with 1and another with 2, it works already with both ends
having database created correctly .


Barco

On Monday, May 28, 2012, Tatsuo Ishii wrote:

> > psql -h 10.0.3.3 -p 9999 -U postgres
> > postgres>show pool_status;
>
> Nothing showed? Looks like you have basic problem with pgpool
> installation. You might want to look into pgpool log.
> --
> Tatsuo Ishii
> SRA OSS, Inc. Japan
> English: http://www.sraoss.co.jp/index_en.php
> Japanese: http://www.sraoss.co.jp
>
> > 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'
>


-- 

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


More information about the pgpool-general mailing list