From: Kevin Grittner <Kevin.Grittner@wicourts.gov>
To: mirrorx <mirrorx@gmail.com>
To: Karuna Karpe <karuna.karpe@os3infotech.com>
Cc: Jerry Sievers <gsievers19@comcast.net>
Cc: pgsql-admin@postgresql.org
Subject: Re: error during PITR
Date: Fri, 23 Dec 2011 08:58:55 -0600
Message-ID: <4EF442CF020000250004408A@gw.wicourts.gov> (raw)
In-Reply-To: <CAC-Lqbp3eMqyMq+eUdkWrPOWi-2G98rrJ0oysyL9m1QPt6RacA@mail.gmail.com>
References: <CAC-LqboudF-f-x1O2oUec2G4338xmjkNJDJOM7darhXBKtggsA@mail.gmail.com>
<CABiPGLcLG5vONGZ=WofFFMXKEEhTS1-OCTr6Ba28+izW7BoYfA@mail.gmail.com>
<87wr9oyboo.fsf@comcast.net>
<CABiPGLfHS8WsXXg7BOW3HLavK0--SrBm26Oq2xp-HXu9PZwb3Q@mail.gmail.com>
<CAC-Lqbp3eMqyMq+eUdkWrPOWi-2G98rrJ0oysyL9m1QPt6RacA@mail.gmail.com>
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
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-admin@postgresql.org
Cc: Kevin.Grittner@wicourts.gov, mirrorx@gmail.com, karuna.karpe@os3infotech.com, gsievers19@comcast.net
Subject: Re: error during PITR
In-Reply-To: <4EF442CF020000250004408A@gw.wicourts.gov>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox