diff --git a/doc/src/sgml/catalogs.sgml b/doc/src/sgml/catalogs.sgml index 217a04e..2fc59af 100644 *** a/doc/src/sgml/catalogs.sgml --- b/doc/src/sgml/catalogs.sgml *************** *** 7117,7123 **** context text ! Context required to set the parameter's value vartype --- 7117,7124 ---- context text ! Context required to set the parameter's value. See below ! for a description of values. vartype *************** *** 7182,7187 **** --- 7183,7236 ---- + There are several possible values of context in the + pg_settings view: + + + + + internal: These settings can only be changed + at compile time or at database cluster initialization time by + initdb. + + + postmaster: Changes to these settings can only be + picked up when the server starts. These settings are typically stored + in the postgresql.conf file, or passed on the command + line when starting the postmaster. You may also change settings with a + context of sighup, + backend, superuser, or + user at server start time. + + + sighup: Changes to these settings will be + picked up by currently-running and future backends by sending a + SIGHUP signal to the postmaster. You may also + send a SIGHUP to an individual backend to cause + only that backend to reload postgresql.conf. + + + backend: Changes to these settings will be picked + up by future backend servers, but won't impact currently-active + sessions. + + + superuser: A superuser may change these settings at + any time. + + + user: Any user may change these settings + using SET, but such changes will only be picked up + in the user's session. + + + + + See Setting Parameters for the + different ways to change these parameters. + + + The pg_settings view cannot be inserted into or deleted from, but it can be updated. An UPDATE applied to a row of pg_settings is equivalent to executing