Re: Pause at end of recovery - Mailing list pgsql-hackers

From Simon Riggs
Subject Re: Pause at end of recovery
Date
Msg-id CA+U5nM+2JtZKiLhRfDVQL9kT6E6XjYQxC0rSpqEG3u-37BRczw@mail.gmail.com
Whole thread Raw
In response to Pause at end of recovery  (Magnus Hagander <magnus@hagander.net>)
Responses Re: Pause at end of recovery  (Magnus Hagander <magnus@hagander.net>)
List pgsql-hackers
On Tue, Dec 20, 2011 at 1:40 PM, Magnus Hagander <magnus@hagander.net> wrote:
> These days we have pause_at_recovery_target, which lets us pause when
> we reach a PITR target. Is there a particular reason we don't have a
> way to pause at end of recovery if we *didn't* specify a target -
> meaning we let it run until the end of the archived log? While it's
> too late to change the target, I can see a lot of usescases where you
> don't want it to be possible to make changes to the database again
> until it has been properly verified - and keeping it up in readonly
> mode in that case can be quite useful...

Useful for what purpose? It' s possible to deny access in other ways already.

--
 Simon Riggs                   http://www.2ndQuadrant.com/
 PostgreSQL Development, 24x7 Support, Training & Services


pgsql-hackers by date:

Previous
From: Christopher Browne
Date:
Subject: Re: Page Checksums
Next
From: Alvaro Herrera
Date:
Subject: Re: Page Checksums