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 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 p

Re: [HACKERS] hot_standby = on

2010-06-08 Thread Andrew Dunstan
Tom Lane wrote: Andrew Dunstan 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 impro

Re: [HACKERS] hot_standby = on

2010-06-08 Thread Tom Lane
Andrew Dunstan 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 reliability of you

Re: [HACKERS] hot_standby = on

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

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 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

Re: [HACKERS] hot_standby = on

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

[HACKERS] hot_standby = on

2010-06-03 Thread Andrew Dunstan
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. cheers andrew -- Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org) To make change