From: | "Simon Riggs" <simon(at)2ndquadrant(dot)com> |
---|---|
To: | <pgsql-bugs(at)postgresql(dot)org> |
Subject: | PITR recovery leaves archive_status files in incorrect state |
Date: | 2007-06-24 16:31:59 |
Message-ID: | 1182702719.9276.444.camel@silverbirch.site |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-bugs |
Jon Culverson posted to -admin on 2 June with a PITR bug that seems to
go back at least 2 releases, i.e. it occurs in 8.2 and 8.1 current
production releases as well as CVS HEAD.
The issue is that some archive_status files are left in an invalid
state, when the last recovered file is from the archive rather than the
local directory. The archive_status files show that a file that came
from the archive is ready to be archived (again). This causes archiving
to fail on a newly recovered server if you have an archive_command that
prevents duplicate inserts into the archive and you watch the logs long
enough to notice the failure, which can occur some seconds after the
server is operational. [That precise timing window is related to a
second bug report by Kevin Grittner on -hackers on 22 June.]
Recovery itself does not have a bug, so there is no need to take
additional backups as a result of this. The workaround is to set
archive_command to a command that allows duplicate inserts.
Culverson's bug has been patched, as of 8 June and confirmed resolved,
but has not been applied. Please review the patch and apply/reject.
Grittner's bug has not yet been patched by me, expected soon.
--
Simon Riggs
EnterpriseDB http://www.enterprisedb.com
From | Date | Subject | |
---|---|---|---|
Next Message | zhang.hm | 2007-06-25 02:58:26 | BUG #3411: how to add the granted of "Log on as a service" |
Previous Message | Tom Lane | 2007-06-23 16:50:14 | Re: BUG #3405: plperl_elog - regression test fails |