Re: Warm standby questions

From: Simon Riggs <simon(at)2ndQuadrant(dot)com>
To: "David F(dot) Skoll" <dfs(at)roaringpenguin(dot)com>
Cc: pgsql-admin(at)postgresql(dot)org
Subject: Re: Warm standby questions
Date: 2009-10-13 18:19:15
Message-ID: 1255457955.15590.4126.camel@ebony
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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

In response to

Browse pgsql-admin by date

  From Date Subject
Next Message Michael Graziano 2009-10-13 18:41:57 Re: Warm standby questions
Previous Message Kevin Grittner 2009-10-13 18:07:05 Re: How to size a log file partition