-
Notifications
You must be signed in to change notification settings - Fork 0
Expand file tree
/
Copy pathapp-pgwalsummary.html
More file actions
71 lines (71 loc) · 8.65 KB
/
app-pgwalsummary.html
File metadata and controls
71 lines (71 loc) · 8.65 KB
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
<?xml version="1.0" encoding="UTF-8" standalone="no"?>
<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd"><html xmlns="http://www.w3.org/1999/xhtml"><head><meta http-equiv="Content-Type" content="text/html; charset=UTF-8" /><title>pg_walsummary</title><link rel="stylesheet" type="text/css" href="stylesheet.css" /><link rev="made" href="pgsql-docs@lists.postgresql.org" /><meta name="generator" content="DocBook XSL Stylesheets Vsnapshot" /><link rel="prev" href="pgwaldump.html" title="pg_waldump" /><link rel="next" href="app-postgres.html" title="postgres" /><meta name="viewport" content="width=device-width,initial-scale=1.0" /></head><body id="docContent" class="container-fluid col-10"><div class="navheader"><table width="100%" summary="Navigation header"><tr><th colspan="4" align="center"><a accesskey="h" href="index.html">PostgreSQL 17devel文書</a></th></tr><tr><td width="10%" align="left"></td><td width="10%" align="left"></td><td width="60%" align="center"><a href="reference-server.html" title="PostgreSQLサーバアプリケーション">PostgreSQLサーバアプリケーション</a></td><td width="20%" align="right"></td></tr><tr><td width="10%" align="left"><a accesskey="p" href="pgwaldump.html" title="pg_waldump">前へ</a> </td><td width="10%" align="left"><a accesskey="u" href="reference-server.html" title="PostgreSQLサーバアプリケーション">上へ</a></td><td width="60%" align="center"><span class="application">pg_walsummary</span></td><td width="20%" align="right"> <a accesskey="n" href="app-postgres.html" title="postgres">次へ</a></td></tr></table><hr /></div><div class="refentry" id="APP-PGWALSUMMARY"><div class="titlepage"></div><a id="id-1.9.5.15.1" class="indexterm"></a><div class="refnamediv"><h2><span class="refentrytitle"><span class="application">pg_walsummary</span></span></h2><p>pg_walsummary — print contents of WAL summary files</p></div><div class="refsynopsisdiv"><h2>概要</h2><div class="cmdsynopsis"><p id="id-1.9.5.15.4.1"><code class="command">pg_walsummary</code> [<em class="replaceable"><code>option</code></em>...] [<em class="replaceable"><code>file</code></em>...]</p></div></div><div class="refsect1" id="id-1.9.5.15.5"><h2>説明</h2><!--
<title>Description</title>
--><p>
<!--
<application>pg_walsummary</application> is used to print the contents of
WAL summary files. These binary files are found with the
<literal>pg_wal/summaries</literal> subdirectory of the data directory,
and can be converted to text using this tool. This is not ordinarily
necessary, since WAL summary files primarily exist to support
<link linkend="backup-incremental-backup">incremental backup</link>,
but it may be useful for debugging purposes.
-->
《機械翻訳》«<span class="application">pg_walsummary</span> is used to print the contents of WAL summary files. These binary files are found with the <code class="literal">pg_wal/summaries</code> subdirectory of the data directory, and can be converted to text using this tool. This is not ordinarily necessary, since WAL summary files primarily exist to support <a class="link" href="continuous-archiving.html#BACKUP-INCREMENTAL-BACKUP" title="25.3.3. Making an Incremental Backup">incremental backup</a>, but it may be useful for debugging purposes.»
</p><p>
<!--
A WAL summary file is indexed by tablespace OID, relation OID, and relation
fork. For each relation fork, it stores the list of blocks that were
modified by WAL within the range summarized in the file. It can also
store a "limit block," which is 0 if the relation fork was created or
truncated within the relevant WAL range, and otherwise the shortest length
to which the relation fork was truncated. If the relation fork was not
created, deleted, or truncated within the relevant WAL range, the limit
block is undefined or infinite and will not be printed by this tool.
-->
《機械翻訳》«A WAL summary file is indexed by tablespace OID, relation OID, and relation fork. For each relation fork, it stores the list of blocks that were modified by WAL within the range summarized in the file. It can also store a "limit block," which is 0 if the relation fork was created or truncated within the relevant WAL range, and otherwise the shortest length to which the relation fork was truncated. If the relation fork was not created, deleted, or truncated within the relevant WAL range, the limit block is undefined or infinite and will not be printed by this tool.»
</p></div><div class="refsect1" id="id-1.9.5.15.6"><h2>オプション</h2><!--
<title>Options</title>
--><p>
</p><div class="variablelist"><dl class="variablelist"><dt><span class="term"><code class="option">-i</code><br /></span><span class="term"><code class="option">--individual</code></span></dt><dd><p>
<!--
By default, <literal>pg_walsummary</literal> prints one line of output
for each range of one or more consecutive modified blocks. This can
make the output a lot briefer, since a relation where all blocks from
0 through 999 were modified will produce only one line of output rather
than 1000 separate lines. This option requests a separate line of
output for every modified block.
-->
《機械翻訳》«By default, <code class="literal">pg_walsummary</code> prints one line of output for each range of one or more consecutive modified blocks. This can make the output a lot briefer, since a relation where all blocks from 0 through 999 were modified will produce only one line of output rather than 1000 separate lines. This option requests a separate line of output for every modified block.»
</p></dd><dt><span class="term"><code class="option">-q</code><br /></span><span class="term"><code class="option">--quiet</code></span></dt><dd><p>
<!--
Do not print any output, except for errors. This can be useful
when you want to know whether a WAL summary file can be successfully
parsed but don't care about the contents.
-->
《機械翻訳》«Do not print any output, except for errors. This can be useful when you want to know whether a WAL summary file can be successfully parsed but don't care about the contents.»
</p></dd><dt><span class="term"><code class="option">-V</code><br /></span><span class="term"><code class="option">--version</code></span></dt><dd><p>
<!--
Display version information, then exit.
-->
《機械翻訳》«Display version information, then exit.»
</p></dd><dt><span class="term"><code class="option">-?</code><br /></span><span class="term"><code class="option">--help</code></span></dt><dd><p>
<!--
Shows help about <application>pg_walsummary</application> command line
arguments, and exits.
-->
《機械翻訳》«Shows help about <span class="application">pg_walsummary</span> command line arguments, and exits.»
</p></dd></dl></div><p>
</p></div><div class="refsect1" id="id-1.9.5.15.7"><h2>環境</h2><!--
<title>Environment</title>
--><p>
<!--
The environment variable <envar>PG_COLOR</envar> specifies whether to use
color in diagnostic messages. Possible values are
<literal>always</literal>, <literal>auto</literal> and
<literal>never</literal>.
-->
《機械翻訳》«The environment variable <code class="envar">PG_COLOR</code> specifies whether to use color in diagnostic messages. Possible values are <code class="literal">always</code>, <code class="literal">auto</code> and <code class="literal">never</code>.»
</p></div><div class="refsect1" id="id-1.9.5.15.8"><h2>関連項目</h2><!--
<title>See Also</title>
--><span class="simplelist"><a class="xref" href="app-pgbasebackup.html" title="pg_basebackup"><span class="refentrytitle"><span class="application">pg_basebackup</span></span></a>, <a class="xref" href="app-pgcombinebackup.html" title="pg_combinebackup"><span class="refentrytitle"><span class="application">pg_combinebackup</span></span></a></span></div></div><div class="navfooter"><hr /><table width="100%" summary="Navigation footer"><tr><td width="40%" align="left"><a accesskey="p" href="pgwaldump.html" title="pg_waldump">前へ</a> </td><td width="20%" align="center"><a accesskey="u" href="reference-server.html" title="PostgreSQLサーバアプリケーション">上へ</a></td><td width="40%" align="right"> <a accesskey="n" href="app-postgres.html" title="postgres">次へ</a></td></tr><tr><td width="40%" align="left" valign="top"><span class="application">pg_waldump</span> </td><td width="20%" align="center"><a accesskey="h" href="index.html" title="PostgreSQL 17devel文書">ホーム</a></td><td width="40%" align="right" valign="top"> <span class="application">postgres</span></td></tr></table></div></body></html>