Re: incremental backups

Wonderful. That is good news. Thanks.

Rick

On Jan 31, 2006, at 7:14 AM, Tom Lane wrote:

> Rick Gigger <rick(at)alpinenetworking(dot)com> writes:
>> That's what I mean by invalid. Let's say I do something stupid and
>> do a physical backup and I don't grab the current WAL file. All I
>> have is the last one to be archived before I did my backup, which is
>> not late enough to do a valid restore. Will postgres know that the
>> restore process failed because I didn't have that last necessary WAL
>> file or will it just start up in a potentially inconsistent state.
>
> Yes:
>
> /*
> * Complain if we did not roll forward far enough to render the
> backup
> * dump consistent.
> */
> if (XLByteLT(EndOfLog, recoveryMinXlogOffset))
> {
> if (needNewTimeLine) /* stopped because of stop request */
> ereport(FATAL,
> (errmsg("requested recovery stop point is
> before end time of backup dump")));
> else
> /* ran off end of WAL */
> ereport(FATAL,
> (errmsg("WAL ends before end time of backup
> dump")));
> }
>
> regards, tom lane
>