🌐 AI搜索 & 代理 主页
Skip to content

Commit e45f8f8

Browse files
peterepetere
committed
Group cluster_name and update_process_title settings together
1 parent 4365d9c commit e45f8f8

File tree

4 files changed

+64
-46
lines changed

4 files changed

+64
-46
lines changed

‎doc/src/sgml/config.sgml‎

Lines changed: 54 additions & 43 deletions
Original file line numberDiff line numberDiff line change
@@ -4345,30 +4345,6 @@ local0.* /var/log/postgresql
43454345
</listitem>
43464346
</varlistentry>
43474347

4348-
<varlistentry id="guc-cluster-name" xreflabel="cluster_name">
4349-
<term><varname>cluster_name</varname> (<type>string</type>)
4350-
<indexterm>
4351-
<primary><varname>cluster_name</> configuration parameter</primary>
4352-
</indexterm>
4353-
</term>
4354-
<listitem>
4355-
<para>
4356-
Sets the cluster name that appears in the process title for all
4357-
processes in this cluster. The name can be any string of less than
4358-
<symbol>NAMEDATALEN</> characters (64 characters in a standard
4359-
build). Only printable ASCII characters may be used in the
4360-
<varname>cluster_name</varname> value. Other characters will be
4361-
replaced with question marks (<literal>?</literal>). No name is shown
4362-
if this parameter is set to the empty string <literal>''</> (which is
4363-
the default). This parameter can only be set at server start.
4364-
</para>
4365-
<para>
4366-
The process title is typically viewed using programs like
4367-
<application>ps</> or, on Windows, <application>Process Explorer</>.
4368-
</para>
4369-
</listitem>
4370-
</varlistentry>
4371-
43724348
<varlistentry>
43734349
<term><varname>debug_print_parse</varname> (<type>boolean</type>)
43744350
<indexterm>
@@ -4956,9 +4932,61 @@ COPY postgres_log FROM '/full/path/to/logfile.csv' WITH csv;
49564932
</listitem>
49574933
</orderedlist>
49584934
</para>
4959-
49604935
</sect2>
4961-
</sect1>
4936+
4937+
<sect2>
4938+
<title>Process Title</title>
4939+
4940+
<para>
4941+
These settings control how the process title as seen
4942+
by <command>ps</command> is modified. See <xref linkend="monitoring-ps">
4943+
for details.
4944+
</para>
4945+
4946+
<variablelist>
4947+
<varlistentry id="guc-cluster-name" xreflabel="cluster_name">
4948+
<term><varname>cluster_name</varname> (<type>string</type>)
4949+
<indexterm>
4950+
<primary><varname>cluster_name</> configuration parameter</primary>
4951+
</indexterm>
4952+
</term>
4953+
<listitem>
4954+
<para>
4955+
Sets the cluster name that appears in the process title for all
4956+
processes in this cluster. The name can be any string of less than
4957+
<symbol>NAMEDATALEN</> characters (64 characters in a standard
4958+
build). Only printable ASCII characters may be used in the
4959+
<varname>cluster_name</varname> value. Other characters will be
4960+
replaced with question marks (<literal>?</literal>). No name is shown
4961+
if this parameter is set to the empty string <literal>''</> (which is
4962+
the default). This parameter can only be set at server start.
4963+
</para>
4964+
<para>
4965+
The process title is typically viewed using programs like
4966+
<application>ps</> or, on Windows, <application>Process Explorer</>.
4967+
</para>
4968+
</listitem>
4969+
</varlistentry>
4970+
4971+
<varlistentry id="guc-update-process-title" xreflabel="update_process_title">
4972+
<term><varname>update_process_title</varname> (<type>boolean</type>)
4973+
<indexterm>
4974+
<primary><varname>update_process_title</> configuration parameter</primary>
4975+
</indexterm>
4976+
</term>
4977+
<listitem>
4978+
<para>
4979+
Enables updating of the process title every time a new SQL command
4980+
is received by the server. The process title is typically viewed
4981+
by the <command>ps</> command,
4982+
or in Windows by using the <application>Process Explorer</>.
4983+
Only superusers can change this setting.
4984+
</para>
4985+
</listitem>
4986+
</varlistentry>
4987+
</variablelist>
4988+
</sect2>
4989+
</sect1>
49624990

