Re: HS/SR and smart shutdown - Mailing list pgsql-hackers

From Simon Riggs
Subject Re: HS/SR and smart shutdown
Date
Msg-id 1264805948.13782.87.camel@ebony
Whole thread Raw
In response to Re: HS/SR and smart shutdown  (Heikki Linnakangas <heikki.linnakangas@enterprisedb.com>)
Responses Re: HS/SR and smart shutdown  (Josh Berkus <josh@agliodbs.com>)
List pgsql-hackers
On Thu, 2010-01-21 at 09:27 +0200, Heikki Linnakangas wrote:

> Right, that's the way a standby server (= one still in recovery) has
> always behaved. It has made sense in the past: it's not in the spirit
> of smart shutdown to kill the WAL replay immediately. "smart" means
> wait for recovery to finish, then shutdown.
> 
> It's a good question if that still makes sense with Hot Standby.
> Perhaps we should redefine smart shutdown in standby mode to shut down
> as soon as all read-only connections have died.

It's clear that "smart" shutdown doesn't work while something is active.
Recovery is "active" and so we shouldn't shutdown. It makes sense, it
works like this already, lets leave it. Document it if needed.

-- Simon Riggs           www.2ndQuadrant.com



pgsql-hackers by date:

Previous
From: Tom Lane
Date:
Subject: Re: PG 9.0 and standard_conforming_strings
Next
From: Jeff Davis
Date:
Subject: Re: Listen / Notify - what to do when the queue is full