Re: WAL restoration is not happening completely - Mailing list pgsql-admin

From Peter Eisentraut
Subject Re: WAL restoration is not happening completely
Date
Msg-id aa031ba7-eda4-08ad-b553-80e1171a72bc@2ndquadrant.com
Whole thread Raw
In response to WAL restoration is not happening completely  (rajan <vgmonnet@gmail.com>)
Responses Re: WAL restoration is not happening completely  (Andres Freund <andres@anarazel.de>)
List pgsql-admin
On 11/14/16 4:49 AM, rajan wrote:
> *The restored database has changes which were done today and missing data
> from changes did a couple of days before.*

That is pretty much impossible.

It is plausible to mess some of this up and end up with a database
instance that is missing the trailing end of changes because recovery
aborted early somehow.  But missing changes *in the middle* is not
possible, unless you are encountering a serious bug.

I suggest that there is some other confusion or misunderstanding going
on.  Just to be sure, make sure you are using the latest minor version.

--
Peter Eisentraut              http://www.2ndQuadrant.com/
PostgreSQL Development, 24x7 Support, Remote DBA, Training & Services


pgsql-admin by date:

Previous
From: rajan
Date:
Subject: WAL restoration is not happening completely
Next
From: Ian Barwick
Date:
Subject: Re: WAL restoration is not happening completely