Re: Postgres base Backup fails to recover all logs fails from archive

From: Magnus Hagander <magnus(at)hagander(dot)net>
To: Lars Aksel Opsahl <lop(at)skogoglandskap(dot)no>
Cc: "pgsql-admin(at)postgresql(dot)org" <pgsql-admin(at)postgresql(dot)org>
Subject: Re: Postgres base Backup fails to recover all logs fails from archive
Date: 2013-01-07 20:47:37
Message-ID: CABUevEwfHE4b6f8sfWfKQCvzfmzm3J_QJV0DLor4gMjHj4RxMQ@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin

On Sat, Jan 5, 2013 at 11:30 PM, Lars Aksel Opsahl
<lop(at)skogoglandskap(dot)no> wrote:
> Hi
>
> Thanks for your help.
>
> The problem is that it stops to restore the log files after reading log file 0000000100000023000000F7.
>
> The recovery does not continue to read log file 0000000100000023000000F8 and the rest of the log files.
>
> I don't under stand why it stops to read the rest of the log files.

Ah, I see that now.

Well, it's claiming that the F7 logfile is corrupt.

There's also an interesting jump in timestamps - the F7 logfile is
from *much* later than F6. Almost two whole days. Is that actually
normal, or did something possibly go wrong with your archiving?

--
Magnus Hagander
Me: http://www.hagander.net/
Work: http://www.redpill-linpro.com/

In response to

Responses

Browse pgsql-admin by date

  From Date Subject
Next Message Armin Resch 2013-01-07 21:19:58 Re: Using pre-configured vs building Postgres
Previous Message Tom Lane 2013-01-07 18:37:27 Re: Using pre-configured vs building Postgres