Skip to content

Commit be05b26

Browse files
committed
Remove pg_resetxlog -r flag, feature has problems referenced here:
http://archives.postgresql.org/pgsql-hackers/2006-05/msg00002.php
1 parent a513ce2 commit be05b26

File tree

2 files changed

+99
-929
lines changed

2 files changed

+99
-929
lines changed

doc/src/sgml/ref/pg_resetxlog.sgml

Lines changed: 16 additions & 22 deletions
Original file line numberDiff line numberDiff line change
@@ -1,5 +1,5 @@
11
<!--
2-
$PostgreSQL: pgsql/doc/src/sgml/ref/pg_resetxlog.sgml,v 1.14 2006/04/26 02:17:15 momjian Exp $
2+
$PostgreSQL: pgsql/doc/src/sgml/ref/pg_resetxlog.sgml,v 1.15 2006/06/03 02:19:24 momjian Exp $
33
PostgreSQL documentation
44
-->
55

@@ -20,7 +20,6 @@ PostgreSQL documentation
2020
<command>pg_resetxlog</command>
2121
<arg>-f</arg>
2222
<arg>-n</arg>
23-
<arg>-r</arg>
2423
<arg>-o<replaceable class="parameter">oid</replaceable> </arg>
2524
<arg>-x <replaceable class="parameter">xid</replaceable> </arg>
2625
<arg>-m <replaceable class="parameter">mxid</replaceable> </arg>
@@ -58,22 +57,22 @@ PostgreSQL documentation
5857

5958
<para>
6059
If <command>pg_resetxlog</command> complains that it cannot determine
61-
valid data for <filename>pg_control</>, you can force it to proceed
62-
anyway by specifying the <literal>-f</> (force) switch. In this case
63-
plausible values will be substituted for the missing data.
64-
<command>pg_resetxlog</command>'s own environment is the source for
65-
its guess at the locale fields; take care that <envar>LANG</> and so
66-
forth match the environment that <command>initdb</> was run in.
67-
<filename>/xlog</> files are used to determine other parameters, like
68-
next OID, next transaction ID, next multi-transaction ID and offset,
69-
WAL starting address, and database locale fields. Because determined
70-
values might be wrong, the first five of these can be set using the
71-
switches discussed below. If you are not able to determine correct
72-
values for all these fields, <literal>-f</> can still be used, but
60+
valid data for <filename>pg_control</>, you can force it to proceed anyway
61+
by specifying the <literal>-f</> (force) switch. In this case plausible
62+
values will be substituted for the missing data. Most of the fields can be
63+
expected to match, but manual assistance may be needed for the next OID,
64+
next transaction ID, next multitransaction ID and offset,
65+
WAL starting address, and database locale fields.
66+
The first five of these can be set using the switches discussed below.
67+
<command>pg_resetxlog</command>'s own environment is the source for its
68+
guess at the locale fields; take care that <envar>LANG</> and so forth
69+
match the environment that <command>initdb</> was run in.
70+
If you are not able to determine correct values for all these fields,
71+
<literal>-f</> can still be used, but
7372
the recovered database must be treated with even more suspicion than
74-
usual: an immediate dump and reload is imperative. <emphasis>Do
75-
not</> execute any data-modifying operations in the database before
76-
you dump; as any such action is likely to make the corruption worse.
73+
usual: an immediate dump and reload is imperative. <emphasis>Do not</>
74+
execute any data-modifying operations in the database before you dump;
75+
as any such action is likely to make the corruption worse.
7776
</para>
7877

7978
<para>
@@ -150,11 +149,6 @@ PostgreSQL documentation
150149
</itemizedlist>
151150
</para>
152151

153-
<para>
154-
The <literal>-r</> restores <filename>pg_control</> counters listed
155-
above without resetting the write-ahead log.
156-
</para>
157-
158152
<para>
159153
The <literal>-n</> (no operation) switch instructs
160154
<command>pg_resetxlog</command> to print the values reconstructed from

0 commit comments

Comments
 (0)