diff options
Diffstat (limited to 'doc/src')
| -rw-r--r-- | doc/src/sgml/catalogs.sgml | 26 | ||||
| -rw-r--r-- | doc/src/sgml/ref/alter_subscription.sgml | 6 | ||||
| -rw-r--r-- | doc/src/sgml/ref/create_subscription.sgml | 26 |
3 files changed, 46 insertions, 12 deletions
diff --git a/doc/src/sgml/catalogs.sgml b/doc/src/sgml/catalogs.sgml index e9cdff48641..18ab3d434cb 100644 --- a/doc/src/sgml/catalogs.sgml +++ b/doc/src/sgml/catalogs.sgml @@ -7472,7 +7472,7 @@ SCRAM-SHA-256$<replaceable><iteration count></replaceable>:<replaceable>&l (references <link linkend="catalog-pg-database"><structname>pg_database</structname></link>.<structfield>oid</structfield>) </para> <para> - OID of the database which the subscription resides in + OID of the database that the subscription resides in </para></entry> </row> @@ -7500,7 +7500,17 @@ SCRAM-SHA-256$<replaceable><iteration count></replaceable>:<replaceable>&l <structfield>subenabled</structfield> <type>bool</type> </para> <para> - If true, the subscription is enabled and should be replicating. + If true, the subscription is enabled and should be replicating + </para></entry> + </row> + + <row> + <entry role="catalog_table_entry"><para role="column_definition"> + <structfield>subbinary</structfield> <type>bool</type> + </para> + <para> + If true, the subscription will request that the publisher send data + in binary format </para></entry> </row> @@ -7518,8 +7528,8 @@ SCRAM-SHA-256$<replaceable><iteration count></replaceable>:<replaceable>&l <structfield>subslotname</structfield> <type>name</type> </para> <para> - Name of the replication slot in the upstream database. Also used - for local replication origin name. + Name of the replication slot in the upstream database (also used + for the local replication origin name) </para></entry> </row> @@ -7528,8 +7538,8 @@ SCRAM-SHA-256$<replaceable><iteration count></replaceable>:<replaceable>&l <structfield>subsynccommit</structfield> <type>text</type> </para> <para> - Contains the value of the <varname>synchronous_commit</varname> - setting for the subscription workers. + The <varname>synchronous_commit</varname> + setting for the subscription's workers to use </para></entry> </row> @@ -7538,8 +7548,8 @@ SCRAM-SHA-256$<replaceable><iteration count></replaceable>:<replaceable>&l <structfield>subpublications</structfield> <type>text[]</type> </para> <para> - Array of subscribed publication names. These reference the - publications on the publisher server. For more on publications + Array of subscribed publication names. These reference + publications defined in the upstream database. For more on publications see <xref linkend="logical-replication-publication"/>. </para></entry> </row> diff --git a/doc/src/sgml/ref/alter_subscription.sgml b/doc/src/sgml/ref/alter_subscription.sgml index c24ace14d10..81c4e70cdf4 100644 --- a/doc/src/sgml/ref/alter_subscription.sgml +++ b/doc/src/sgml/ref/alter_subscription.sgml @@ -163,8 +163,10 @@ ALTER SUBSCRIPTION <replaceable class="parameter">name</replaceable> RENAME TO < <para> This clause alters parameters originally set by <xref linkend="sql-createsubscription"/>. See there for more - information. The allowed options are <literal>slot_name</literal> and - <literal>synchronous_commit</literal> + information. The parameters that can be altered + are <literal>slot_name</literal>, + <literal>synchronous_commit</literal>, and + <literal>binary</literal>. </para> </listitem> </varlistentry> diff --git a/doc/src/sgml/ref/create_subscription.sgml b/doc/src/sgml/ref/create_subscription.sgml index 5bbc165f70d..cdb22c54fea 100644 --- a/doc/src/sgml/ref/create_subscription.sgml +++ b/doc/src/sgml/ref/create_subscription.sgml @@ -152,8 +152,9 @@ CREATE SUBSCRIPTION <replaceable class="parameter">subscription_name</replaceabl <listitem> <para> The value of this parameter overrides the - <xref linkend="guc-synchronous-commit"/> setting. The default - value is <literal>off</literal>. + <xref linkend="guc-synchronous-commit"/> setting within this + subscription's apply worker processes. The default value + is <literal>off</literal>. </para> <para> @@ -179,6 +180,27 @@ CREATE SUBSCRIPTION <replaceable class="parameter">subscription_name</replaceabl </varlistentry> <varlistentry> + <term><literal>binary</literal> (<type>boolean</type>)</term> + <listitem> + <para> + Specifies whether the subscription will request the publisher to + send the data in binary format (as opposed to text). + The default is <literal>false</literal>. + Even when this option is enabled, only data types that have + binary send and receive functions will be transferred in binary. + </para> + + <para> + When doing cross-version replication, it could happen that the + publisher has a binary send function for some data type, but the + subscriber lacks a binary receive function for the type. In + such a case, data transfer will fail, and + the <literal>binary</literal> option cannot be used. + </para> + </listitem> + </varlistentry> + + <varlistentry> <term><literal>connect</literal> (<type>boolean</type>)</term> <listitem> <para> |