aboutsummaryrefslogtreecommitdiff
diff options
context:
space:
mode:
authorTom Lane <tgl@sss.pgh.pa.us>2015-03-15 12:45:35 -0400
committerTom Lane <tgl@sss.pgh.pa.us>2015-03-15 12:45:43 -0400
commitd1e9214e4ff5604357d0155467f105825a9e102c (patch)
tree053762647d31339b50faecc03c0f16d91c1487eb
parent4f1b890b1377744688e43218f975d3c8b2ae39f8 (diff)
downloadpostgresql-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.sgml34
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>