Re: error during PITR - Mailing list pgsql-admin

From Kevin Grittner
Subject Re: error during PITR
Date
Msg-id 4EF442CF020000250004408A@gw.wicourts.gov
Whole thread Raw
In response to Re: error during PITR  (Karuna Karpe <karuna.karpe@os3infotech.com>)
List pgsql-admin
Karuna Karpe <karuna.karpe@os3infotech.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

pgsql-admin by date:

Previous
From: Karuna Karpe
Date:
Subject: Re: error during PITR
Next
From: nagaraj L M
Date:
Subject: backup of schema