Re: PITR bad restore possibility? - Mailing list pgsql-hackers

From Tom Lane
Subject Re: PITR bad restore possibility?
Date
Msg-id 5155.1114647255@sss.pgh.pa.us
Whole thread Raw
In response to PITR bad restore possibility?  (Rod Taylor <pg@rbt.ca>)
Responses Re: PITR bad restore possibility?  (Rod Taylor <pg@rbt.ca>)
List pgsql-hackers
Rod Taylor <pg@rbt.ca> writes:
> What happens if for reasons of broken tape, disk, etc. you lose some of
> your WAL logs which happens to correspond to the middle of the snapshot
> backup?

You're screwed ... just like if you lost part of the snapshot itself.

If you're really lucky the missing WAL logs don't contain any data
that's not in the snapshot, but I sure wouldn't trust it.
        regards, tom lane


pgsql-hackers by date:

Previous
From: Juan Jose Costello Levien
Date:
Subject: Developer Community
Next
From: "Jim C. Nasby"
Date:
Subject: Re: Developer Community