Re: Warm standby questions - Mailing list pgsql-admin

From Simon Riggs
Subject Re: Warm standby questions
Date
Msg-id 1255457955.15590.4126.camel@ebony
Whole thread Raw
In response to Warm standby questions  ("David F. Skoll" <dfs@roaringpenguin.com>)
List pgsql-admin
On Tue, 2009-10-13 at 13:17 -0400, David F. Skoll wrote:

> Q2.  If I stop and restart backup server B while master server A continues
> to run, will B continue eating WALs from where it left off?  Or do we need
> another full backup?  (We'll assume WAL shipping continues successfully during
> the time B is down: I'm only stopping/restarting PostgreSQL, not the entire
> machine.)

Recovery is restartable. Not quite from where it left off, but near
enough that it won't take too long to get back to where it left off.

--
 Simon Riggs           www.2ndQuadrant.com


pgsql-admin by date:

Previous
From: "Kevin Grittner"
Date:
Subject: Re: How to size a log file partition
Next
From: Michael Graziano
Date:
Subject: Re: Warm standby questions