[Pgpool-general] replication_mode=true but 'show_pool_status' reports replic
Tatsuo Ishii
ishii at sraoss.co.jp
Sun Jan 28 09:56:37 UTC 2007
In master_slave mode, pgpool does not replicate anything. In this case
the replication should be handled by other software, such as
Slony-I. If your intention is just replicating everything, you should
set :
replication_mode = true
master_slave_mode = false
in your pgpool.conf.
--
Tatsuo Ishii
SRA OSS, Inc. Japan
> pgpool version 3.1.1(kawakawa),
>
> Sorry to rush, but we are using this in company and we have deadline coming
> soon. We need help or we can not use pgpool.
>
> Thank you,
>
> - Mark
>
> >From: Yoshiyuki Asaba <y-asaba at sraoss.co.jp>
> >To: pgpool-general at pgfoundry.org
> >Subject: Re: [Pgpool-general] replication_mode=true but 'show_pool_status'
> >reports replication_enabled=0??
> >Date: Fri, 26 Jan 2007 16:42:11 +0900 (JST)
> >
> >Hi,
> >
> >From: "Mark F" <enigma_3319 at hotmail.com>
> >Subject: [Pgpool-general] replication_mode=true but 'show_pool_status'
> >reports replication_enabled=0??
> >Date: Wed, 24 Jan 2007 03:29:25 -0600
> >
> > > I'm new to pgpool. I have everything working. Both servers are up and
> >I've
> > > been able to use pgpool in master_slave mode. When I try replication
> >mode
> > > it does not seem to work. There is no error output reporting anything
> >is
> > > wrong. I perform a 'create table dummy(pokemon int not null default 9)'
> >to
> > > pgpool. The backend_host_name receives the new table. The secondary
> >does
> > > not.
> > >
> > > Any help would be appreciated. There is no output to say something is
> > > wrong. I have '-d' enabled and still pgpool does not report any errors.
> >
> >Which version do you use?
> >
> >--
> >Yoshiyuki Asaba
> >y-asaba at sraoss.co.jp
> >_______________________________________________
> >Pgpool-general mailing list
> >Pgpool-general at pgfoundry.org
> >http://pgfoundry.org/mailman/listinfo/pgpool-general
>
> _________________________________________________________________
> Valentine痴 Day -- Shop for gifts that spell L-O-V-E at MSN Shopping
> http://shopping.msn.com/content/shp/?ctId=8323,ptnrid=37,ptnrdata=24095&tcode=wlmtagline
>
More information about the Pgpool-general
mailing list