[Pgpool-general] replication_mode=true but 'show_pool_status' reports replic

Tatsuo Ishii ishii at sraoss.co.jp
Sun Jan 28 10:08:10 UTC 2007


My wild guess is pgpool goes into the degeneration mode. Can you show
me pgpool log with -d on?
--
Tatsuo Ishii
SRA OSS, Inc. Japan

> I already have this setting in my pgpool.conf file.  When I perform a 
> 'show_pool_status' on pgpool it says replication_enabled=0.  There is no 
> debug explaining why replication mode did not start; even though I told it 
> to replicate.
> 
> 
> >From: Tatsuo Ishii <ishii at sraoss.co.jp>
> >To: enigma_3319 at hotmail.com
> >CC: y-asaba at sraoss.co.jp, pgpool-general at pgfoundry.org
> >Subject: Re: [Pgpool-general] replication_mode=true but 'show_pool_status' 
> >reports replic
> >Date: Sun, 28 Jan 2007 18:56:37 +0900 (JST)
> >
> >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
> > >
> 
> _________________________________________________________________
> Get in the mood for Valentine's Day. View photos, recipes and more on your 
> Live.com page. 
> http://www.live.com/?addTemplate=ValentinesDay&ocid=T001MSN30A0701
> 


More information about the Pgpool-general mailing list