PITR recover ends unexpected

From: Bernd Rieke <bernd(at)rhm(dot)de>
To: pgsql-admin(at)postgresql(dot)org
Subject: PITR recover ends unexpected
Date: 2005-11-04 21:43:16
Message-ID: 436BD5F4.3090108@rhm.de
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin

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

Responses

Browse pgsql-admin by date

  From Date Subject
Next Message Leonia Zając 2005-11-04 22:26:55 INDEXes
Previous Message Jim C. Nasby 2005-11-04 19:45:13 Re: Backup/Restore Views