Commitf08b5e7

committed

pg_is_xlog_replay_paused(): remove super-user-only restriction

Also update docs to mention which function are super-user-only.Report by sys-milan@statpro.comBackpatch through 9.4

1 parent08bff29 commitf08b5e7Copy full SHA for f08b5e7

File tree

-8

lines changed

-8

lines changed

Lines changed: 3 additions & 3 deletions

Original file line number	Diff line number	Diff line change
`@@ -16469,15 +16469,15 @@ postgres=# SELECT * FROM pg_xlogfile_name_offset(pg_stop_backup());`
`16469`	`16469`	`<literal><function>pg_xlog_replay_pause()</function></literal>`
`16470`	`16470`	`</entry>`
`16471`	`16471`	`<entry><type>void</type></entry>`
`16472`		`- <entry>Pauses recovery immediately.`
	`16472`	`+ <entry>Pauses recovery immediately (restricted to superusers).`
`16473`	`16473`	`</entry>`
`16474`	`16474`	`</row>`
`16475`	`16475`	`<row>`
`16476`	`16476`	`<entry>`
`16477`	`16477`	`<literal><function>pg_xlog_replay_resume()</function></literal>`
`16478`	`16478`	`</entry>`
`16479`	`16479`	`<entry><type>void</type></entry>`
`16480`		`- <entry>Restarts recovery if it was paused.`
	`16480`	`+ <entry>Restarts recovery if it was paused (restricted to superusers).`
`16481`	`16481`	`</entry>`
`16482`	`16482`	`</row>`
`16483`	`16483`	`</tbody>`
`@@ -16585,7 +16585,7 @@ postgres=# SELECT * FROM pg_xlogfile_name_offset(pg_stop_backup());`
`16585`	`16585`	`for controlling and interacting with replication features.`
`16586`	`16586`	`See <xref linkend="streaming-replication">`
`16587`	`16587`	`and <xref linkend="streaming-replication-slots"> for information about the`
`16588`		`- underlying features.`
	`16588`	`+ underlying features. Use of these functions is restricted to superusers.`
`16589`	`16589`	`</para>`
`16590`	`16590`
`16591`	`16591`	`<para>`

Lines changed: 0 additions & 5 deletions

Original file line number	Diff line number	Diff line change
`@@ -382,11 +382,6 @@ pg_xlog_replay_resume(PG_FUNCTION_ARGS)`
`382`	`382`	`Datum`
`383`	`383`	`pg_is_xlog_replay_paused(PG_FUNCTION_ARGS)`
`384`	`384`	`{`
`385`		`-if (!superuser())`
`386`		`-ereport(ERROR,`
`387`		`-(errcode(ERRCODE_INSUFFICIENT_PRIVILEGE),`
`388`		`- (errmsg("must be superuser to control recovery"))));`
`389`		`-`
`390`	`385`	`if (!RecoveryInProgress())`
`391`	`386`	`ereport(ERROR,`
`392`	`387`	`(errcode(ERRCODE_OBJECT_NOT_IN_PREREQUISITE_STATE),`

Comments

(0)