max_active_replication_origins

Specifies how many replication origins (see Chapter 48) can be tracked simultaneously, effectively limiting how many logical replication subscriptions can be created on the server. Setting it to a lower value than the current number of tracked replication origins (reflected in pg_replication_origin_status) will prevent the server from starting. It defaults to 10. This parameter can only be set at server start. max_active_replication_origins must be set to at least the number of subscriptions that will be added to the subscriber, plus some reserve for table synchronization.

English manual coverage begins with PostgreSQL 7.4. Source history and runtime observations have their own recorded version boundaries.

Reading PG 18·Select a recorded version

18 19 20

boot val: 10
category: Replication / Subscribers
context: postmaster
doc same as: Unknown
documented: true
enumvals: Unknown
extra desc: Unknown
lang: en
max val: 262143
metadata version: 18
min val: 0
name: max_active_replication_origins
short desc: Sets the maximum number of active replication origins.
source: pg-settings-source-snapshot
unit: Unknown
vartype: integer

Definition PG 18

Specifies how many replication origins (see Chapter 48) can be tracked simultaneously, effectively limiting how many logical replication subscriptions can be created on the server. Setting it to a lower value than the current number of tracked replication origins (reflected in pg_replication_origin_status) will prevent the server from starting. It defaults to 10. This parameter can only be set at server start. max_active_replication_origins must be set to at least the number of subscriptions that will be added to the subscriber, plus some reserve for table synchronization.

Compare versions

Complete source facts

doc html

<p>
        Specifies how many replication origins (see
        <a class="xref" href="/docs/18/replication-origins.html" title="Chapter 48. Replication Progress Tracking">Chapter 48</a>) can be tracked simultaneously,
        effectively limiting how many logical replication subscriptions can
        be created on the server. Setting it to a lower value than the current
        number of tracked replication origins (reflected in
        <a class="link" href="/docs/18/view-pg-replication-origin-status.html" title="53.19. pg_replication_origin_status">pg_replication_origin_status</a>)
        will prevent the server from starting. It defaults to 10. This parameter
        can only be set at server start.

        <code class="literal">max_active_replication_origins</code> must be set to at least the
        number of subscriptions that will be added to the subscriber, plus some
        reserve for table synchronization.
       </p>

documentation revision

{"inputs":[{"file":"runtime-config-replication.html","kind":"same-version-reviewed-manual","locale":"en","sha256":"c0b8bd86131ec62d4df97ce480d004aa7e3544477d053f0c2d4047b9edad5cc0","version":"18.7"},{"file":"runtime-config-replication.html","kind":"same-version-reviewed-manual","locale":"zh-Hans","sha256":"83907b5f469e979a7b9ec875b5e7bdaa2ef6b85596ca31b45174f68cd7398b18","version":"18.7"}],"release":"18.7","runtime_remeasured":false,"source_revision":"pgdoc:b9f0e7232f60f380d642ac9b99226606c254b552"}

Source references

Original manual reference

Full definition and evidence JSON

Definition sources

center · PostgreSQL 18 · wiki-repair-20261023:48f130d61c46e7589d1d5e04f23766734c6355564ca2318cc9551ad177c12aa9

Text language: en · wiki-repair-20261023:48f130d61c46e7589d1d5e04f23766734c6355564ca2318cc9551ad177c12aa9