Movatterモバイル変換

[0]ホーム
URL:

Skip to content

Navigation Menu

Sign in
Appearance settings

Search code, repositories, users, issues, pull requests...

Provide feedback

We read every piece of feedback, and take your input very seriously.

Saved searches

Use saved searches to filter your results more quickly

 Sign up
Appearance settings

Commitd1e9214

Browse files
committed
Add missing documentation for PGC_SU_BACKEND in description of pg_settings.
Commitfe550b2 missed updating this listof the PGC_XXX values, which in hindsight is not so surprising becausecatalogs.sgml is not a place you'd think to look for them. In addition toadding the missing doco, insert the PGC_XXX C enum names in SGML comments,so that grepping for the enum names will find this file. That might sparethe next person similar embarrassment.Spotted by Magnus Hagander.
1 parent4f1b890 commitd1e9214

File tree

1 file changed

+29
-5
lines changed

1 file changed

+29
-5
lines changed

‎doc/src/sgml/catalogs.sgml

Lines changed: 29 additions & 5 deletions
Original file line numberDiff line numberDiff line change
@@ -8833,6 +8833,7 @@ SELECT * FROM pg_locks pl LEFT JOIN pg_prepared_xacts ppx
88338833

88348834
<variablelist>
88358835
<varlistentry>
8836+
<!-- PGC_INTERNAL -->
88368837
<term><literal>internal</literal></term>
88378838
<listitem>
88388839
<para>
@@ -8844,6 +8845,7 @@ SELECT * FROM pg_locks pl LEFT JOIN pg_prepared_xacts ppx
88448845
</listitem>
88458846
</varlistentry>
88468847
<varlistentry>
8848+
<!-- PGC_POSTMASTER -->
88478849
<term><literal>postmaster</literal></term>
88488850
<listitem>
88498851
<para>
@@ -8857,6 +8859,7 @@ SELECT * FROM pg_locks pl LEFT JOIN pg_prepared_xacts ppx
88578859
</listitem>
88588860
</varlistentry>
88598861
<varlistentry>
8862+
<!-- PGC_SIGHUP -->
88608863
<term><literal>sighup</literal></term>
88618864
<listitem>
88628865
<para>
@@ -8871,23 +8874,43 @@ SELECT * FROM pg_locks pl LEFT JOIN pg_prepared_xacts ppx
88718874
</listitem>
88728875
</varlistentry>
88738876
<varlistentry>
8877+
<!-- PGC_SU_BACKEND -->
8878+
<term><literal>superuser-backend</literal></term>
8879+
<listitem>
8880+
<para>
8881+
Changes to these settings can be made in
8882+
<filename>postgresql.conf</filename> without restarting the server.
8883+
They can also be set for a particular session in the connection request
8884+
packet (for example, via <application>libpq</>'s <literal>PGOPTIONS</>
8885+
environment variable), but only if the connecting user is a superuser.
8886+
However, these settings never change in a session after it is started.
8887+
If you change them in <filename>postgresql.conf</filename>, send a
8888+
<systemitem>SIGHUP</systemitem> signal to the postmaster to cause it to
8889+
re-read <filename>postgresql.conf</filename>. The new values will only
8890+
affect subsequently-launched sessions.
8891+
</para>
8892+
</listitem>
8893+
</varlistentry>
8894+
<varlistentry>
8895+
<!-- PGC_BACKEND -->
88748896
<term><literal>backend</literal></term>
88758897
<listitem>
88768898
<para>
88778899
Changes to these settings can be made in
8878-
<filename>postgresql.conf</filename> without restarting the server;
8879-
they can also be set for a particular session in the connection request
8900+
<filename>postgresql.conf</filename> without restarting the server.
8901+
They can also be set for a particular session in the connection request
88808902
packet (for example, via <application>libpq</>'s <literal>PGOPTIONS</>
8881-
environment variable). However, these settings neverchangein a
8882-
session after it is started. If you change them in
8883-
<filename>postgresql.conf</filename>, send a
8903+
environment variable); any user can make such achangefor his session.
8904+
However, these settings never change in a session after it is started.
8905+
If you change them in<filename>postgresql.conf</filename>, send a
88848906
<systemitem>SIGHUP</systemitem> signal to the postmaster to cause it to
88858907
re-read <filename>postgresql.conf</filename>. The new values will only
88868908
affect subsequently-launched sessions.
88878909
</para>
88888910
</listitem>
88898911
</varlistentry>
88908912
<varlistentry>
8913+
<!-- PGC_SUSET -->
88918914
<term><literal>superuser</literal></term>
88928915
<listitem>
88938916
<para>
@@ -8900,6 +8923,7 @@ SELECT * FROM pg_locks pl LEFT JOIN pg_prepared_xacts ppx
89008923
</listitem>
89018924
</varlistentry>
89028925
<varlistentry>
8926+
<!-- PGC_USERSET -->
89038927
<term><literal>user</literal></term>
89048928
<listitem>
89058929
<para>

0 commit comments

Comments
 (0)
[8]ページ先頭
©2009-2025 Movatter.jp