Re: error during PITR

From: "Kevin Grittner" <Kevin(dot)Grittner(at)wicourts(dot)gov>
To: "mirrorx" <mirrorx(at)gmail(dot)com>, "Karuna Karpe" <karuna(dot)karpe(at)os3infotech(dot)com>
Cc: "Jerry Sievers" <gsievers19(at)comcast(dot)net>, <pgsql-admin(at)postgresql(dot)org>
Subject: Re: error during PITR
Date: 2011-12-23 14:58:55
Message-ID: 4EF442CF020000250004408A@gw.wicourts.gov
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin

Karuna Karpe <karuna(dot)karpe(at)os3infotech(dot)com> wrote:

> 2011-12-23 11:44:18 ISTLOG: restored log file
> "00000001000000000000000F" from archive
> 2011-12-23 11:44:18 ISTLOG: record with incorrect prev-link
> 0/E000094 at 0/F000020
> 2011-12-23 11:44:18 ISTLOG: redo done at 0/E0000C0
> 2011-12-23 11:44:18 ISTLOG: restored log file
> "00000001000000000000000E" from archive
> 2011-12-23 11:44:18 ISTFATAL: WAL ends before consistent recovery
> point
> 2011-12-23 11:44:18 ISTLOG: startup process (PID 4435) exited
> with exit code 1
> 2011-12-23 11:44:18 ISTLOG: terminating any other active server
> processes
>
> Can please any one give me solution for that as soon as possible?

It looks like you don't have a good copy of the
00000001000000000000000F WAL file. If you can retrieve a good copy
from somewhere, you should be able to proceed. If not, you should
go to an earlier base backup -- that will let you restore a
consistent version of the database for as far as you have good WAL
files.

You should also review your procedure for copying WAL files. We had
occasional problems like this when we were using samba shares; we've
had none since we copied the files to a directory on the database
server and used rsync to copy them off.

-Kevin

In response to

Browse pgsql-admin by date

  From Date Subject
Next Message nagaraj L M 2011-12-27 07:31:33 backup of schema
Previous Message Karuna Karpe 2011-12-23 11:53:41 Re: error during PITR