[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