Re: Hot standby, recovery_starts_paused - Mailing list pgsql-hackers

From Simon Riggs
Subject Re: Hot standby, recovery_starts_paused
Date
Msg-id 1255669219.30088.2589.camel@ebony
Whole thread Raw
In response to Hot standby, recovery_starts_paused  (Heikki Linnakangas <heikki.linnakangas@enterprisedb.com>)
List pgsql-hackers
On Fri, 2009-10-16 at 01:43 +0300, Heikki Linnakangas wrote:

> recovery_starts_paused is useless as it is. It pauses the recovery right
> after the first WAL record, all right, but before we see a running-xacts
> record, we won't let any backends in. And if you can't connect, you
> can't unpause, so it's stuck forever.

Hmmm, strange. That was an earlier bug; I thought I'd fixed that.

> It should probably behave as "pause after reaching WAL record that
> allows backends to connect".

Agreed, thanks.

-- Simon Riggs           www.2ndQuadrant.com



pgsql-hackers by date:

Previous
From: "Greg Sabino Mullane"
Date:
Subject: DELETE not seeing expected rows before COPY on 8.4.1
Next
From: Heikki Linnakangas
Date:
Subject: Hot standby, pausing recovery