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 /doc/src | |
| parent | 4f1b890b1377744688e43218f975d3c8b2ae39f8 (diff) | |
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.
Diffstat (limited to 'doc/src')
| -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> |
