Simon Riggs wrote:
On Fri, 2009-01-23 at 10:35 +0200, Heikki Linnakangas wrote:
As the patch stands, there's no way to disable hot standby. The server
always opens for read-only connections as soon as it can. That might not
be what you want.
I think we need a GUC to enable/disable hot standby. It would become
handy if the unimaginable happens and there's a bug in the hot standby
code that prevents a server from recovering.
Currently recovery processing is only active during archive recovery,
never during crash recovery, for the above reason.
Oh, ok. Is the bgwriter still launched in crash recovery, and do we
start accepting connections as soon as the replay finishes, before the
first checkpoint is finished?
I think we need a GUC to enable/disable hot standby.
I presume you mean something that will stop us keeping track of
snapshots and preventing users from connecting?
Suggestion: hot_standby = on | off (on is default)
(in recovery.conf)
Right.
Would that include starting the bgwriter during recovery? Or should be a
separate boolean? If needed, should this be in postgresql.conf or in
recovery.conf?
I don't think that's necessary.
--
Heikki Linnakangas
EnterpriseDB http://www.enterprisedb.com
--
Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-hackers