Commit84abea7

committed

Add pause_at_recovery_target to recovery.conf.sample; improve docs.

Fujii Masao, but with the proposed behavior change reverted, and therest adjusted accordingly.

1 parent9a56dc3 commit84abea7Copy full SHA for 84abea7

File tree

+13

-1

lines changed

+13

-1

lines changed

Lines changed: 5 additions & 1 deletion

Original file line number	Diff line number	Diff line change
`@@ -261,7 +261,7 @@ restore_command = 'copy "C:\\server\\archivedir\\%f" "%p"' # Windows`
`261`	`261`	`<listitem>`
`262`	`262`	`<para>`
`263`	`263`	`Specifies whether recovery should pause when the recovery target`
`264`		`- is reached. The default is true, if a recovery target is set.`
	`264`	`+ is reached. The default is true.`
`265`	`265`	`This is intended to allow queries to be executed against the`
`266`	`266`	`database to check if this recovery target is the most desirable`
`267`	`267`	`point for recovery. The paused state can be resumed by using`
`@@ -272,6 +272,10 @@ restore_command = 'copy "C:\\server\\archivedir\\%f" "%p"' # Windows`
`272`	`272`	`recovery target settings to a later target and restart to`
`273`	`273`	`continue recovery.`
`274`	`274`	`</para>`
	`275`	`+ <para>`
	`276`	`+ This setting has no effect if <xref linkend="guc-hot-standby"> is not`
	`277`	`+ enabled, or if no recovery target is set.`
	`278`	`+ </para>`
`275`	`279`	`</listitem>`
`276`	`280`	`</varlistentry>`
`277`	`281`

Lines changed: 8 additions & 0 deletions

Original file line number	Diff line number	Diff line change
`@@ -87,6 +87,14 @@`
`87`	`87`	`#`
`88`	`88`	`#recovery_target_timeline = 'latest'`
`89`	`89`	`#`
	`90`	`+#`
	`91`	`+# If pause_at_recovery_target is enabled, recovery will pause when`
	`92`	`+# the recovery target is reached. The pause state will continue until`
	`93`	`+# pg_xlog_replay_resume() is called. This setting has no effect if`
	`94`	`+# hot standby is not enabled, or if no recovery target is set.`
	`95`	`+#`
	`96`	`+#pause_at_recovery_target = true`
	`97`	`+#`
`90`	`98`	`#---------------------------------------------------------------------------`
`91`	`99`	`# STANDBY SERVER PARAMETERS`
`92`	`100`	`#---------------------------------------------------------------------------`

Comments

(0)