| From: | Andres Freund <andres(at)anarazel(dot)de> |
|---|---|
| To: | Michael Paquier <michael(dot)paquier(at)gmail(dot)com> |
| Cc: | fredrik(at)huitfeldt(dot)com, pgsql-general <pgsql-general(at)postgresql(dot)org> |
| Subject: | Re: out-of-order XID insertion in KnownAssignedXids |
| Date: | 2016-10-20 20:38:26 |
| Message-ID: | 20161020203826.cmccyipkvfa2r2fn@alap3.anarazel.de |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
On 2016-10-20 22:37:15 +0900, Michael Paquier wrote:
> On Thu, Oct 20, 2016 at 10:21 PM, <fredrik(at)huitfeldt(dot)com> wrote:
> > - remove a file called backup_label, but I am not certain that this file is
> > in fact there (any more).
>
> It is never a good idea when you are trying to restore from a backup,
> backup_label contains critical information when restoring from a
> backup, so you may finish with a corrupted data folder.
And this actually seems like a likely source of these errors. Removing
a backup label unfortunately causes hard to diagnose errors, because
everything appears to be ok as long as there's no checkpoints while
taking the base backups (or when the control file was copied early
enough). But as soon as a second checkpoint happens before the control
file is copied...
Fredrik, how did you end up removing the label?
Greetings,
Andres Freund
| From | Date | Subject | |
|---|---|---|---|
| Next Message | David G. Johnston | 2016-10-20 21:37:55 | Re: Showing matrix with single query |
| Previous Message | John R Pierce | 2016-10-20 18:53:20 | Re: Postgresql apt repository naming scheme question |