[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