Re: PITR recover ends unexpected

From: "Jim C(dot) Nasby" <jnasby(at)pervasive(dot)com>
To: Bernd Rieke <bernd(at)rhm(dot)de>
Cc: pgsql-admin(at)postgresql(dot)org
Subject: Re: PITR recover ends unexpected
Date: 2005-11-07 18:49:10
Message-ID: 20051107184909.GA19551@pervasive.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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(at)pervasive(dot)com
Pervasive Software http://pervasive.com work: 512-231-6117
vcard: http://jim.nasby.net/pervasive.vcf cell: 512-569-9461

In response to

Browse pgsql-admin by date

  From Date Subject
Next Message John Allgood 2005-11-07 19:56:17 PostgreSQL / Redhat Cluster Suite
Previous Message Tomeh, Husam 2005-11-07 17:49:30 DB Links in Postgres?