1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
101
102
103
104
105
106
107
108
109
110
111
112
113
114
115
116
117
118
119
120
121
122
123
124
125
126
127
128
129
130
|
<?xml version="1.0" encoding="UTF-8" standalone="no"?>
<!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>53.54. pg_subscription</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 Vsnapshot" /><link rel="prev" href="catalog-pg-statistic-ext-data.html" title="53.53. pg_statistic_ext_data" /><link rel="next" href="catalog-pg-subscription-rel.html" title="53.55. pg_subscription_rel" /></head><body id="docContent" class="container-fluid col-10"><div class="navheader"><table width="100%" summary="Navigation header"><tr><th colspan="5" align="center">53.54. <code class="structname">pg_subscription</code></th></tr><tr><td width="10%" align="left"><a accesskey="p" href="catalog-pg-statistic-ext-data.html" title="53.53. pg_statistic_ext_data">Prev</a> </td><td width="10%" align="left"><a accesskey="u" href="catalogs.html" title="Chapter 53. System Catalogs">Up</a></td><th width="60%" align="center">Chapter 53. System Catalogs</th><td width="10%" align="right"><a accesskey="h" href="index.html" title="PostgreSQL 16.2 Documentation">Home</a></td><td width="10%" align="right"> <a accesskey="n" href="catalog-pg-subscription-rel.html" title="53.55. pg_subscription_rel">Next</a></td></tr></table><hr /></div><div class="sect1" id="CATALOG-PG-SUBSCRIPTION"><div class="titlepage"><div><div><h2 class="title" style="clear: both">53.54. <code class="structname">pg_subscription</code> <a href="#CATALOG-PG-SUBSCRIPTION" class="id_link">#</a></h2></div></div></div><a id="id-1.10.4.56.2" class="indexterm"></a><p>
The catalog <code class="structname">pg_subscription</code> contains all existing
logical replication subscriptions. For more information about logical
replication see <a class="xref" href="logical-replication.html" title="Chapter 31. Logical Replication">Chapter 31</a>.
</p><p>
Unlike most system catalogs, <code class="structname">pg_subscription</code> is
shared across all databases of a cluster: there is only one copy
of <code class="structname">pg_subscription</code> per cluster, not one per
database.
</p><p>
Access to the column <code class="structfield">subconninfo</code> is revoked from
normal users, because it could contain plain-text passwords.
</p><div class="table" id="id-1.10.4.56.6"><p class="title"><strong>Table 53.54. <code class="structname">pg_subscription</code> Columns</strong></p><div class="table-contents"><table class="table" summary="pg_subscription Columns" border="1"><colgroup><col /></colgroup><thead><tr><th class="catalog_table_entry"><p class="column_definition">
Column Type
</p>
<p>
Description
</p></th></tr></thead><tbody><tr><td class="catalog_table_entry"><p class="column_definition">
<code class="structfield">oid</code> <code class="type">oid</code>
</p>
<p>
Row identifier
</p></td></tr><tr><td class="catalog_table_entry"><p class="column_definition">
<code class="structfield">subdbid</code> <code class="type">oid</code>
(references <a class="link" href="catalog-pg-database.html" title="53.15. pg_database"><code class="structname">pg_database</code></a>.<code class="structfield">oid</code>)
</p>
<p>
OID of the database that the subscription resides in
</p></td></tr><tr><td class="catalog_table_entry"><p class="column_definition">
<code class="structfield">subskiplsn</code> <code class="type">pg_lsn</code>
</p>
<p>
Finish LSN of the transaction whose changes are to be skipped, if a valid
LSN; otherwise <code class="literal">0/0</code>.
</p></td></tr><tr><td class="catalog_table_entry"><p class="column_definition">
<code class="structfield">subname</code> <code class="type">name</code>
</p>
<p>
Name of the subscription
</p></td></tr><tr><td class="catalog_table_entry"><p class="column_definition">
<code class="structfield">subowner</code> <code class="type">oid</code>
(references <a class="link" href="catalog-pg-authid.html" title="53.8. pg_authid"><code class="structname">pg_authid</code></a>.<code class="structfield">oid</code>)
</p>
<p>
Owner of the subscription
</p></td></tr><tr><td class="catalog_table_entry"><p class="column_definition">
<code class="structfield">subenabled</code> <code class="type">bool</code>
</p>
<p>
If true, the subscription is enabled and should be replicating
</p></td></tr><tr><td class="catalog_table_entry"><p class="column_definition">
<code class="structfield">subbinary</code> <code class="type">bool</code>
</p>
<p>
If true, the subscription will request that the publisher send data
in binary format
</p></td></tr><tr><td class="catalog_table_entry"><p class="column_definition">
<code class="structfield">substream</code> <code class="type">char</code>
</p>
<p>
Controls how to handle the streaming of in-progress transactions:
<code class="literal">f</code> = disallow streaming of in-progress transactions,
<code class="literal">t</code> = spill the changes of in-progress transactions to
disk and apply at once after the transaction is committed on the
publisher and received by the subscriber,
<code class="literal">p</code> = apply changes directly using a parallel apply
worker if available (same as 't' if no worker is available)
</p></td></tr><tr><td class="catalog_table_entry"><p class="column_definition">
<code class="structfield">subtwophasestate</code> <code class="type">char</code>
</p>
<p>
State codes for two-phase mode:
<code class="literal">d</code> = disabled,
<code class="literal">p</code> = pending enablement,
<code class="literal">e</code> = enabled
</p></td></tr><tr><td class="catalog_table_entry"><p class="column_definition">
<code class="structfield">subdisableonerr</code> <code class="type">bool</code>
</p>
<p>
If true, the subscription will be disabled if one of its workers
detects an error
</p></td></tr><tr><td class="catalog_table_entry"><p class="column_definition">
<code class="structfield">subpasswordrequired</code> <code class="type">bool</code>
</p>
<p>
If true, the subscription will be required to specify a password
for authentication
</p></td></tr><tr><td class="catalog_table_entry"><p class="column_definition">
<code class="structfield">subrunasowner</code> <code class="type">bool</code>
</p>
<p>
If true, the subscription will be run with the permissions
of the subscription owner
</p></td></tr><tr><td class="catalog_table_entry"><p class="column_definition">
<code class="structfield">subconninfo</code> <code class="type">text</code>
</p>
<p>
Connection string to the upstream database
</p></td></tr><tr><td class="catalog_table_entry"><p class="column_definition">
<code class="structfield">subslotname</code> <code class="type">name</code>
</p>
<p>
Name of the replication slot in the upstream database (also used
for the local replication origin name);
null represents <code class="literal">NONE</code>
</p></td></tr><tr><td class="catalog_table_entry"><p class="column_definition">
<code class="structfield">subsynccommit</code> <code class="type">text</code>
</p>
<p>
The <code class="varname">synchronous_commit</code>
setting for the subscription's workers to use
</p></td></tr><tr><td class="catalog_table_entry"><p class="column_definition">
<code class="structfield">subpublications</code> <code class="type">text[]</code>
</p>
<p>
Array of subscribed publication names. These reference
publications defined in the upstream database. For more on publications
see <a class="xref" href="logical-replication-publication.html" title="31.1. Publication">Section 31.1</a>.
</p></td></tr><tr><td class="catalog_table_entry"><p class="column_definition">
<code class="structfield">suborigin</code> <code class="type">text</code>
</p>
<p>
The origin value must be either <code class="literal">none</code> or
<code class="literal">any</code>. The default is <code class="literal">any</code>.
If <code class="literal">none</code>, the subscription will request the publisher
to only send changes that don't have an origin. If
<code class="literal">any</code>, the publisher sends changes regardless of their
origin.
</p></td></tr></tbody></table></div></div><br class="table-break" /></div><div class="navfooter"><hr /><table width="100%" summary="Navigation footer"><tr><td width="40%" align="left"><a accesskey="p" href="catalog-pg-statistic-ext-data.html" title="53.53. pg_statistic_ext_data">Prev</a> </td><td width="20%" align="center"><a accesskey="u" href="catalogs.html" title="Chapter 53. System Catalogs">Up</a></td><td width="40%" align="right"> <a accesskey="n" href="catalog-pg-subscription-rel.html" title="53.55. pg_subscription_rel">Next</a></td></tr><tr><td width="40%" align="left" valign="top">53.53. <code class="structname">pg_statistic_ext_data</code> </td><td width="20%" align="center"><a accesskey="h" href="index.html" title="PostgreSQL 16.2 Documentation">Home</a></td><td width="40%" align="right" valign="top"> 53.55. <code class="structname">pg_subscription_rel</code></td></tr></table></div></body></html>
|
