Thread: PITR recover ends unexpected

PITR recover ends unexpected

From
Bernd Rieke
Date:
Hi,
since some month we use PITR and it works fine. We make a base backup
once a week. For testing if everything will work when needed we replay
the wal files every day to the base backup on a second machine. It works
fine except for two time when we saw a strange problem. The recovery
process stated a zero length record in the wal file and stop 'as
expected' as it told us. The recovered database was useable but we had a
gap in the recovered data from the time it stops replaying wal files up
to the next base backup. We didn't see any hardware problems or problems
while copying the wal files to the second machine. So our question is if
anybody out there saw a similar problem.

Thanks in advance for your replies

Bernd Rieke

Re: PITR recover ends unexpected

From
"Jim C. Nasby"
Date:
Next time it happens please post the exact error message, and keep all
the files that are involved.

On Fri, Nov 04, 2005 at 10:43:16PM +0100, Bernd Rieke wrote:
> Hi,
> since some month we use PITR and it works fine. We make a base backup
> once a week. For testing if everything will work when needed we replay
> the wal files every day to the base backup on a second machine. It works
> fine except for two time when we saw a strange problem. The recovery
> process stated a zero length record in the wal file and stop 'as
> expected' as it told us. The recovered database was useable but we had a
> gap in the recovered data from the time it stops replaying wal files up
> to the next base backup. We didn't see any hardware problems or problems
> while copying the wal files to the second machine. So our question is if
> anybody out there saw a similar problem.
>
> Thanks in advance for your replies
>
> Bernd Rieke
>
> ---------------------------(end of broadcast)---------------------------
> TIP 6: explain analyze is your friend
>

--
Jim C. Nasby, Sr. Engineering Consultant      jnasby@pervasive.com
Pervasive Software      http://pervasive.com    work: 512-231-6117
vcard: http://jim.nasby.net/pervasive.vcf       cell: 512-569-9461