diff options
| author | Tatsuo Ishii | 2025-03-05 10:55:11 +0000 |
|---|---|---|
| committer | Tatsuo Ishii | 2025-03-05 10:55:11 +0000 |
| commit | 7596f86e2f414e6fcb57db11d314222b7f440b5a (patch) | |
| tree | 6cd31b6785fb51d744ea47838aa4a938b23957b4 /doc/src | |
| parent | d067a8b14c607e54e55539356cb14121826f1f2b (diff) | |
Doc: enhance the explanation on sr_check_user.
It must be a superuser or in the pg_monitor group.
Backpatch-through: v4.2.
Diffstat (limited to 'doc/src')
| -rw-r--r-- | doc/src/sgml/stream-check.sgml | 17 |
1 files changed, 17 insertions, 0 deletions
diff --git a/doc/src/sgml/stream-check.sgml b/doc/src/sgml/stream-check.sgml index e44dae93f..8515b6510 100644 --- a/doc/src/sgml/stream-check.sgml +++ b/doc/src/sgml/stream-check.sgml @@ -52,6 +52,23 @@ Default is <literal>''</literal>(empty). The user must have LOGIN privilege and exist on all the <productname>PostgreSQL</> backends. + Moreover the user must be a <productname>PostgreSQL</productname> + super user or in "pg_monitor" group. + <note> + <para> + To make <xref linkend="guc-sr-check-user"> in pg_monitor + group, execute following SQL command + by <productname>PostgreSQL</productname> super user (replace + "sr_check_user" with the setting of <xref linkend="guc-sr-check-user">): + <programlisting> +GRANT pg_monitor TO sr_check_user; + </programlisting> + For <productname>PostgreSQL</productname> 9.6, there's no + pg_monitor group and <xref linkend="guc-sr-check-user"> must + be <productname>PostgreSQL</productname> super user. + </para> + </note> + </para> <para> If <link linkend="runtime-ssl">SSL</link> is enabled, the |