1
1
<!--
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 $
3
3
PostgreSQL documentation
4
4
-->
5
5
@@ -20,7 +20,6 @@ PostgreSQL documentation
20
20
<command>pg_resetxlog</command>
21
21
<arg>-f</arg>
22
22
<arg>-n</arg>
23
- <arg>-r</arg>
24
23
<arg>-o<replaceable class="parameter">oid</replaceable> </arg>
25
24
<arg>-x <replaceable class="parameter">xid</replaceable> </arg>
26
25
<arg>-m <replaceable class="parameter">mxid</replaceable> </arg>
@@ -58,22 +57,22 @@ PostgreSQL documentation
58
57
59
58
<para>
60
59
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
73
72
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.
77
76
</para>
78
77
79
78
<para>
@@ -150,11 +149,6 @@ PostgreSQL documentation
150
149
</itemizedlist>
151
150
</para>
152
151
153
- <para>
154
- The <literal>-r</> restores <filename>pg_control</> counters listed
155
- above without resetting the write-ahead log.
156
- </para>
157
-
158
152
<para>
159
153
The <literal>-n</> (no operation) switch instructs
160
154
<command>pg_resetxlog</command> to print the values reconstructed from
0 commit comments