Baoding-FenShuaJiang
/
Green_GoodERP18_FSJ_Standard
보기 1
좋아요 0
위키 捐赠
gooderp18绿色标准版
You can not select more than 25 topics Topics must start with a letter or number, can include dashes ('-') and can be up to 35 characters long.
브렌치: master
브랜치 태그
${ item.name }
Create branch ${ searchTerm }
from 'master'
${ noResults }
Green_GoodERP18_FSJ_Standard/PostgreSQL/doc/postgresql/html/runtime-config-preset.html

126 lines
12KB
Raw 고유링크 Blame 히스토리 

  1. <?xml version="1.0" encoding="UTF-8" standalone="no"?>

  2. <!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd"><html xmlns="http://www.w3.org/1999/xhtml"><head><meta http-equiv="Content-Type" content="text/html; charset=UTF-8" /><title>19.15. Preset Options</title><link rel="stylesheet" type="text/css" href="stylesheet.css" /><link rev="made" href="pgsql-docs@lists.postgresql.org" /><meta name="generator" content="DocBook XSL Stylesheets V1.79.1" /><link rel="prev" href="runtime-config-error-handling.html" title="19.14. Error Handling" /><link rel="next" href="runtime-config-custom.html" title="19.16. Customized Options" /></head><body><div xmlns="http://www.w3.org/TR/xhtml1/transitional" class="navheader"><table width="100%" summary="Navigation header"><tr><th colspan="5" align="center">19.15. Preset Options</th></tr><tr><td width="10%" align="left"><a accesskey="p" href="runtime-config-error-handling.html" title="19.14. Error Handling">Prev</a> </td><td width="10%" align="left"><a accesskey="u" href="runtime-config.html" title="Chapter 19. Server Configuration">Up</a></td><th width="60%" align="center">Chapter 19. Server Configuration</th><td width="10%" align="right"><a accesskey="h" href="index.html" title="PostgreSQL 12.4 Documentation">Home</a></td><td width="10%" align="right"> <a accesskey="n" href="runtime-config-custom.html" title="19.16. Customized Options">Next</a></td></tr></table><hr></hr></div><div class="sect1" id="RUNTIME-CONFIG-PRESET"><div class="titlepage"><div><div><h2 class="title" style="clear: both">19.15. Preset Options</h2></div></div></div><p>

  3.      The following <span class="quote">“<span class="quote">parameters</span>”</span> are read-only, and are determined

  4.      when <span class="productname">PostgreSQL</span> is compiled or when it is

  5.      installed. As such, they have been excluded from the sample

  6.      <code class="filename">postgresql.conf</code> file.  These options report

  7.      various aspects of <span class="productname">PostgreSQL</span> behavior

  8.      that might be of interest to certain applications, particularly

  9.      administrative front-ends.

  10.     </p><div class="variablelist"><dl class="variablelist"><dt id="GUC-BLOCK-SIZE"><span class="term"><code class="varname">block_size</code> (<code class="type">integer</code>)

  11.       <a id="id-1.6.6.18.3.1.1.3" class="indexterm"></a>

  12.       </span></dt><dd><p>

  13.         Reports the size of a disk block.  It is determined by the value

  14.         of <code class="literal">BLCKSZ</code> when building the server. The default

  15.         value is 8192 bytes.  The meaning of some configuration

  16.         variables (such as <a class="xref" href="runtime-config-resource.html#GUC-SHARED-BUFFERS">shared_buffers</a>) is

  17.         influenced by <code class="varname">block_size</code>. See <a class="xref" href="runtime-config-resource.html" title="19.4. Resource Consumption">Section 19.4</a> for information.

  18.        </p></dd><dt id="GUC-DATA-CHECKSUMS"><span class="term"><code class="varname">data_checksums</code> (<code class="type">boolean</code>)

  19.       <a id="id-1.6.6.18.3.2.1.3" class="indexterm"></a>

  20.       </span></dt><dd><p>

  21.         Reports whether data checksums are enabled for this cluster.

  22.         See <a class="xref" href="app-initdb.html#APP-INITDB-DATA-CHECKSUMS">data checksums</a> for more information.

  23.        </p></dd><dt id="GUC-DATA-DIRECTORY-MODE"><span class="term"><code class="varname">data_directory_mode</code> (<code class="type">integer</code>)

  24.       <a id="id-1.6.6.18.3.3.1.3" class="indexterm"></a>

  25.       </span></dt><dd><p>

  26.         On Unix systems this parameter reports the permissions of the data

  27.         directory defined by (<a class="xref" href="runtime-config-file-locations.html#GUC-DATA-DIRECTORY">data_directory</a>) at startup.

  28.         (On Microsoft Windows this parameter will always display

  29.         <code class="literal">0700</code>). See

  30.         <a class="xref" href="app-initdb.html#APP-INITDB-ALLOW-GROUP-ACCESS">group access</a> for more information.

  31.        </p></dd><dt id="GUC-DEBUG-ASSERTIONS"><span class="term"><code class="varname">debug_assertions</code> (<code class="type">boolean</code>)

  32.       <a id="id-1.6.6.18.3.4.1.3" class="indexterm"></a>

  33.       </span></dt><dd><p>

  34.         Reports whether <span class="productname">PostgreSQL</span> has been built

  35.         with assertions enabled. That is the case if the

  36.         macro <code class="symbol">USE_ASSERT_CHECKING</code> is defined

  37.         when <span class="productname">PostgreSQL</span> is built (accomplished

  38.         e.g. by the <code class="command">configure</code> option

  39.         <code class="option">--enable-cassert</code>). By

  40.         default <span class="productname">PostgreSQL</span> is built without

  41.         assertions.

  42.        </p></dd><dt id="GUC-INTEGER-DATETIMES"><span class="term"><code class="varname">integer_datetimes</code> (<code class="type">boolean</code>)

  43.       <a id="id-1.6.6.18.3.5.1.3" class="indexterm"></a>

  44.       </span></dt><dd><p>

  45.         Reports whether <span class="productname">PostgreSQL</span> was built with support for

  46.         64-bit-integer dates and times.  As of <span class="productname">PostgreSQL</span> 10,

  47.         this is always <code class="literal">on</code>.

  48.        </p></dd><dt id="GUC-LC-COLLATE"><span class="term"><code class="varname">lc_collate</code> (<code class="type">string</code>)

  49.       <a id="id-1.6.6.18.3.6.1.3" class="indexterm"></a>

  50.       </span></dt><dd><p>

  51.         Reports the locale in which sorting of textual data is done.

  52.         See <a class="xref" href="locale.html" title="23.1. Locale Support">Section 23.1</a> for more information.

  53.         This value is determined when a database is created.

  54.        </p></dd><dt id="GUC-LC-CTYPE"><span class="term"><code class="varname">lc_ctype</code> (<code class="type">string</code>)

  55.       <a id="id-1.6.6.18.3.7.1.3" class="indexterm"></a>

  56.       </span></dt><dd><p>

  57.         Reports the locale that determines character classifications.

  58.         See <a class="xref" href="locale.html" title="23.1. Locale Support">Section 23.1</a> for more information.

  59.         This value is determined when a database is created.

  60.         Ordinarily this will be the same as <code class="varname">lc_collate</code>,

  61.         but for special applications it might be set differently.

  62.        </p></dd><dt id="GUC-MAX-FUNCTION-ARGS"><span class="term"><code class="varname">max_function_args</code> (<code class="type">integer</code>)

  63.       <a id="id-1.6.6.18.3.8.1.3" class="indexterm"></a>

  64.       </span></dt><dd><p>

  65.         Reports the maximum number of function arguments. It is determined by

  66.         the value of <code class="literal">FUNC_MAX_ARGS</code> when building the server. The

  67.         default value is 100 arguments.

  68.        </p></dd><dt id="GUC-MAX-IDENTIFIER-LENGTH"><span class="term"><code class="varname">max_identifier_length</code> (<code class="type">integer</code>)

  69.       <a id="id-1.6.6.18.3.9.1.3" class="indexterm"></a>

  70.       </span></dt><dd><p>

  71.         Reports the maximum identifier length. It is determined as one

  72.         less than the value of <code class="literal">NAMEDATALEN</code> when building

  73.         the server. The default value of <code class="literal">NAMEDATALEN</code> is

  74.         64; therefore the default

  75.         <code class="varname">max_identifier_length</code> is 63 bytes, which

  76.         can be less than 63 characters when using multibyte encodings.

  77.        </p></dd><dt id="GUC-MAX-INDEX-KEYS"><span class="term"><code class="varname">max_index_keys</code> (<code class="type">integer</code>)

  78.       <a id="id-1.6.6.18.3.10.1.3" class="indexterm"></a>

  79.       </span></dt><dd><p>

  80.         Reports the maximum number of index keys. It is determined by

  81.         the value of <code class="literal">INDEX_MAX_KEYS</code> when building the server. The

  82.         default value is 32 keys.

  83.        </p></dd><dt id="GUC-SEGMENT-SIZE"><span class="term"><code class="varname">segment_size</code> (<code class="type">integer</code>)

  84.       <a id="id-1.6.6.18.3.11.1.3" class="indexterm"></a>

  85.       </span></dt><dd><p>

  86.         Reports the number of blocks (pages) that can be stored within a file

  87.         segment.  It is determined by the value of <code class="literal">RELSEG_SIZE</code>

  88.         when building the server.  The maximum size of a segment file in bytes

  89.         is equal to <code class="varname">segment_size</code> multiplied by

  90.         <code class="varname">block_size</code>; by default this is 1GB.

  91.        </p></dd><dt id="GUC-SERVER-ENCODING"><span class="term"><code class="varname">server_encoding</code> (<code class="type">string</code>)

  92.       <a id="id-1.6.6.18.3.12.1.3" class="indexterm"></a>

  93.       <a id="id-1.6.6.18.3.12.1.4" class="indexterm"></a>

  94.       </span></dt><dd><p>

  95.         Reports the database encoding (character set).

  96.         It is determined when the database is created.  Ordinarily,

  97.         clients need only be concerned with the value of <a class="xref" href="runtime-config-client.html#GUC-CLIENT-ENCODING">client_encoding</a>.

  98.        </p></dd><dt id="GUC-SERVER-VERSION"><span class="term"><code class="varname">server_version</code> (<code class="type">string</code>)

  99.       <a id="id-1.6.6.18.3.13.1.3" class="indexterm"></a>

  100.       </span></dt><dd><p>

  101.         Reports the version number of the server. It is determined by the

  102.         value of <code class="literal">PG_VERSION</code> when building the server.

  103.        </p></dd><dt id="GUC-SERVER-VERSION-NUM"><span class="term"><code class="varname">server_version_num</code> (<code class="type">integer</code>)

  104.       <a id="id-1.6.6.18.3.14.1.3" class="indexterm"></a>

  105.       </span></dt><dd><p>

  106.         Reports the version number of the server as an integer. It is determined

  107.         by the value of <code class="literal">PG_VERSION_NUM</code> when building the server.

  108.        </p></dd><dt id="GUC-SSL-LIBRARY"><span class="term"><code class="varname">ssl_library</code> (<code class="type">string</code>)

  109.       <a id="id-1.6.6.18.3.15.1.3" class="indexterm"></a>

  110.       </span></dt><dd><p>

  111.         Reports the name of the SSL library that this

  112.         <span class="productname">PostgreSQL</span> server was built with (even if

  113.         SSL is not currently configured or in use on this instance), for

  114.         example <code class="literal">OpenSSL</code>, or an empty string if none.

  115.        </p></dd><dt id="GUC-WAL-BLOCK-SIZE"><span class="term"><code class="varname">wal_block_size</code> (<code class="type">integer</code>)

  116.       <a id="id-1.6.6.18.3.16.1.3" class="indexterm"></a>

  117.       </span></dt><dd><p>

  118.         Reports the size of a WAL disk block.  It is determined by the value

  119.         of <code class="literal">XLOG_BLCKSZ</code> when building the server. The default value

  120.         is 8192 bytes.

  121.        </p></dd><dt id="GUC-WAL-SEGMENT-SIZE"><span class="term"><code class="varname">wal_segment_size</code> (<code class="type">integer</code>)

  122.       <a id="id-1.6.6.18.3.17.1.3" class="indexterm"></a>

  123.       </span></dt><dd><p>

  124.         Reports the size of write ahead log segments.  The default value is

  125.         16MB. See <a class="xref" href="wal-configuration.html" title="29.4. WAL Configuration">Section 29.4</a> for more information.

  126.        </p></dd></dl></div></div><div class="navfooter"><hr /><table width="100%" summary="Navigation footer"><tr><td width="40%" align="left"><a accesskey="p" href="runtime-config-error-handling.html">Prev</a> </td><td width="20%" align="center"><a accesskey="u" href="runtime-config.html">Up</a></td><td width="40%" align="right"> <a accesskey="n" href="runtime-config-custom.html">Next</a></td></tr><tr><td width="40%" align="left" valign="top">19.14. Error Handling </td><td width="20%" align="center"><a accesskey="h" href="index.html">Home</a></td><td width="40%" align="right" valign="top"> 19.16. Customized Options</td></tr></table></div></body></html>
上海开阖软件有限公司 沪ICP备12045867号-1