Re: Controlling hot standby

On Fri, 2009-01-23 at 11:28 -0300, Alvaro Herrera wrote:
> Simon Riggs wrote:
> > 
> > On Fri, 2009-01-23 at 12:58 +0200, Devrim GÜNDÜZ wrote:
> > > On Fri, 2009-01-23 at 10:05 +0000, Simon Riggs wrote:
> > > > I'll add it now, default = on.
> > > 
> > > Did you mean "off"?
> > 
> > No, do you?
> 
> Depends on the setting :-)  It is "hot_standby=off" by default, right?
> I think having a double negative "disable_hot_standby=off" would be
> awkward.

It is on by default. Why would you want it "off" by default? 

We want people to use the feature and turn it off only if they need to
for some reason.

It is only used during archive recovery, so it is already "off" if
you're using some other kind of replication.

-- Simon Riggs           www.2ndQuadrant.comPostgreSQL Training, Services and Support