yexinru/doc-exports
1
0
Fork 0
forked from docs/doc-exports
Code Pull Requests Activity
Files
sgode-patch-2
doc-exports/docs/dws/dev/dws_04_1044.html
luhuayi 177cd61a57 DWS DEVG 910.211 version 
Reviewed-by: Pruthi, Vineet <vineet.pruthi@t-systems.com>
Co-authored-by: luhuayi <luhuayi@huawei.com>
Co-committed-by: luhuayi <luhuayi@huawei.com>
2025-05-05 07:44:03 +00:00

111 lines
11 KiB
HTML
Raw Permalink Blame History

<a name="EN-US_TOPIC_0000001811491317"></a><a name="EN-US_TOPIC_0000001811491317"></a>
<h1 class="topictitle1">PG_SUBSCRIPTION</h1>
<div id="body0000001493340853"><p id="EN-US_TOPIC_0000001811491317__a3fb02bd00b2341d79424093650ba792a"><strong id="EN-US_TOPIC_0000001811491317__b1941095472219">PG_SUBSCRIPTION</strong> records all existing subscriptions.</p>
<div class="tablenoborder"><table cellpadding="4" cellspacing="0" summary="" id="EN-US_TOPIC_0000001811491317__t6247b73f46cc4eb6904f6623110bea20" frame="border" border="1" rules="all"><caption><b>Table 1 </b>PG_SUBSCRIPTION columns</caption><thead align="left"><tr id="EN-US_TOPIC_0000001811491317__r6c512e626bf94ba7bf3328415c78ca1b"><th align="left" class="cellrowborder" valign="top" width="17.29%" id="mcps1.3.2.2.5.1.1"><p id="EN-US_TOPIC_0000001811491317__a0eeafe6a04a64cdda812ca5fa10bf53f"><strong id="EN-US_TOPIC_0000001811491317__b201963317543452">Column</strong></p>
</th>
<th align="left" class="cellrowborder" valign="top" width="9.77%" id="mcps1.3.2.2.5.1.2"><p id="EN-US_TOPIC_0000001811491317__a742db4b571df4fbfa8792c07ee574c53">Type</p>
</th>
<th align="left" class="cellrowborder" valign="top" width="31.4%" id="mcps1.3.2.2.5.1.3"><p id="EN-US_TOPIC_0000001811491317__a9d58a61982854516b4a12fbe45b20797">Reference</p>
</th>
<th align="left" class="cellrowborder" valign="top" width="41.54%" id="mcps1.3.2.2.5.1.4"><p id="EN-US_TOPIC_0000001811491317__a454ad9ceb13a4d96a00620a5629c87fa">Description</p>
</th>
</tr>
</thead>
<tbody><tr id="EN-US_TOPIC_0000001811491317__r0483813893fb4b47bee9e92dff248b31"><td class="cellrowborder" valign="top" width="17.29%" headers="mcps1.3.2.2.5.1.1 "><p id="EN-US_TOPIC_0000001811491317__p72411151142512">OID</p>
</td>
<td class="cellrowborder" valign="top" width="9.77%" headers="mcps1.3.2.2.5.1.2 "><p id="EN-US_TOPIC_0000001811491317__p1285425819253">OID</p>
</td>
<td class="cellrowborder" valign="top" width="31.4%" headers="mcps1.3.2.2.5.1.3 "><p id="EN-US_TOPIC_0000001811491317__ad300325dcdff4c38ae210780f758a2c9">-</p>
</td>
<td class="cellrowborder" valign="top" width="41.54%" headers="mcps1.3.2.2.5.1.4 "><p id="EN-US_TOPIC_0000001811491317__p0776152619268">Row identifier (hidden attribute; displayed only when explicitly selected)</p>
</td>
</tr>
<tr id="EN-US_TOPIC_0000001811491317__row19483225154019"><td class="cellrowborder" valign="top" width="17.29%" headers="mcps1.3.2.2.5.1.1 "><p id="EN-US_TOPIC_0000001811491317__p1648382515406">subdbid</p>
</td>
<td class="cellrowborder" valign="top" width="9.77%" headers="mcps1.3.2.2.5.1.2 "><p id="EN-US_TOPIC_0000001811491317__p134832251401">OID</p>
</td>
<td class="cellrowborder" valign="top" width="31.4%" headers="mcps1.3.2.2.5.1.3 "><p id="EN-US_TOPIC_0000001811491317__p1848372594016"><a href="dws_04_0582.html">PG_DATABASE</a>.oid</p>
</td>
<td class="cellrowborder" valign="top" width="41.54%" headers="mcps1.3.2.2.5.1.4 "><p id="EN-US_TOPIC_0000001811491317__p0483152516407">OID of the database that the subscription belongs to</p>
</td>
</tr>
<tr id="EN-US_TOPIC_0000001811491317__r513e4e9aab1e43c598e7b8376105fe61"><td class="cellrowborder" valign="top" width="17.29%" headers="mcps1.3.2.2.5.1.1 "><p id="EN-US_TOPIC_0000001811491317__p12242105162514">subname</p>
</td>
<td class="cellrowborder" valign="top" width="9.77%" headers="mcps1.3.2.2.5.1.2 "><p id="EN-US_TOPIC_0000001811491317__p1485485817254">Name</p>
</td>
<td class="cellrowborder" valign="top" width="31.4%" headers="mcps1.3.2.2.5.1.3 "><p id="EN-US_TOPIC_0000001811491317__p1265101152610">-</p>
</td>
<td class="cellrowborder" valign="top" width="41.54%" headers="mcps1.3.2.2.5.1.4 "><p id="EN-US_TOPIC_0000001811491317__p1177642612269">Name of a subscription</p>
</td>
</tr>
<tr id="EN-US_TOPIC_0000001811491317__r4e1057d952d64f2f98cc1afadb219eb2"><td class="cellrowborder" valign="top" width="17.29%" headers="mcps1.3.2.2.5.1.1 "><p id="EN-US_TOPIC_0000001811491317__p192422051192515">subowner</p>
</td>
<td class="cellrowborder" valign="top" width="9.77%" headers="mcps1.3.2.2.5.1.2 "><p id="EN-US_TOPIC_0000001811491317__p138541258162513">OID</p>
</td>
<td class="cellrowborder" valign="top" width="31.4%" headers="mcps1.3.2.2.5.1.3 "><p id="EN-US_TOPIC_0000001811491317__ad97cb056dabf4765b5b296441ee94889"><a href="dws_04_0574.html">PG_AUTHID</a>.oid</p>
</td>
<td class="cellrowborder" valign="top" width="41.54%" headers="mcps1.3.2.2.5.1.4 "><p id="EN-US_TOPIC_0000001811491317__p13776526102614">Owner of a subscription</p>
</td>
</tr>
<tr id="EN-US_TOPIC_0000001811491317__row9787045174114"><td class="cellrowborder" valign="top" width="17.29%" headers="mcps1.3.2.2.5.1.1 "><p id="EN-US_TOPIC_0000001811491317__p15787745114114">subenabled</p>
</td>
<td class="cellrowborder" valign="top" width="9.77%" headers="mcps1.3.2.2.5.1.2 "><p id="EN-US_TOPIC_0000001811491317__p2078711459411">Boolean</p>
</td>
<td class="cellrowborder" valign="top" width="31.4%" headers="mcps1.3.2.2.5.1.3 "><p id="EN-US_TOPIC_0000001811491317__p1678744512412">-</p>
</td>
<td class="cellrowborder" valign="top" width="41.54%" headers="mcps1.3.2.2.5.1.4 "><p id="EN-US_TOPIC_0000001811491317__p378717459412">If it is <strong id="EN-US_TOPIC_0000001811491317__b4731547102315">true</strong>, the subscription is enabled and should be replicated.</p>
</td>
</tr>
<tr id="EN-US_TOPIC_0000001811491317__rfbf78930fc5b48b4b0eb315fa21582d9"><td class="cellrowborder" valign="top" width="17.29%" headers="mcps1.3.2.2.5.1.1 "><p id="EN-US_TOPIC_0000001811491317__p9242451122517">subconninfo</p>
</td>
<td class="cellrowborder" valign="top" width="9.77%" headers="mcps1.3.2.2.5.1.2 "><p id="EN-US_TOPIC_0000001811491317__p15855185812253">Text</p>
</td>
<td class="cellrowborder" valign="top" width="31.4%" headers="mcps1.3.2.2.5.1.3 "><p id="EN-US_TOPIC_0000001811491317__a75b2e8f595c646f2af9a80dbddcfb1d5">-</p>
</td>
<td class="cellrowborder" valign="top" width="41.54%" headers="mcps1.3.2.2.5.1.4 "><p id="EN-US_TOPIC_0000001811491317__p10683155164212">Information about the connection to the database at the publisher end</p>
</td>
</tr>
<tr id="EN-US_TOPIC_0000001811491317__row181531143102517"><td class="cellrowborder" valign="top" width="17.29%" headers="mcps1.3.2.2.5.1.1 "><p id="EN-US_TOPIC_0000001811491317__p62429517256">subslotname</p>
</td>
<td class="cellrowborder" valign="top" width="9.77%" headers="mcps1.3.2.2.5.1.2 "><p id="EN-US_TOPIC_0000001811491317__p18855115815253">Text</p>
</td>
<td class="cellrowborder" valign="top" width="31.4%" headers="mcps1.3.2.2.5.1.3 "><p id="EN-US_TOPIC_0000001811491317__p1915424372513">-</p>
</td>
<td class="cellrowborder" valign="top" width="41.54%" headers="mcps1.3.2.2.5.1.4 "><p id="EN-US_TOPIC_0000001811491317__p2053800144310">Name of the replication slot in the publisher database If this parameter is left blank, the value is <strong id="EN-US_TOPIC_0000001811491317__b346931272417">NONE</strong>.</p>
</td>
</tr>
<tr id="EN-US_TOPIC_0000001811491317__row415474322519"><td class="cellrowborder" valign="top" width="17.29%" headers="mcps1.3.2.2.5.1.1 "><p id="EN-US_TOPIC_0000001811491317__p11242115142510">subpublications</p>
</td>
<td class="cellrowborder" valign="top" width="9.77%" headers="mcps1.3.2.2.5.1.2 "><p id="EN-US_TOPIC_0000001811491317__p19855758122515">Text[]</p>
</td>
<td class="cellrowborder" valign="top" width="31.4%" headers="mcps1.3.2.2.5.1.3 "><p id="EN-US_TOPIC_0000001811491317__p1015494319252">-</p>
</td>
<td class="cellrowborder" valign="top" width="41.54%" headers="mcps1.3.2.2.5.1.4 "><p id="EN-US_TOPIC_0000001811491317__p7776126162615">Array of subscribed publication names. These are the references to the publications on the publisher server.</p>
</td>
</tr>
</tbody>
</table>
</div>
<div class="section" id="EN-US_TOPIC_0000001811491317__section1047616353919"><h4 class="sectiontitle">Examples</h4><p id="EN-US_TOPIC_0000001811491317__p18128822671">View all subscriptions.</p>
<div class="codecoloring" codetype="Sql" id="EN-US_TOPIC_0000001811491317__screen157185558816"><div class="highlight"><table class="highlighttable"><tr><td class="linenos"><div class="linenodiv"><pre><span class="normal">1</span>
<span class="normal">2</span>
<span class="normal">3</span>
<span class="normal">4</span>
<span class="normal">5</span></pre></div></td><td class="code"><div><pre><span></span><span class="k">SELECT</span><span class="w"> </span><span class="o">*</span><span class="w"> </span><span class="k">FROM</span><span class="w"> </span><span class="n">pg_subscription</span><span class="p">;</span>
<span class="w"> </span><span class="n">subdbid</span><span class="w"> </span><span class="o">|</span><span class="w"> </span><span class="n">subname</span><span class="w"> </span><span class="o">|</span><span class="w"> </span><span class="n">subowner</span><span class="w"> </span><span class="o">|</span><span class="w"> </span><span class="n">subenabled</span><span class="w"> </span><span class="o">|</span><span class="w"> </span><span class="n">subconninfo</span><span class="w"> </span><span class="o">|</span><span class="w"> </span><span class="n">subslotname</span><span class="w"> </span><span class="o">|</span><span class="w"> </span><span class="n">subpublications</span><span class="w"> </span>
<span class="c1">---------+---------+----------+------------+------------------------------------------------------------------------------------------+-------------+-----------------</span>
<span class="w"> </span><span class="mi">15992</span><span class="w"> </span><span class="o">|</span><span class="w"> </span><span class="n">mysub</span><span class="w"> </span><span class="o">|</span><span class="w"> </span><span class="mi">10</span><span class="w"> </span><span class="o">|</span><span class="w"> </span><span class="n">t</span><span class="w"> </span><span class="o">|</span><span class="w"> </span><span class="k">host</span><span class="o">=</span><span class="mi">1</span><span class="p">.</span><span class="mi">1</span><span class="p">.</span><span class="mi">1</span><span class="p">.</span><span class="mi">1</span><span class="p">,</span><span class="mi">2</span><span class="p">.</span><span class="mi">2</span><span class="p">.</span><span class="mi">2</span><span class="p">.</span><span class="mi">2</span><span class="w"> </span><span class="n">port</span><span class="o">=</span><span class="mi">10000</span><span class="p">,</span><span class="mi">20000</span><span class="w"> </span><span class="n">dbname</span><span class="o">=</span><span class="n">postgres</span><span class="w"> </span><span class="k">user</span><span class="o">=</span><span class="n">repusr1</span><span class="w"> </span><span class="n">password</span><span class="o">=</span><span class="n">password_123</span><span class="w"> </span><span class="o">|</span><span class="w"> </span><span class="n">mysub</span><span class="w"> </span><span class="o">|</span><span class="w"> </span><span class="err">{</span><span class="n">mypub</span><span class="err">}</span>
<span class="p">(</span><span class="mi">1</span><span class="w"> </span><span class="k">row</span><span class="p">)</span>
</pre></div></td></tr></table></div>
</div>
</div>
</div>
<div>
<div class="familylinks">
<div class="parentlink"><strong>Parent topic:</strong> <a href="dws_04_0561.html">System Catalogs</a></div>
</div>
</div>
View Git Blame Copy Permalink