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@xxxxxxxxxxxxx Pervasive Software http://pervasive.com work: 512-231-6117 vcard: http://jim.nasby.net/pervasive.vcf cell: 512-569-9461 ---------------------------(end of broadcast)--------------------------- TIP 2: Don't 'kill -9' the postmaster