49634991
<sect1 id="runtime-config-statistics">
49644992
<title>Run-time Statistics</title>
@@ -5076,23 +5104,6 @@ COPY postgres_log FROM '/full/path/to/logfile.csv' WITH csv;
50765104
</listitem>
50775105
</varlistentry>
50785106

5079-
<varlistentry id="guc-update-process-title" xreflabel="update_process_title">
5080-
<term><varname>update_process_title</varname> (<type>boolean</type>)
5081-
<indexterm>
5082-
<primary><varname>update_process_title</> configuration parameter</primary>
5083-
</indexterm>
5084-
</term>
5085-
<listitem>
5086-
<para>
5087-
Enables updating of the process title every time a new SQL command
5088-
is received by the server. The process title is typically viewed
5089-
by the <command>ps</> command,
5090-
or in Windows by using the <application>Process Explorer</>.
5091-
Only superusers can change this setting.
5092-
</para>
5093-
</listitem>
5094-
</varlistentry>
5095-
50965107
<varlistentry id="guc-stats-temp-directory" xreflabel="stats_temp_directory">
50975108
<term><varname>stats_temp_directory</varname> (<type>string</type>)
50985109
<indexterm>

‎src/backend/utils/misc/guc.c‎

Lines changed: 4 additions & 2 deletions
Original file line numberDiff line numberDiff line change
@@ -581,6 +581,8 @@ const char *const config_group_names[] =
581581
gettext_noop("Reporting and Logging / When to Log"),
582582
/* LOGGING_WHAT */
583583
gettext_noop("Reporting and Logging / What to Log"),
584+
/* PROCESS_TITLE */
585+
gettext_noop("Process Title"),
584586
/* STATS */
585587
gettext_noop("Statistics"),
586588
/* STATS_MONITORING */
@@ -1181,7 +1183,7 @@ static struct config_bool ConfigureNamesBool[] =
11811183
},
11821184

11831185
{
1184-
{"update_process_title", PGC_SUSET, STATS_COLLECTOR,
1186+
{"update_process_title", PGC_SUSET, PROCESS_TITLE,
11851187
gettext_noop("Updates the process title to show the active SQL command."),
11861188
gettext_noop("Enables updating of the process title every time a new SQL command is received by the server.")
11871189
},
@@ -3366,7 +3368,7 @@ static struct config_string ConfigureNamesString[] =
33663368
},
33673369

33683370
{
3369-
{"cluster_name", PGC_POSTMASTER, LOGGING_WHAT,
3371+
{"cluster_name", PGC_POSTMASTER, PROCESS_TITLE,
33703372
gettext_noop("Sets the name of the cluster which is included in the process title."),
33713373
NULL,
33723374
GUC_IS_NAME

‎src/backend/utils/misc/postgresql.conf.sample‎

Lines changed: 5 additions & 1 deletion
Original file line numberDiff line numberDiff line change
@@ -443,8 +443,13 @@
443443
# than the specified size in kilobytes;
444444
# -1 disables, 0 logs all temp files
445445
#log_timezone = 'GMT'
446+
447+
448+
# - Process Title -
449+
446450
#cluster_name = '' # added to process titles if nonempty
447451
# (change requires restart)
452+
#update_process_title = on
448453

449454

450455
#------------------------------------------------------------------------------
@@ -458,7 +463,6 @@
458463
#track_io_timing = off
459464
#track_functions = none # none, pl, all
460465
#track_activity_query_size = 1024 # (change requires restart)
461-
#update_process_title = on
462466
#stats_temp_directory = 'pg_stat_tmp'
463467

464468

‎src/include/utils/guc_tables.h‎

Lines changed: 1 addition & 0 deletions
Original file line numberDiff line numberDiff line change
@@ -81,6 +81,7 @@ enum config_group
8181
LOGGING_WHERE,
8282
LOGGING_WHEN,
8383
LOGGING_WHAT,
84+
PROCESS_TITLE,
8485
STATS,
8586
STATS_MONITORING,
8687
STATS_COLLECTOR,

0 commit comments

Comments
 (0)