[Pgpool-general] Clarifying interaction between master/slave mode and automated failover [SumsaultRT #3219]

[Tatsuo Ishii]

Thanks!

I have committed your patches.
--
Tatsuo Ishii
SRA OSS, Inc. Japan

> On Tue, May 30, 2006 at 10:48:32PM +0900, Tatsuo Ishii wrote:
> > Thanks. Could you send the diff again using diff -c command?
> 
> Attached.
> 
> 	Mark
> 
> > --
> > Tatsuo Ishii
> > SRA OSS, Inc. Japan
> > 
> > > On Wed, May 24, 2006 at 04:40:23PM -0400, Mark Stosberg wrote:
> > > > 
> > > >  2. What's the behavior when failing over from master to slave? Does it 
> > > >     still continue to send only SELECTs to the slave, or does it began
> > > > 	to treat it as a master? 
> > > 
> > > I think I found the answer to this here:
> > > http://pgfoundry.org/pipermail/pgpool-general/2005-January/000010.html
> > > 
> > > Below is a patch to the documentation to improve in this regard. 
> > > 
> > > 	Mark
> > > 
> > > mark at sap$ diff README.orig README
> > > 523c523
> > > <    For maintenance purpose, scheduled switching or degenration is
> > > ---
> > > >    For maintenance purpose, scheduled switching or degeneration is
> > > 526c526
> > > <    $ pgpool [-f config_file] [-s {m[aster]|s[econdary]] switch
> > > ---
> > > >    To send both reads and writes only to the secondary:
> > > 528,529c528
> > > <    If [-m {s[mart]|f[ast]|i[mmediate]}] part is omitted, master goes
> > > <    down. To stop secondary try:
> > > ---
> > > >    $ pgpool [-f config_file] switch
> > > 531c530
> > > <    $ pgpool [-f config_file] -s s[econdary] switch
> > > ---
> > > >    To switch to using only the master:
> > > 533c532
> > > <    Note that "s[econdary]" measn "s" or "secondary".
> > > ---
> > > >    $ pgpool [-f config_file] -s secondary switch
> > > _______________________________________________
> > > Pgpool-general mailing list
> > > Pgpool-general at pgfoundry.org
> > > http://pgfoundry.org/mailman/listinfo/pgpool-general
> > > 
> --
>  . . . . . . . . . . . . . . . . . . . . . . . . . . . 
>    Mark Stosberg            Principal Developer  
>    mark at summersault.com     Summersault, LLC     
>    765-939-9301 ext 202     database driven websites
>  . . . . . http://www.summersault.com/ . . . . . . . .