[Pgpool-general] replication_mode=true but 'show_pool_status' reports replic
Mark F
enigma_3319 at hotmail.com
Sun Jan 28 10:00:00 UTC 2007
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
> >
> > _________________________________________________________________
> > Valentines 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