pg.ddx.io  pgsql-admin@postgresql.org mailing list archive  
help / color / mirror / Atom feed
From: Bernd Rieke <bernd@rhm.de>
To: pgsql-admin@postgresql.org
Subject: PITR recover ends unexpected
Date: Fri, 04 Nov 2005 22:43:16 +0100
Message-ID: <436BD5F4.3090108@rhm.de> (raw)

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



view thread (2+ messages)  latest in thread

Message-ID: <436BD5F4.3090108@rhm.de>
Permalink:  ../436BD5F4.3090108@rhm.de/
Also on:    postgresql.org/message-id/436BD5F4.3090108@rhm.de

 · 

reply

Reply instructions:

You may reply publicly to this message via plain-text email
using any one of the following methods:

* Reply to all the recipients from your mail client; the link fills in
  the headers below: reply via email
  Some clients, webmail especially, drop In-Reply-To and References from
  a link, and the reply then starts a new thread: use the mbox below.

  To: pgsql-admin@postgresql.org
  Cc: bernd@rhm.de
  Subject: Re: PITR recover ends unexpected
  In-Reply-To: <436BD5F4.3090108@rhm.de>
  References: <436BD5F4.3090108@rhm.de>

* Save the following mbox file, import it into your mail client,
  and reply-to-all from there: mbox

This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox