Home Explore Blog CI



postgresql

94th chunk of `doc/src/sgml/catalogs.sgml`
f694058b1087248ff71a2694aefd9de8ebed5ba3990346770000000100000fae
 directly using a parallel apply
       worker if available (same as <literal>t</literal> if no worker is
       available)
      </para></entry>
     </row>

     <row>
      <entry role="catalog_table_entry"><para role="column_definition">
       <structfield>subtwophasestate</structfield> <type>char</type>
      </para>
      <para>
       State codes for two-phase mode:
       <literal>d</literal> = disabled,
       <literal>p</literal> = pending enablement,
       <literal>e</literal> = enabled
      </para></entry>
     </row>

     <row>
      <entry role="catalog_table_entry"><para role="column_definition">
       <structfield>subdisableonerr</structfield> <type>bool</type>
      </para>
      <para>
       If true, the subscription will be disabled if one of its workers
       detects an error
      </para></entry>
     </row>

     <row>
      <entry role="catalog_table_entry"><para role="column_definition">
       <structfield>subpasswordrequired</structfield> <type>bool</type>
      </para>
      <para>
       If true, the subscription will be required to specify a password
       for authentication
      </para></entry>
     </row>

     <row>
      <entry role="catalog_table_entry"><para role="column_definition">
       <structfield>subrunasowner</structfield> <type>bool</type>
      </para>
      <para>
       If true, the subscription will be run with the permissions
       of the subscription owner
      </para></entry>
     </row>

     <row>
      <entry role="catalog_table_entry"><para role="column_definition">
       <structfield>subfailover</structfield> <type>bool</type>
      </para>
      <para>
       If true, the associated replication slots (i.e. the main slot and the
       table synchronization slots) in the upstream database are enabled to be
       synchronized to the standbys
      </para></entry>
     </row>

     <row>
      <entry role="catalog_table_entry"><para role="column_definition">
       <structfield>subconninfo</structfield> <type>text</type>
      </para>
      <para>
       Connection string to the upstream database
      </para></entry>
     </row>

     <row>
      <entry role="catalog_table_entry"><para role="column_definition">
       <structfield>subslotname</structfield> <type>name</type>
      </para>
      <para>
       Name of the replication slot in the upstream database (also used
       for the local replication origin name);
       null represents <literal>NONE</literal>
      </para></entry>
     </row>

     <row>
      <entry role="catalog_table_entry"><para role="column_definition">
       <structfield>subsynccommit</structfield> <type>text</type>
      </para>
      <para>
       The <varname>synchronous_commit</varname>
       setting for the subscription's workers to use
      </para></entry>
     </row>

     <row>
      <entry role="catalog_table_entry"><para role="column_definition">
       <structfield>subpublications</structfield> <type>text[]</type>
      </para>
      <para>
       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>

     <row>
      <entry role="catalog_table_entry"><para role="column_definition">
       <structfield>suborigin</structfield> <type>text</type>
      </para>
      <para>
       The origin value must be either <literal>none</literal> or
       <literal>any</literal>. The default is <literal>any</literal>.
       If <literal>none</literal>, the subscription will request the publisher
       to only send changes that don't have an origin. If
       <literal>any</literal>, the publisher sends changes regardless of their
       origin.
      </para></entry>
     </row>
    </tbody>
   </tgroup>
  </table>
 </sect1>

 <sect1 id="catalog-pg-subscription-rel">
  <title><structname>pg_subscription_rel</structname></title>

  <indexterm zone="catalog-pg-subscription-rel">

Title: pg_subscription Columns (Continued)
Summary
This section continues detailing the columns of the `pg_subscription` catalog table. It describes `subpasswordrequired` (password requirement flag), `subrunasowner` (run as owner flag), `subfailover` (replication slot failover flag), `subconninfo` (connection string), `subslotname` (replication slot name), `subsynccommit` (synchronous_commit setting), `subpublications` (array of subscribed publication names), and `suborigin` (replication origin).