Movatterモバイル変換

[0]ホーム
URL:

Skip to content

Navigation Menu

Sign in
Appearance settings

Search code, repositories, users, issues, pull requests...

Provide feedback

We read every piece of feedback, and take your input very seriously.

Saved searches

Use saved searches to filter your results more quickly

 Sign up
Appearance settings

Commit86c23a6

Browse files
committed
Make all command-line options of postmaster and postgres the same. See
http://archives.postgresql.org/pgsql-hackers/2006-01/msg00151.php for thecomplete plan.
1 parent4e1712e commit86c23a6

File tree

15 files changed

+599
-548
lines changed

15 files changed

+599
-548
lines changed

‎doc/src/sgml/config.sgml

Lines changed: 92 additions & 45 deletions
Original file line numberDiff line numberDiff line change
@@ -1,5 +1,5 @@
11
<!--
2-
$PostgreSQL: pgsql/doc/src/sgml/config.sgml,v 1.41 2005/12/27 23:54:01 adunstan Exp $
2+
$PostgreSQL: pgsql/doc/src/sgml/config.sgml,v 1.42 2006/01/05 10:07:44 petere Exp $
33
-->
44
<chapter Id="runtime-config">
55
<title>Server Configuration</title>
@@ -2407,8 +2407,7 @@ SELECT * FROM parent WHERE key = 2400;
24072407
<para>
24082408
Runs the server silently. If this option is set, the server
24092409
will automatically run in background and any controlling
2410-
terminals are disassociated (same effect as
2411-
<command>postmaster</>'s <option>-S</option> option).
2410+
terminals are disassociated.
24122411
The server's standard output and standard error are redirected
24132412
to <literal>/dev/null</>, so any messages sent to them will be lost.
24142413
Unless <application>syslog</> logging is selected or
@@ -4054,6 +4053,19 @@ plruby.use_strict = true # generates error: unknown class name
40544053
</para>
40554054

40564055
<variablelist>
4056+
<varlistentry id="guc-allow-system-table-mods" xreflabel="allow_system_table_mods">
4057+
<term><varname>allow_system_table_mods</varname> (<type>boolean</type>)</term>
4058+
<indexterm>
4059+
<primary><varname>allow_system_table_mods</varname> configuration parameter</primary>
4060+
</indexterm>
4061+
<listitem>
4062+
<para>
4063+
Allows the modification of the structure of system tables.
4064+
This is used by <command>initdb</command>.
4065+
</para>
4066+
</listitem>
4067+
</varlistentry>
4068+
40574069
<varlistentry id="guc-debug-assertions" xreflabel="debug_assertions">
40584070
<term><varname>debug_assertions</varname> (<type>boolean</type>)</term>
40594071
<indexterm>
@@ -4075,18 +4087,47 @@ plruby.use_strict = true # generates error: unknown class name
40754087
</listitem>
40764088
</varlistentry>
40774089

4090+
<varlistentry id="guc-ignore-system-indexes" xreflabel="ignore_system_indexes">
4091+
<term><varname>ignore_system_indexes</varname> (<type>boolean</type>)</term>
4092+
<indexterm>
4093+
<primary><varname>ignore_system_indexes</varname> configuration parameter</primary>
4094+
</indexterm>
4095+
<listitem>
4096+
<para>
4097+
Ignore system indexes when reading system tables (but still
4098+
update the indexes when modifying the tables). This is useful
4099+
when recovering from damaged system indexes.
4100+
</para>
4101+
</listitem>
4102+
</varlistentry>
4103+
4104+
<varlistentry id="guc-post-auth-delay" xreflabel="post_auth_delay">
4105+
<term><varname>post_auth_delay</varname> (<type>integer</type>)</term>
4106+
<indexterm>
4107+
<primary><varname>post_auth_delay</> configuration parameter</primary>
4108+
</indexterm>
4109+
<listitem>
4110+
<para>
4111+
If nonzero, a delay of this many seconds occurs when a new
4112+
server process is started, after it conducts the
4113+
authentication procedure. This is intended to give an
4114+
opportunity to attach to the server process with a debugger.
4115+
</para>
4116+
</listitem>
4117+
</varlistentry>
4118+
40784119
<varlistentry id="guc-pre-auth-delay" xreflabel="pre_auth_delay">
40794120
<term><varname>pre_auth_delay</varname> (<type>integer</type>)</term>
40804121
<indexterm>
40814122
<primary><varname>pre_auth_delay</> configuration parameter</primary>
40824123
</indexterm>
40834124
<listitem>
40844125
<para>
4085-
If nonzero, a delay of this many seconds occurs just after a new
4086-
server process is forked, before it conducts the authentication
4087-
process. This is intended to give an opportunity to attach to the
4088-
server process with a debugger to trace down misbehavior in
4089-
authentication.
4126+
If nonzero, a delay of this many seconds occurs just after a
4127+
newserver process is forked, before it conducts the
4128+
authentication procedure. This is intended to give an
4129+
opportunity to attach to theserver process with a debugger to
4130+
trace down misbehavior inauthentication.
40904131
</para>
40914132
</listitem>
40924133
</varlistentry>
@@ -4182,9 +4223,12 @@ plruby.use_strict = true # generates error: unknown class name
41824223
<title>Short Options</title>
41834224

41844225
<para>
4185-
For convenience there are also single letter command-line option switches
4186-
available for some parameters. They are described in <xref
4187-
linkend="runtime-config-short-table">.
4226+
For convenience there are also single letter command-line option
4227+
switches available for some parameters. They are described in
4228+
<xref linkend="runtime-config-short-table">. Some of these
4229+
options exist for historical reasons, and their presence as a
4230+
single-letter option does not necessarily indicate an endorsement
4231+
to use the option heavily.
41884232
</para>
41894233

41904234
<table id="runtime-config-short-table">
@@ -4198,6 +4242,10 @@ plruby.use_strict = true # generates error: unknown class name
41984242
</thead>
41994243

42004244
<tbody>
4245+
<row>
4246+
<entry><option>-A <replaceable>x</replaceable></option></entry>
4247+
<entry><literal>debug_assertions = <replaceable>x</replaceable></></entry>
4248+
</row>
42014249
<row>
42024250
<entry><option>-B <replaceable>x</replaceable></option></entry>
42034251
<entry><literal>shared_buffers = <replaceable>x</replaceable></></entry>
@@ -4206,6 +4254,26 @@ plruby.use_strict = true # generates error: unknown class name
42064254
<entry><option>-d <replaceable>x</replaceable></option></entry>
42074255
<entry><literal>log_min_messages = DEBUG<replaceable>x</replaceable></></entry>
42084256
</row>
4257+
<row>
4258+
<entry><option>-e</option></entry>
4259+
<entry><literal>datestyle = euro</></entry>
4260+
</row>
4261+
<row>
4262+
<entry>
4263+
<option>-fb</option>, <option>-fh</option>, <option>-fi</option>,
4264+
<option>-fm</option>, <option>-fn</option>,
4265+
<option>-fs</option>, <option>-ft</option>
4266+
</entry>
4267+
<entry>
4268+
<literal>enable_bitmapscan = off</>,
4269+
<literal>enable_hashjoin = off</>,
4270+
<literal>enable_indexscan = off</>,
4271+
<literal>enable_mergejoin = off</>,
4272+
<literal>enable_nestloop = off</>,
4273+
<literal>enable_seqscan = off</>,
4274+
<literal>enable_tidscan = off</>
4275+
</entry>
4276+
</row>
42094277
<row>
42104278
<entry><option>-F</option></entry>
42114279
<entry><literal>fsync = off</></entry>
@@ -4230,57 +4298,36 @@ plruby.use_strict = true # generates error: unknown class name
42304298
<entry><option>-N <replaceable>x</replaceable></option></entry>
42314299
<entry><literal>max_connections = <replaceable>x</replaceable></></entry>
42324300
</row>
4301+
<row>
4302+
<entry><option>-O</option></entry>
4303+
<entry><literal>allow_system_table_mods = on</></entry>
4304+
</row>
42334305
<row>
42344306
<entry><option>-p <replaceable>x</replaceable></option></entry>
42354307
<entry><literal>port = <replaceable>x</replaceable></></entry>
42364308
</row>
4237-
42384309
<row>
4239-
<entry>
4240-
<option>-fb</option>, <option>-fh</option>, <option>-fi</option>,
4241-
<option>-fm</option>, <option>-fn</option>,
4242-
<option>-fs</option>, <option>-ft</option><footnote
4243-
id="fn.runtime-config-short">
4244-
<para>
4245-
For historical reasons, these options must be passed to
4246-
the individual server process via the <option>-o</option>
4247-
<command>postmaster</command> option, for example,
4248-
<screen>
4249-
$ <userinput>postmaster -o '-S 1024 -s'</userinput>
4250-
</screen>
4251-
or via <envar>PGOPTIONS</envar> from the client side, as
4252-
explained above.
4253-
</para>
4254-
</footnote>
4255-
</entry>
4256-
<entry>
4257-
<literal>enable_bitmapscan = off</>,
4258-
<literal>enable_hashjoin = off</>,
4259-
<literal>enable_indexscan = off</>,
4260-
<literal>enable_mergejoin = off</>,
4261-
<literal>enable_nestloop = off</>,
4262-
<literal>enable_seqscan = off</>,
4263-
<literal>enable_tidscan = off</>
4264-
</entry>
4310+
<entry><option>-P</option></entry>
4311+
<entry><literal>ignore_system_indexes = on</></entry>
42654312
</row>
4266-
42674313
<row>
4268-
<entry><option>-s</option><footnoteref linkend="fn.runtime-config-short"></entry>
4314+
<entry><option>-s</option></entry>
42694315
<entry><literal>log_statement_stats = on</></entry>
42704316
</row>
4271-
42724317
<row>
4273-
<entry><option>-S <replaceable>x</replaceable></option><footnoteref linkend="fn.runtime-config-short">
4274-
</entry>
4318+
<entry><option>-S <replaceable>x</replaceable></option></entry>
42754319
<entry><literal>work_mem = <replaceable>x</replaceable></></entry>
42764320
</row>
4277-
42784321
<row>
4279-
<entry><option>-tpa</option>, <option>-tpl</option>, <option>-te</option><footnoteref linkend="fn.runtime-config-short"></entry>
4322+
<entry><option>-tpa</option>, <option>-tpl</option>, <option>-te</option></entry>
42804323
<entry><literal>log_parser_stats = on</>,
42814324
<literal>log_planner_stats = on</>,
42824325
<literal>log_executor_stats = on</></entry>
42834326
</row>
4327+
<row>
4328+
<entry><option>-W <replaceable>x</replaceable></option></entry>
4329+
<entry><literal>post_auth_delay = <replaceable>x</replaceable></></entry>
4330+
</row>
42844331
</tbody>
42854332
</tgroup>
42864333
</table>

0 commit comments

Comments
 (0)
[8]ページ先頭
©2009-2025 Movatter.jp