Re: [HACKERS] hot_standby = on

2010-06-09 Thread Simon Riggs
On Tue, 2010-06-08 at 17:24 -0400, Tom Lane wrote: Andrew Dunstan and...@dunslane.net writes: 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. The main reason to turn it off is to disable a whole

Re: [HACKERS] hot_standby = on

2010-06-08 Thread Robert Haas
On Thu, Jun 3, 2010 at 11:15 PM, Andrew Dunstan andrew.duns...@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

Re: [HACKERS] hot_standby = on

2010-06-08 Thread Andrew Dunstan
Robert Haas wrote: On Thu, Jun 3, 2010 at 11:15 PM, Andrew Dunstan andrew.duns...@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

Re: [HACKERS] hot_standby = on

2010-06-08 Thread Robert Haas
On Tue, Jun 8, 2010 at 4:54 PM, Andrew Dunstan and...@dunslane.net wrote: Robert Haas wrote: On Thu, Jun 3, 2010 at 11:15 PM, Andrew Dunstan andrew.duns...@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

Re: [HACKERS] hot_standby = on

2010-06-08 Thread Tom Lane
Andrew Dunstan and...@dunslane.net writes: 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. The main reason to turn it off is to disable a whole lot of very poorly tested code, and thereby improve the

Re: [HACKERS] hot_standby = on

2010-06-08 Thread Andrew Dunstan
Tom Lane wrote: Andrew Dunstan and...@dunslane.net writes: 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. The main reason to turn it off is to disable a whole lot of very poorly tested