| From: | Andres Freund <andres(at)anarazel(dot)de> |
|---|---|
| To: | Peter Eisentraut <peter(dot)eisentraut(at)2ndquadrant(dot)com> |
| Cc: | rajan <vgmonnet(at)gmail(dot)com>, pgsql-admin(at)postgresql(dot)org |
| Subject: | Re: WAL restoration is not happening completely |
| Date: | 2016-11-14 17:55:09 |
| Message-ID: | 20161114175509.3wgvxos44hxxz26i@alap3.anarazel.de |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-admin |
On 2016-11-14 08:58:14 -0500, Peter Eisentraut wrote:
> 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.
Could quite well be a restore with a deleted backup_label - that tends
to cause symptoms like that.
Rajan, did you by chance delete backup_label?
Regards,
Andres
| From | Date | Subject | |
|---|---|---|---|
| Next Message | John Scalia | 2016-11-14 21:10:14 | hostnossl in pg_hba.conf demands a password |
| Previous Message | Poul Kristensen | 2016-11-14 17:16:42 | C code with embedded SQL |