Re: PITR recover ends unexpected - Mailing list pgsql-admin

From Jim C. Nasby
Subject Re: PITR recover ends unexpected
Date
Msg-id 20051107184909.GA19551@pervasive.com
Whole thread Raw
In response to PITR recover ends unexpected  (Bernd Rieke <bernd@rhm.de>)
List pgsql-admin
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

pgsql-admin by date:

Previous
From: "Dave Page"
Date:
Subject: Re: [webmaster] How can I join in the PostgreSql developing team ?
Next
From: "Tomeh, Husam"
Date:
Subject: DB Links in Postgres?