From: | "Fujii Masao" <masao(dot)fujii(at)gmail(dot)com> |
---|---|
To: | "pgsql-hackers list" <pgsql-hackers(at)postgresql(dot)org>, "Simon Riggs" <simon(at)2ndquadrant(dot)com>, "Heikki Linnakangas" <heikki(dot)linnakangas(at)enterprisedb(dot)com> |
Subject: | Archiving control (a part of synch rep patches) |
Date: | 2008-12-24 07:39:07 |
Message-ID: | 3f0b79eb0812232339n5d5b4deao760d35e5d3a54283@mail.gmail.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-hackers |
Hi,
Some people want to disable xlog archiving only during synchronous
replication. So, first, I created and attached the self-contained patch
to control xlog archiving dynamically. Since it would still take time to
fix whole patch of synch rep, and opening it at a time would burden
reviewers, I opened this patch this time.
http://archives.postgresql.org/pgsql-hackers/2008-12/msg00718.php
This patch provides three abilities:
(1)
Turn off xlog archiving from the specified file. For example, if the
xlog file including replication starting position is specified, we can
stop archiving the xlog files which are generated during replication.
Specifically, we only skip executing archive command after turning
off, that is, archiver is still in progress and .done file is created.
This reduces the burden of resuming archiving.
(2)
Turn back on xlog archiving from the specified file.
(3)
Revert the arhive status file of the specified file from .done to .ready.
This would try to archive the corresponding xlog file again. The archive
status of only skipped xlog file can be reverted.
We resume xlog archiving by using (2) and (3), when replication
ends.
(1) and (2) are provided as PgArchControl() in pgarch.c.
(3) is provided as XLogArchiveRevert() in xlog.c.
Please feel free to comment!
Regards,
--
Fujii Masao
NIPPON TELEGRAPH AND TELEPHONE CORPORATION
NTT Open Source Software Center
Attachment | Content-Type | Size |
---|---|---|
control_archiving_v1.patch | text/x-patch | 17.9 KB |
From | Date | Subject | |
---|---|---|---|
Next Message | Peter Eisentraut | 2008-12-24 07:55:12 | Re: about truncate |
Previous Message | Peter Eisentraut | 2008-12-24 07:07:56 | Re: reloptions and toast tables |