estartpoint-to-archive_cleanup.patch
application/octet-stream
Filename: estartpoint-to-archive_cleanup.patch
Type: application/octet-stream
Part: 0
Patch
Same data as JSON:
GET /api/v1/attachments/:id/patch
the parsed metadata as JSON — format, series position, per-file stats; never the diff bytes.
API reference →
Format: unified
| File | + | − |
|---|---|---|
| doc/src/sgml/high-availability.sgml | 2 | 2 |
| doc/src/sgml/recovery-config.sgml | 5 | 5 |
| doc/src/sgml/release-9.0.sgml | 9 | 0 |
| src/backend/access/transam/recovery.conf.sample | 2 | 2 |
| src/backend/access/transam/xlog.c | 16 | 16 |
Index: doc/src/sgml/high-availability.sgml
===================================================================
--- doc/src/sgml/high-availability.sgml (head)
+++ doc/src/sgml/high-availability.sgml (archive_cleanup_command)
@@ -681,7 +681,7 @@
</para>
<para>
- You can use <varname>restartpoint_command</> to prune the archive of
+ You can use <varname>archive_cleanup_command</> to prune the archive of
files no longer needed by the standby.
</para>
@@ -714,7 +714,7 @@
<para>
If you're using a WAL archive, its size can be minimized using
- the <varname>restartpoint_command</> option to remove files that are
+ the <varname>archive_cleanup_command</> option to remove files that are
no longer required by the standby server. Note however, that if you're
using the archive for backup purposes, you need to retain files needed
to recover from at least the latest base backup, even if they're no
Index: doc/src/sgml/recovery-config.sgml
===================================================================
--- doc/src/sgml/recovery-config.sgml (head)
+++ doc/src/sgml/recovery-config.sgml (archive_cleanup_command)
@@ -73,16 +73,16 @@
</listitem>
</varlistentry>
- <varlistentry id="restartpoint-command" xreflabel="restartpoint_command">
- <term><varname>restartpoint_command</varname> (<type>string</type>)</term>
+ <varlistentry id="archive-cleanup-command" xreflabel="archive_cleanup_command">
+ <term><varname>archive_cleanup_command</varname> (<type>string</type>)</term>
<indexterm>
- <primary><varname>restartpoint_command</> recovery parameter</primary>
+ <primary><varname>archive_cleanup_command</> recovery parameter</primary>
</indexterm>
<listitem>
<para>
This parameter specifies a shell command that will be executed at
every restartpoint. This parameter is optional. The purpose of the
- <varname>restartpoint_command</> is to provide a mechanism for cleaning
+ <varname>archive_cleanup_command</> is to provide a mechanism for cleaning
up old archived WAL files that are no longer needed by the standby
server.
Any <literal>%r</> is replaced by the name of the file
@@ -114,7 +114,7 @@
<varname>recovery_end_command</> is to provide a mechanism for cleanup
following replication or recovery.
Any <literal>%r</> is replaced by the name of the file containing the
- last valid restart point, like in <xref linkend="restartpoint-command">.
+ last valid restart point, like in <xref linkend="archive-cleanup-command">.
</para>
<para>
If the command returns a non-zero exit status then a WARNING log
Index: doc/src/sgml/release-9.0.sgml
===================================================================
--- doc/src/sgml/release-9.0.sgml (head)
+++ doc/src/sgml/release-9.0.sgml (archive_cleanup_command)
@@ -415,6 +415,15 @@
</para>
</listitem>
+ <listitem>
+ <para>
+ Add <link
+ linkend="archive-cleanup-command"><varname>archive_cleanup_command</></link>,
+ which can be used to clean up old archived WAL files that are no longer
+ needed <acronym>WAL</> by the standby server (Heikki Linnakangas)
+ </para>
+ </listitem>
+
</itemizedlist>
</sect4>
Index: src/backend/access/transam/recovery.conf.sample
===================================================================
--- src/backend/access/transam/recovery.conf.sample (head)
+++ src/backend/access/transam/recovery.conf.sample (archive_cleanup_command)
@@ -46,12 +46,12 @@
#restore_command = '' # e.g. 'cp /mnt/server/archivedir/%f %p'
#
#
-# restartpoint_command
+# archive_cleanup_command
#
# specifies an optional shell command to execute at every restartpoint.
# This can be useful for cleaning up the archive of a standby server.
#
-#restartpoint_command = ''
+#archive_cleanup_command = ''
#
# recovery_end_command
#
Index: src/backend/access/transam/xlog.c
===================================================================
--- src/backend/access/transam/xlog.c (head)
+++ src/backend/access/transam/xlog.c (archive_cleanup_command)
@@ -180,7 +180,7 @@
/* options taken from recovery.conf for archive recovery */
static char *recoveryRestoreCommand = NULL;
static char *recoveryEndCommand = NULL;
-static char *restartPointCommand = NULL;
+static char *archiveCleanupCommand = NULL;
static RecoveryTargetType recoveryTarget = RECOVERY_TARGET_UNSET;
static bool recoveryTargetInclusive = true;
static TransactionId recoveryTargetXid;
@@ -382,10 +382,10 @@
TimeLineID ThisTimeLineID;
TimeLineID RecoveryTargetTLI;
/*
- * restartPointCommand is read from recovery.conf but needs to be in
+ * archiveCleanupCommand is read from recovery.conf but needs to be in
* shared memory so that the bgwriter process can access it.
*/
- char restartPointCommand[MAXPGPATH];
+ char archiveCleanupCommand[MAXPGPATH];
/*
* SharedRecoveryInProgress indicates if we're still in crash or archive
@@ -3047,7 +3047,7 @@
* 'failonSignal' is true and the command is killed by a signal, a FATAL
* error is thrown. Otherwise a WARNING is emitted.
*
- * This is currently used for restore_end_command and restartpoint_command.
+ * This is currently used for restore_end_command and archive_cleanup_command.
*/
static void
ExecuteRecoveryCommand(char *command, char *commandName, bool failOnSignal)
@@ -5124,12 +5124,12 @@
(errmsg("recovery_end_command = '%s'",
recoveryEndCommand)));
}
- else if (strcmp(tok1, "restartpoint_command") == 0)
+ else if (strcmp(tok1, "archive_cleanup_command") == 0)
{
- restartPointCommand = pstrdup(tok2);
+ archiveCleanupCommand = pstrdup(tok2);
ereport(DEBUG2,
- (errmsg("restartpoint_command = '%s'",
- restartPointCommand)));
+ (errmsg("archive_cleanup_command = '%s'",
+ archiveCleanupCommand)));
}
else if (strcmp(tok1, "recovery_target_timeline") == 0)
{
@@ -5737,13 +5737,13 @@
ControlFile->checkPointCopy.ThisTimeLineID)));
/*
- * Save the selected recovery target timeline ID and restartpoint_command
+ * Save the selected recovery target timeline ID and archive_cleanup_command
* in shared memory so that other processes can see them
*/
XLogCtl->RecoveryTargetTLI = recoveryTargetTLI;
- strncpy(XLogCtl->restartPointCommand,
- restartPointCommand ? restartPointCommand : "",
- sizeof(XLogCtl->restartPointCommand));
+ strncpy(XLogCtl->archiveCleanupCommand,
+ archiveCleanupCommand ? archiveCleanupCommand : "",
+ sizeof(XLogCtl->archiveCleanupCommand));
if (InArchiveRecovery)
{
@@ -7645,11 +7645,11 @@
LWLockRelease(CheckpointLock);
/*
- * Finally, execute restartpoint_command, if any.
+ * Finally, execute archive_cleanup_command, if any.
*/
- if (XLogCtl->restartPointCommand[0])
- ExecuteRecoveryCommand(XLogCtl->restartPointCommand,
- "restartpoint_command",
+ if (XLogCtl->archiveCleanupCommand[0])
+ ExecuteRecoveryCommand(XLogCtl->archiveCleanupCommand,
+ "archive_cleanup_command",
false);
return true;