Re: hot_standby = on - Mailing list pgsql-hackers

From Andrew Dunstan
Subject Re: hot_standby = on
Date
Msg-id 4C0EAE22.5010903@dunslane.net
Whole thread Raw
In response to Re: hot_standby = on  (Robert Haas <robertmhaas@gmail.com>)
Responses Re: hot_standby = on  (Robert Haas <robertmhaas@gmail.com>)
Re: hot_standby = on  (Tom Lane <tgl@sss.pgh.pa.us>)
List pgsql-hackers
Robert Haas wrote:
> On Thu, Jun 3, 2010 at 11:15 PM, Andrew Dunstan
> <andrew.dunstan@pgexperts.com> wrote:
>   
>> The docs don't seem to contain any discussion I could find on why one might
>> not want hot_standby on. Maybe it's just too obvious to most people, but
>> this seems to be a bit lacking in the docs.
>>     
>
> Well, if you don't want your slave to process queries, then you
> wouldn't turn it on, presumably.
>
>   

Well, yes. But then to stop that you could just lock users out using 
pg_hba.conf, no? It just doesn't seem to be buying all that much to me. 
It's not a big deal, I was just curious. There are all these new knobs 
to play with ...

cheers

andrew



pgsql-hackers by date:

Previous
From: Robert Haas
Date:
Subject: Re: primary/secondary/master/slave/standby
Next
From: Simon Riggs
Date:
Subject: Re: Idea for getting rid of VACUUM FREEZE on cold pages