@@ -152,16 +152,18 @@ restore_command = 'copy "C:\\server\\archivedir\\%f" "%p"' # Windows
152
152
<sect1 id="recovery-target-settings">
153
153
154
154
<title>Recovery Target Settings</title>
155
+
155
156
<para>
156
157
By default, recovery will recover to the end of the WAL log. The
157
158
following parameters can be used to specify an earlier stopping point.
158
159
At most one of <varname>recovery_target</>,
159
160
<varname>recovery_target_name</>, <varname>recovery_target_time</>, or
160
- <varname>recovery_target_xid</> can be specified.
161
+ <varname>recovery_target_xid</> can be used; if more than one of these
162
+ is specified in the configuration file, the last entry will be used.
161
163
</para>
162
- <variablelist>
163
164
164
- <varlistentry id="recovery-target" xreflabel="recovery_target_name">
165
+ <variablelist>
166
+ <varlistentry id="recovery-target" xreflabel="recovery_target">
165
167
<term><varname>recovery_target</varname><literal> = 'immediate'</literal>
166
168
<indexterm>
167
169
<primary><varname>recovery_target</> recovery parameter</primary>
@@ -189,8 +191,8 @@ restore_command = 'copy "C:\\server\\archivedir\\%f" "%p"' # Windows
189
191
</term>
190
192
<listitem>
191
193
<para>
192
- This parameter specifies the named restore point, created with
193
- <function>pg_create_restore_point()</> to which recovery will proceed.
194
+ This parameter specifies the named restore point ( created with
195
+ <function>pg_create_restore_point()</>) to which recovery will proceed.
194
196
</para>
195
197
</listitem>
196
198
</varlistentry>
@@ -231,13 +233,13 @@ restore_command = 'copy "C:\\server\\archivedir\\%f" "%p"' # Windows
231
233
</listitem>
232
234
</varlistentry>
233
235
</variablelist>
236
+
234
237
<para>
235
238
The following options further specify the recovery target, and affect
236
239
what happens when the target is reached:
237
240
</para>
238
241
239
242
<variablelist>
240
-
241
243
<varlistentry id="recovery-target-inclusive"
242
244
xreflabel="recovery_target_inclusive">
243
245
<term><varname>recovery_target_inclusive</varname> (<type>boolean</type>)
@@ -247,12 +249,12 @@ restore_command = 'copy "C:\\server\\archivedir\\%f" "%p"' # Windows
247
249
</term>
248
250
<listitem>
249
251
<para>
250
- Specifies whether we stop just after the specified recovery target
252
+ Specifies whether to stop just after the specified recovery target
251
253
(<literal>true</literal>), or just before the recovery target
252
254
(<literal>false</literal>).
253
- Applies to both <xref linkend="recovery-target-time">
254
- and <xref linkend="recovery-target-xid">, whichever one is
255
- specified for this recovery. This indicates whether transactions
255
+ Applies when either <xref linkend="recovery-target-time">
256
+ or <xref linkend="recovery-target-xid"> is specified.
257
+ This setting controls whether transactions
256
258
having exactly the target commit time or ID, respectively, will
257
259
be included in the recovery. Default is <literal>true</>.
258
260
</para>
@@ -294,10 +296,10 @@ restore_command = 'copy "C:\\server\\archivedir\\%f" "%p"' # Windows
294
296
This is intended to allow queries to be executed against the
295
297
database to check if this recovery target is the most desirable
296
298
point for recovery. The paused state can be resumed by using
297
- <function>pg_xlog_replay_resume()</> (See
299
+ <function>pg_xlog_replay_resume()</> (see
298
300
<xref linkend="functions-recovery-control-table">), which then
299
301
causes recovery to end. If this recovery target is not the
300
- desired stopping point, then shutdown the server, change the
302
+ desired stopping point, then shut down the server, change the
301
303
recovery target settings to a later target and restart to
302
304
continue recovery.
303
305
</para>
0 commit comments