Commit01363be

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 parent88231ec commit01363beCopy full SHA for 01363be

File tree

-8

lines changed

-8

lines changed

Lines changed: 3 additions & 3 deletions

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