From: | "yanliang lei" <msdnchina(at)163(dot)com> |
---|---|
To: | "pgsql-docs(at)lists(dot)postgresql(dot)org" <pgsql-docs(at)lists(dot)postgresql(dot)org> |
Subject: | the description of max_wal_senders parameter does not include Logical Replication |
Date: | 2023-08-19 03:49:21 |
Message-ID: | 3404faf4.b4c.18a0be96d81.Coremail.msdnchina@163.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-docs |
the description of max_wal_senders parameter does not include Logical Replication
in the url https://www.postgresql.org/docs/15/runtime-config-replication.html
there are following description:
max_wal_senders (integer)
Specifies the maximum number of concurrent connections from standby servers or streaming base backup clients (i.e., the maximum number of simultaneously running WAL sender processes). The default is 10. The value 0 means replication is disabled. Abrupt disconnection of a streaming client might leave an orphaned connection slot behind until a timeout is reached, so this parameter should be set slightly higher than the maximum number of expected clients so disconnected clients can immediately reconnect. This parameter can only be set at server start. Also, wal_level must be set to replica or higher to allow connections from standby servers.
When running a standby server, you must set this parameter to the same or higher value than on the primary server. Otherwise, queries will not be allowed in the standby server.
In the above description, there is no description about "Logical Replication also use or occupy max_wal_senders ",
so, I suggest the following modification:
Specifies the maximum number of concurrent connections from standby servers or streaming base backup clients and Logical Replication (i.e., the maximum number of simultaneously running WAL sender processes)
From | Date | Subject | |
---|---|---|---|
Next Message | David G. Johnston | 2023-08-20 16:48:59 | Re: ALTER TABLE "table" ALTER COLUMN "id" SET RESTART WITH nnn raises error |
Previous Message | Jonathan S. Katz | 2023-08-19 01:03:12 | Re: ROWS vs RANGE in release notes for pg 16 |