Skip site navigation (1) Skip section navigation (2)

The last WAL segment of the old timeline is not archived for a while after archive recovery

From: Fujii Masao <masao(dot)fujii(at)gmail(dot)com>
To: pgsql-hackers <pgsql-hackers(at)postgresql(dot)org>
Subject: The last WAL segment of the old timeline is not archived for a while after archive recovery
Date: 2009-04-22 09:20:49
Message-ID: 3f0b79eb0904220220n24259cadqf6c31a97d9544e4e@mail.gmail.com (view raw or flat)
Thread:
Lists: pgsql-hackers
Hi,

In archive recovery, the last applied WAL segment may not have
.ready file in spite of not having been archived yet. Then, this
segment is not archived until a future checkpoint creates .ready
file. It's a little dangerous that there is the WAL segment which
is not archived for a while.

Attached patch fixes this problem. Is this worth committing?

Regards,

-- 
Fujii Masao
NIPPON TELEGRAPH AND TELEPHONE CORPORATION
NTT Open Source Software Center

Attachment: archive_last_wal_0422.patch
Description: application/octet-stream (1.0 KB)

Responses

pgsql-hackers by date

Next:From: Robert CampbellDate: 2009-04-22 12:18:43
Subject: Workaround for bug #4608?
Previous:From: Fujii MasaoDate: 2009-04-22 07:57:23
Subject: Re: Why isn't stats_temp_directory automatically created?

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group