</indexterm>
<listitem>
<para>
- Specifies the name of an additional process-id (PID) file that the
+ Specifies the name of an additional process-ID (PID) file that the
server should create for use by server administration programs.
This parameter can only be set at server start.
</para>
<xref linkend="guc-synchronous-commit"> parameter to
<literal>local</> or <literal>off</>.
</para>
+ <para>
+ This parameter can only be set in the <filename>postgresql.conf</>
+ file or on the server command line.
+ </para>
</listitem>
</varlistentry>
about queries currently executing on the standby. This parameter can
be used to eliminate query cancels caused by cleanup records, but
can cause database bloat on the primary for some workloads.
- The default value is <literal>off</literal>. Feedback messages will not
- be sent more frequently than once per <varname>wal_receiver_status_interval</>.
+ Feedback messages will not be sent more frequently than once per
+ <varname>wal_receiver_status_interval</>. The default value is
+ <literal>off</literal>. This parameter can only be set in the
+ <filename>postgresql.conf</> file or on the server command line.
</para>
</listitem>
</varlistentry>
</listitem>
</varlistentry>
- <varlistentry id="guc-silent-mode" xreflabel="silent_mode">
- <term><varname>silent_mode</varname> (<type>boolean</type>)</term>
- <indexterm>
- <primary><varname>silent_mode</> configuration parameter</primary>
- </indexterm>
- <listitem>
- <para>
- Runs the server silently. If this parameter is set, the server
- will automatically run in background and disassociate from the
- controlling terminal.
- This parameter can only be set at server start.
- </para>
-
- <caution>
- <para>
- When this parameter is set,
- the server's standard output and standard error are redirected
- to the file <filename>postmaster.log</> within the data directory.
- There is no provision for rotating this file, so it will grow
- indefinitely unless server log output is redirected elsewhere
- by other settings. It is recommended that <varname>log_destination</>
- be set to <literal>syslog</> or that <varname>logging_collector</> be
- enabled when using this option. Even with those measures, errors
- reported early during startup may appear in
- <filename>postmaster.log</> rather than the normal log destination.
- </para>
- </caution>
- </listitem>
- </varlistentry>
-
</variablelist>
</sect2>
<sect2 id="runtime-config-logging-when">
<para>
The current effective value of the search path can be examined
via the <acronym>SQL</acronym> function
- <function>current_schemas()</>. This is not quite the same as
+ <function>current_schemas</>
+ (see <xref linkend="functions-info">).
+ This is not quite the same as
examining the value of <varname>search_path</varname>, since
- <function>current_schemas()</> shows how the items
+ <function>current_schemas</> shows how the items
appearing in <varname>search_path</varname> were resolved.
</para>
practice. On a heavily loaded server you might want to raise it.
Ideally the setting should exceed your typical transaction time,
so as to improve the odds that a lock will be released before
- the waiter decides to check for deadlock.
+ the waiter decides to check for deadlock. Only superusers can change
+ this setting.
</para>
<para>