| From: | Simon Riggs <simon(at)2ndQuadrant(dot)com> |
|---|---|
| To: | Heikki Linnakangas <heikki(dot)linnakangas(at)enterprisedb(dot)com> |
| Cc: | Mikael Krantz <mk(at)zigamorph(dot)se>, pgsql-bugs(at)postgresql(dot)org, pgsql-hackers <pgsql-hackers(at)postgresql(dot)org> |
| Subject: | Re: BUG #4796: Recovery followed by backup creates unrecoverable WAL-file |
| Date: | 2009-05-07 13:08:42 |
| Message-ID: | 1241701722.6109.160.camel@ebony.2ndQuadrant |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-bugs pgsql-hackers |
On Thu, 2009-05-07 at 12:15 +0300, Heikki Linnakangas wrote:
> Yeah, I think you're right. If you omit pg_xlog from the base backup,
> as we recommend in the manual, and clear the old files from the
> archive too, then you won't have the old history file around.
Sorry about this, but I don't agree with that fix and think it needs
more discussion, at very least. (I'm also not sure why this fix needs to
applied with such haste, even taking priority over other unapplied
patches.)
The error seems to come from deleting the history file from the archive,
rather than from the sequence of actions.
A more useful thing might be to do an xlog switch before we do the
shutdown checkpoint at end of recovery. That gives the same sequence of
actions without modifying the existing sequence of activities for
backups, which is delicate enough for me to not want to touch it.
--
Simon Riggs www.2ndQuadrant.com
PostgreSQL Training, Services and Support
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Heikki Linnakangas | 2009-05-07 14:54:33 | Re: BUG #4796: Recovery followed by backup creates unrecoverable WAL-file |
| Previous Message | Stefan Huehner | 2009-05-07 13:00:13 | Re: Bug (8.4beta): FailedAssertion("!(bms_is_subset(relids, qualscope))", File: "initsplan.c", Line: 915) |
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Tom Lane | 2009-05-07 13:46:16 | Re: Extra cost of "lossy mode" Bitmap Scan plan |
| Previous Message | Simon Riggs | 2009-05-07 12:48:03 | Re: Serializable Isolation without blocking |