forked from docs/doc-exports
luhuayi
177cd61a57
Reviewed-by: Pruthi, Vineet <vineet.pruthi@t-systems.com> Co-authored-by: luhuayi <luhuayi@huawei.com> Co-committed-by: luhuayi <luhuayi@huawei.com>
143 lines
14 KiB
HTML
143 lines
14 KiB
HTML
<a name="EN-US_TOPIC_0000001811609549"></a><a name="EN-US_TOPIC_0000001811609549"></a>
|
|
|
|
<h1 class="topictitle1">PGXC_SETTINGS</h1>
|
|
<div id="body0000001083615208"><p id="EN-US_TOPIC_0000001811609549__p188103574508"><strong id="EN-US_TOPIC_0000001811609549__b19258341245">PGXC_SETTINGS</strong> displays the database running status of each node in the cluster. All columns except <strong id="EN-US_TOPIC_0000001811609549__b6925183472412">node_name</strong> are the same as those in the <a href="dws_04_0751.html">PG_SETTINGS</a> view. This view is accessible only to users with system administrators rights.</p>
|
|
|
|
<div class="tablenoborder"><table cellpadding="4" cellspacing="0" summary="" id="EN-US_TOPIC_0000001811609549__t04cd7f38ca3d40068ac510ee9edfe5a0" frame="border" border="1" rules="all"><caption><b>Table 1 </b>PGXC_SETTINGS columns</caption><thead align="left"><tr id="EN-US_TOPIC_0000001811609549__r690198e293da4247a7867f4b0b5d8eb4"><th align="left" class="cellrowborder" valign="top" width="25.77%" id="mcps1.3.2.2.4.1.1"><p id="EN-US_TOPIC_0000001811609549__ad2fac02df1de478ea42353af412864f2"><strong id="EN-US_TOPIC_0000001811609549__b103261815243830">Column</strong></p>
|
|
</th>
|
|
<th align="left" class="cellrowborder" valign="top" width="17.630000000000003%" id="mcps1.3.2.2.4.1.2"><p id="EN-US_TOPIC_0000001811609549__a9be398dc477d4d8f80fb1f43b26a7510">Type</p>
|
|
</th>
|
|
<th align="left" class="cellrowborder" valign="top" width="56.599999999999994%" id="mcps1.3.2.2.4.1.3"><p id="EN-US_TOPIC_0000001811609549__a2e31ec1ed46c4c15810632c5f3dae5b5">Description</p>
|
|
</th>
|
|
</tr>
|
|
</thead>
|
|
<tbody><tr id="EN-US_TOPIC_0000001811609549__row182013301287"><td class="cellrowborder" valign="top" width="25.77%" headers="mcps1.3.2.2.4.1.1 "><p id="EN-US_TOPIC_0000001811609549__p1467125742111">node_name</p>
|
|
</td>
|
|
<td class="cellrowborder" valign="top" width="17.630000000000003%" headers="mcps1.3.2.2.4.1.2 "><p id="EN-US_TOPIC_0000001811609549__p1046720575212">Text</p>
|
|
</td>
|
|
<td class="cellrowborder" valign="top" width="56.599999999999994%" headers="mcps1.3.2.2.4.1.3 "><p id="EN-US_TOPIC_0000001811609549__p646725716215">Node name</p>
|
|
</td>
|
|
</tr>
|
|
<tr id="EN-US_TOPIC_0000001811609549__r9efcaae3af8b4a878b0aa048bbcc27d2"><td class="cellrowborder" valign="top" width="25.77%" headers="mcps1.3.2.2.4.1.1 "><p id="EN-US_TOPIC_0000001811609549__aaf70a8cfa3cb4b028c86e4bb1719dd59">Name</p>
|
|
</td>
|
|
<td class="cellrowborder" valign="top" width="17.630000000000003%" headers="mcps1.3.2.2.4.1.2 "><p id="EN-US_TOPIC_0000001811609549__a0645fa931b3d4e7baeeecfcdad6b7d22">Text</p>
|
|
</td>
|
|
<td class="cellrowborder" valign="top" width="56.599999999999994%" headers="mcps1.3.2.2.4.1.3 "><p id="EN-US_TOPIC_0000001811609549__afd0b918f146d4061854a6f1242f3dc3b">Parameter name</p>
|
|
</td>
|
|
</tr>
|
|
<tr id="EN-US_TOPIC_0000001811609549__r05f6b1d5da1b47cabf50276d4c3420e9"><td class="cellrowborder" valign="top" width="25.77%" headers="mcps1.3.2.2.4.1.1 "><p id="EN-US_TOPIC_0000001811609549__a846c809321734aec89d7ba1067ab6516">setting</p>
|
|
</td>
|
|
<td class="cellrowborder" valign="top" width="17.630000000000003%" headers="mcps1.3.2.2.4.1.2 "><p id="EN-US_TOPIC_0000001811609549__aac6fc144bd4a4a269c15777b7c2438eb">Text</p>
|
|
</td>
|
|
<td class="cellrowborder" valign="top" width="56.599999999999994%" headers="mcps1.3.2.2.4.1.3 "><p id="EN-US_TOPIC_0000001811609549__abf1a1cb812b94f0689afc402ba0110d2">Current value of the parameter</p>
|
|
</td>
|
|
</tr>
|
|
<tr id="EN-US_TOPIC_0000001811609549__r5d10c30e5d564f7883e653c438bc54b5"><td class="cellrowborder" valign="top" width="25.77%" headers="mcps1.3.2.2.4.1.1 "><p id="EN-US_TOPIC_0000001811609549__ac7c5fa6560964228ae2d9a9725fb1c93">unit</p>
|
|
</td>
|
|
<td class="cellrowborder" valign="top" width="17.630000000000003%" headers="mcps1.3.2.2.4.1.2 "><p id="EN-US_TOPIC_0000001811609549__a451e23e2ce5349b19ee976997709d94b">Text</p>
|
|
</td>
|
|
<td class="cellrowborder" valign="top" width="56.599999999999994%" headers="mcps1.3.2.2.4.1.3 "><p id="EN-US_TOPIC_0000001811609549__aa2aa745b278040489ad01e7e2d9c4787">Implicit unit of the parameter</p>
|
|
</td>
|
|
</tr>
|
|
<tr id="EN-US_TOPIC_0000001811609549__r5dc27776638349a981b1270693993155"><td class="cellrowborder" valign="top" width="25.77%" headers="mcps1.3.2.2.4.1.1 "><p id="EN-US_TOPIC_0000001811609549__a3f7e7d8f7fd848eaa820801b76fb3f53">category</p>
|
|
</td>
|
|
<td class="cellrowborder" valign="top" width="17.630000000000003%" headers="mcps1.3.2.2.4.1.2 "><p id="EN-US_TOPIC_0000001811609549__a3e54a71da2ca411a81371fde7f86a61a">Text</p>
|
|
</td>
|
|
<td class="cellrowborder" valign="top" width="56.599999999999994%" headers="mcps1.3.2.2.4.1.3 "><p id="EN-US_TOPIC_0000001811609549__a6662c5e8f78547d3926a7f79f7d8d883">Logical group of the parameter</p>
|
|
</td>
|
|
</tr>
|
|
<tr id="EN-US_TOPIC_0000001811609549__r813d26477b0e446eb3615888df1e5ef6"><td class="cellrowborder" valign="top" width="25.77%" headers="mcps1.3.2.2.4.1.1 "><p id="EN-US_TOPIC_0000001811609549__a51014fa0818141a98dc9e530fb2b2640">short_desc</p>
|
|
</td>
|
|
<td class="cellrowborder" valign="top" width="17.630000000000003%" headers="mcps1.3.2.2.4.1.2 "><p id="EN-US_TOPIC_0000001811609549__a17b4c3e7b0c443788a6ab8b4325a37f0">Text</p>
|
|
</td>
|
|
<td class="cellrowborder" valign="top" width="56.599999999999994%" headers="mcps1.3.2.2.4.1.3 "><p id="EN-US_TOPIC_0000001811609549__a6887b0816d974840a66be8fc16aaa30a">Brief description of the parameter</p>
|
|
</td>
|
|
</tr>
|
|
<tr id="EN-US_TOPIC_0000001811609549__r9e334694f33b447bbeb3c90a777e35f1"><td class="cellrowborder" valign="top" width="25.77%" headers="mcps1.3.2.2.4.1.1 "><p id="EN-US_TOPIC_0000001811609549__ab18803055ba34d92a5460c74b462b0c5">extra_desc</p>
|
|
</td>
|
|
<td class="cellrowborder" valign="top" width="17.630000000000003%" headers="mcps1.3.2.2.4.1.2 "><p id="EN-US_TOPIC_0000001811609549__a7a2285191f0a4989ac980d1475344cbf">Text</p>
|
|
</td>
|
|
<td class="cellrowborder" valign="top" width="56.599999999999994%" headers="mcps1.3.2.2.4.1.3 "><p id="EN-US_TOPIC_0000001811609549__a2b10168aa7154278b6178b8c9dd36c23">Detailed description of the parameter</p>
|
|
</td>
|
|
</tr>
|
|
<tr id="EN-US_TOPIC_0000001811609549__ra45aaf1639844ca481ee1a741cb9b678"><td class="cellrowborder" valign="top" width="25.77%" headers="mcps1.3.2.2.4.1.1 "><p id="EN-US_TOPIC_0000001811609549__a9a99e2b7324f4cec810b02153c3ea7a6">context</p>
|
|
</td>
|
|
<td class="cellrowborder" valign="top" width="17.630000000000003%" headers="mcps1.3.2.2.4.1.2 "><p id="EN-US_TOPIC_0000001811609549__a08118563189f4d0592c9d178eb84f812">Text</p>
|
|
</td>
|
|
<td class="cellrowborder" valign="top" width="56.599999999999994%" headers="mcps1.3.2.2.4.1.3 "><p id="EN-US_TOPIC_0000001811609549__a795981f4bac640c5b3c8abe68ea65f30">Context of parameter values including <strong id="EN-US_TOPIC_0000001811609549__b565214589174">internal</strong>, <strong id="EN-US_TOPIC_0000001811609549__b1565225818172">postmaster</strong>, <strong id="EN-US_TOPIC_0000001811609549__b1765335810171">sighup</strong>, <strong id="EN-US_TOPIC_0000001811609549__b1365375816175">backend</strong>, <strong id="EN-US_TOPIC_0000001811609549__b116531558111714">superuser</strong>, and <strong id="EN-US_TOPIC_0000001811609549__b165475820174">user</strong>.</p>
|
|
</td>
|
|
</tr>
|
|
<tr id="EN-US_TOPIC_0000001811609549__rf7aa99c171094c669819fcad41323c7d"><td class="cellrowborder" valign="top" width="25.77%" headers="mcps1.3.2.2.4.1.1 "><p id="EN-US_TOPIC_0000001811609549__afeae25653f7b464b9e21a353539e9c19">vartype</p>
|
|
</td>
|
|
<td class="cellrowborder" valign="top" width="17.630000000000003%" headers="mcps1.3.2.2.4.1.2 "><p id="EN-US_TOPIC_0000001811609549__a6d988ba4171642ea8df7bd6f5ea41962">Text</p>
|
|
</td>
|
|
<td class="cellrowborder" valign="top" width="56.599999999999994%" headers="mcps1.3.2.2.4.1.3 "><p id="EN-US_TOPIC_0000001811609549__aeee6bab9b1f94a6cbf4ec62cc3a0a05d">Parameter type. It can be <strong id="EN-US_TOPIC_0000001811609549__b5612152314183">bool</strong>, <strong id="EN-US_TOPIC_0000001811609549__b1461292312186">enum</strong>, <strong id="EN-US_TOPIC_0000001811609549__b11613152341817">integer</strong>, <strong id="EN-US_TOPIC_0000001811609549__b13613172310188">real</strong>, or <strong id="EN-US_TOPIC_0000001811609549__b16614102371813">string</strong>.</p>
|
|
</td>
|
|
</tr>
|
|
<tr id="EN-US_TOPIC_0000001811609549__r81736b9f91ff4afca40e51e81d739e33"><td class="cellrowborder" valign="top" width="25.77%" headers="mcps1.3.2.2.4.1.1 "><p id="EN-US_TOPIC_0000001811609549__ad8f69968bd8b4366a722617c27d1bb05">source</p>
|
|
</td>
|
|
<td class="cellrowborder" valign="top" width="17.630000000000003%" headers="mcps1.3.2.2.4.1.2 "><p id="EN-US_TOPIC_0000001811609549__ae4ab8d58c132449f94ec7f48610ef3fe">Text</p>
|
|
</td>
|
|
<td class="cellrowborder" valign="top" width="56.599999999999994%" headers="mcps1.3.2.2.4.1.3 "><p id="EN-US_TOPIC_0000001811609549__ae4a86e5d00a44e72bebd77a86f091579">Method of assigning the parameter value</p>
|
|
</td>
|
|
</tr>
|
|
<tr id="EN-US_TOPIC_0000001811609549__r0e662c78e545496c82d6c23e254f9aa3"><td class="cellrowborder" valign="top" width="25.77%" headers="mcps1.3.2.2.4.1.1 "><p id="EN-US_TOPIC_0000001811609549__a0acfe052f24649f1801382c6dfffa671">min_val</p>
|
|
</td>
|
|
<td class="cellrowborder" valign="top" width="17.630000000000003%" headers="mcps1.3.2.2.4.1.2 "><p id="EN-US_TOPIC_0000001811609549__af71b2670a42f41cb99fd27b1210214ec">Text</p>
|
|
</td>
|
|
<td class="cellrowborder" valign="top" width="56.599999999999994%" headers="mcps1.3.2.2.4.1.3 "><p id="EN-US_TOPIC_0000001811609549__ad0321b95f2e04045a8ae7812a7e3d1ca">Minimum value of the parameter If the parameter type is not numeric data, the value of this column is null.</p>
|
|
</td>
|
|
</tr>
|
|
<tr id="EN-US_TOPIC_0000001811609549__re649e0eaa3bd4f44abe82849626f8996"><td class="cellrowborder" valign="top" width="25.77%" headers="mcps1.3.2.2.4.1.1 "><p id="EN-US_TOPIC_0000001811609549__a0e0140e77a2a47c9ae34fce4e2f7aad1">max_val</p>
|
|
</td>
|
|
<td class="cellrowborder" valign="top" width="17.630000000000003%" headers="mcps1.3.2.2.4.1.2 "><p id="EN-US_TOPIC_0000001811609549__a3613fd3ae7d94fd78a1462e22dce06a1">Text</p>
|
|
</td>
|
|
<td class="cellrowborder" valign="top" width="56.599999999999994%" headers="mcps1.3.2.2.4.1.3 "><p id="EN-US_TOPIC_0000001811609549__a1d6a7e3693114822bf71325aef38c7d4">Maximum value of the parameter. If the parameter type is not numeric data, the value of this column is null.</p>
|
|
</td>
|
|
</tr>
|
|
<tr id="EN-US_TOPIC_0000001811609549__r4f842b9c710047cb99dc8f162a06f19b"><td class="cellrowborder" valign="top" width="25.77%" headers="mcps1.3.2.2.4.1.1 "><p id="EN-US_TOPIC_0000001811609549__a14d44a830e6b41b88c31d07f5a22dc11">enumvals</p>
|
|
</td>
|
|
<td class="cellrowborder" valign="top" width="17.630000000000003%" headers="mcps1.3.2.2.4.1.2 "><p id="EN-US_TOPIC_0000001811609549__a209d41251ede472fa43e5c7025ca54a1">Text[]</p>
|
|
</td>
|
|
<td class="cellrowborder" valign="top" width="56.599999999999994%" headers="mcps1.3.2.2.4.1.3 "><p id="EN-US_TOPIC_0000001811609549__a893e8b1872fd460a9c838242b87cf267">Valid values of an enum-typed parameter. If the parameter type is not enum, the value of this column is null.</p>
|
|
</td>
|
|
</tr>
|
|
<tr id="EN-US_TOPIC_0000001811609549__r4aeb032b6a9a45989c44d5f8418e6f65"><td class="cellrowborder" valign="top" width="25.77%" headers="mcps1.3.2.2.4.1.1 "><p id="EN-US_TOPIC_0000001811609549__afc6397144a14445394a6a8d53302e13d">boot_val</p>
|
|
</td>
|
|
<td class="cellrowborder" valign="top" width="17.630000000000003%" headers="mcps1.3.2.2.4.1.2 "><p id="EN-US_TOPIC_0000001811609549__a27e423d935fe4b15a6a69046adfdbd81">Text</p>
|
|
</td>
|
|
<td class="cellrowborder" valign="top" width="56.599999999999994%" headers="mcps1.3.2.2.4.1.3 "><p id="EN-US_TOPIC_0000001811609549__a6703b72a62da434aa5cdc1d06ceebf99">Default parameter value used upon the database startup</p>
|
|
</td>
|
|
</tr>
|
|
<tr id="EN-US_TOPIC_0000001811609549__r183db650d9b8428db014a562eeaf3823"><td class="cellrowborder" valign="top" width="25.77%" headers="mcps1.3.2.2.4.1.1 "><p id="EN-US_TOPIC_0000001811609549__afe46b49ad58b49e4aa14b80e66c55f0f">reset_val</p>
|
|
</td>
|
|
<td class="cellrowborder" valign="top" width="17.630000000000003%" headers="mcps1.3.2.2.4.1.2 "><p id="EN-US_TOPIC_0000001811609549__a57f31e167f624e8e9282528ffcc3376d">Text</p>
|
|
</td>
|
|
<td class="cellrowborder" valign="top" width="56.599999999999994%" headers="mcps1.3.2.2.4.1.3 "><p id="EN-US_TOPIC_0000001811609549__af776d6aa85ea45bb9a238a8dffee1dd0">Default parameter value used upon the database reset</p>
|
|
</td>
|
|
</tr>
|
|
<tr id="EN-US_TOPIC_0000001811609549__rcf76d4f8070f4822ba2a3e35afae325e"><td class="cellrowborder" valign="top" width="25.77%" headers="mcps1.3.2.2.4.1.1 "><p id="EN-US_TOPIC_0000001811609549__a48a5b332ddb44929a006bfc76e41ba4c">sourcefile</p>
|
|
</td>
|
|
<td class="cellrowborder" valign="top" width="17.630000000000003%" headers="mcps1.3.2.2.4.1.2 "><p id="EN-US_TOPIC_0000001811609549__a090d023639ed4b96b4cf8957fe09e405">Text</p>
|
|
</td>
|
|
<td class="cellrowborder" valign="top" width="56.599999999999994%" headers="mcps1.3.2.2.4.1.3 "><p id="EN-US_TOPIC_0000001811609549__adbc0e20f41c347dfac23bd2bbcb3ee65">Configuration file used to set parameter values. If parameter values are not configured using the configuration file, the value of this column is null.</p>
|
|
</td>
|
|
</tr>
|
|
<tr id="EN-US_TOPIC_0000001811609549__rd1606427d06548acaa5abd093107ce0f"><td class="cellrowborder" valign="top" width="25.77%" headers="mcps1.3.2.2.4.1.1 "><p id="EN-US_TOPIC_0000001811609549__ac9782d8301f04a808086672a2b45504b">sourceline</p>
|
|
</td>
|
|
<td class="cellrowborder" valign="top" width="17.630000000000003%" headers="mcps1.3.2.2.4.1.2 "><p id="EN-US_TOPIC_0000001811609549__ad8fcbc24cb744d1e8bc388b5f38ee12f">Integer</p>
|
|
</td>
|
|
<td class="cellrowborder" valign="top" width="56.599999999999994%" headers="mcps1.3.2.2.4.1.3 "><p id="EN-US_TOPIC_0000001811609549__a4ab8ca29ec85493e852c53051b46b47b">Row number of the configuration file for setting parameter values. If parameter values are not configured using the configuration file, the value of this column is null.</p>
|
|
</td>
|
|
</tr>
|
|
</tbody>
|
|
</table>
|
|
</div>
|
|
</div>
|
|
<div>
|
|
<div class="familylinks">
|
|
<div class="parentlink"><strong>Parent topic:</strong> <a href="dws_04_0639.html">System Views</a></div>
|
|
</div>
|
|
</div>
|
|
|