diff options
author | Tom Lane <tgl@sss.pgh.pa.us> | 2015-03-15 12:45:35 -0400 |
---|---|---|
committer | Tom Lane <tgl@sss.pgh.pa.us> | 2015-03-15 12:45:43 -0400 |
commit | d1e9214e4ff5604357d0155467f105825a9e102c (patch) | |
tree | 053762647d31339b50faecc03c0f16d91c1487eb | |
parent | 4f1b890b1377744688e43218f975d3c8b2ae39f8 (diff) | |
download | postgresql-d1e9214e4ff5604357d0155467f105825a9e102c.tar.gz postgresql-d1e9214e4ff5604357d0155467f105825a9e102c.zip |
Add missing documentation for PGC_SU_BACKEND in description of pg_settings.
Commit fe550b2ac249af5fbd8e9e19290a4ba43c882f2d missed updating this list
of the PGC_XXX values, which in hindsight is not so surprising because
catalogs.sgml is not a place you'd think to look for them. In addition to
adding 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 spare
the next person similar embarrassment.
Spotted by Magnus Hagander.
-rw-r--r-- | doc/src/sgml/catalogs.sgml | 34 |
1 files changed, 29 insertions, 5 deletions
diff --git a/doc/src/sgml/catalogs.sgml b/doc/src/sgml/catalogs.sgml index 2325962e818..dfed546f513 100644 --- a/doc/src/sgml/catalogs.sgml +++ b/doc/src/sgml/catalogs.sgml @@ -8833,6 +8833,7 @@ SELECT * FROM pg_locks pl LEFT JOIN pg_prepared_xacts ppx <variablelist> <varlistentry> + <!-- PGC_INTERNAL --> <term><literal>internal</literal></term> <listitem> <para> @@ -8844,6 +8845,7 @@ SELECT * FROM pg_locks pl LEFT JOIN pg_prepared_xacts ppx </listitem> </varlistentry> <varlistentry> + <!-- PGC_POSTMASTER --> <term><literal>postmaster</literal></term> <listitem> <para> @@ -8857,6 +8859,7 @@ SELECT * FROM pg_locks pl LEFT JOIN pg_prepared_xacts ppx </listitem> </varlistentry> <varlistentry> + <!-- PGC_SIGHUP --> <term><literal>sighup</literal></term> <listitem> <para> @@ -8871,16 +8874,35 @@ SELECT * FROM pg_locks pl LEFT JOIN pg_prepared_xacts ppx </listitem> </varlistentry> <varlistentry> + <!-- PGC_SU_BACKEND --> + <term><literal>superuser-backend</literal></term> + <listitem> + <para> + Changes to these settings can be made in + <filename>postgresql.conf</filename> without restarting the server. + They can also be set for a particular session in the connection request + packet (for example, via <application>libpq</>'s <literal>PGOPTIONS</> + environment variable), but only if the connecting user is a superuser. + However, these settings never change in a session after it is started. + If you change them in <filename>postgresql.conf</filename>, send a + <systemitem>SIGHUP</systemitem> signal to the postmaster to cause it to + re-read <filename>postgresql.conf</filename>. The new values will only + affect subsequently-launched sessions. + </para> + </listitem> + </varlistentry> + <varlistentry> + <!-- PGC_BACKEND --> <term><literal>backend</literal></term> <listitem> <para> Changes to these settings can be made in - <filename>postgresql.conf</filename> without restarting the server; - they can also be set for a particular session in the connection request + <filename>postgresql.conf</filename> without restarting the server. + They can also be set for a particular session in the connection request packet (for example, via <application>libpq</>'s <literal>PGOPTIONS</> - environment variable). However, these settings never change in a - session after it is started. If you change them in - <filename>postgresql.conf</filename>, send a + environment variable); any user can make such a change for his session. + However, these settings never change in a session after it is started. + If you change them in <filename>postgresql.conf</filename>, send a <systemitem>SIGHUP</systemitem> signal to the postmaster to cause it to re-read <filename>postgresql.conf</filename>. The new values will only affect subsequently-launched sessions. @@ -8888,6 +8910,7 @@ SELECT * FROM pg_locks pl LEFT JOIN pg_prepared_xacts ppx </listitem> </varlistentry> <varlistentry> + <!-- PGC_SUSET --> <term><literal>superuser</literal></term> <listitem> <para> @@ -8900,6 +8923,7 @@ SELECT * FROM pg_locks pl LEFT JOIN pg_prepared_xacts ppx </listitem> </varlistentry> <varlistentry> + <!-- PGC_USERSET --> <term><literal>user</literal></term> <listitem> <para> |