Movatterモバイル変換


[0]ホーム

URL:


Skip to content

Navigation Menu

Sign in
Appearance settings

Search code, repositories, users, issues, pull requests...

Provide feedback

We read every piece of feedback, and take your input very seriously.

Saved searches

Use saved searches to filter your results more quickly

Sign up
Appearance settings

Commit4644a11

Browse files
committed
Improve pg_resetwal documentation
Clarify that the -l option takes a file name, not an "address", and thatthat might be different from the LSN if nondefault WAL segment sizes areused.
1 parentc92f7c6 commit4644a11

File tree

1 file changed

+11
-3
lines changed

1 file changed

+11
-3
lines changed

‎doc/src/sgml/ref/pg_resetwal.sgml

Lines changed: 11 additions & 3 deletions
Original file line numberDiff line numberDiff line change
@@ -62,7 +62,7 @@ PostgreSQL documentation
6262
values will be substituted for the missing data. Most of the fields can be
6363
expected to match, but manual assistance might be needed for the next OID,
6464
next transaction ID and epoch, next multitransaction ID and offset, and
65-
WAL startingaddress fields. These fields can be set using the options
65+
WAL startinglocation fields. These fields can be set using the options
6666
discussed below. If you are not able to determine correct values for all
6767
these fields, <option>-f</option> can still be used, but
6868
the recovered database must be treated with even more suspicion than
@@ -167,11 +167,12 @@ PostgreSQL documentation
167167
<term><option>-l</option> <replaceable class="parameter">walfile</replaceable></term>
168168
<listitem>
169169
<para>
170-
Manually set the WAL starting address.
170+
Manually set the WAL starting location by specifying the name of the
171+
next WAL segment file.
171172
</para>
172173

173174
<para>
174-
The WALstarting address should be
175+
Thename of nextWALsegment file should be
175176
larger than any WAL segment file name currently existing in
176177
the directory <filename>pg_wal</filename> under the data directory.
177178
These names are also in hexadecimal and have three parts. The first
@@ -180,6 +181,13 @@ PostgreSQL documentation
180181
largest entry in <filename>pg_wal</filename>, use <literal>-l 00000001000000320000004B</literal> or higher.
181182
</para>
182183

184+
<para>
185+
Note that when using nondefault WAL segment sizes, the numbers in the WAL
186+
file names are different from the LSNs that are reported by system
187+
functions and system views. This option takes a WAL file name, not an
188+
LSN.
189+
</para>
190+
183191
<note>
184192
<para>
185193
<command>pg_resetwal</command> itself looks at the files in

0 commit comments

Comments
 (0)

[8]ページ先頭

©2009-2025 Movatter.jp