Re: There is no description about "Logical Replication also use or occupy max_wal_senders ",
| От | Euler Taveira |
|---|---|
| Тема | Re: There is no description about "Logical Replication also use or occupy max_wal_senders ", |
| Дата | |
| Msg-id | b151f622-86c4-429e-8629-e48b7038c6c1@app.fastmail.com обсуждение исходный текст |
| Ответ на | There is no description about "Logical Replication also use or occupy max_wal_senders ", (PG Doc comments form <noreply@postgresql.org>) |
| Ответы |
Replica vs standby
|
| Список | pgsql-docs |
On Wed, Aug 23, 2023, at 10:55 AM, PG Doc comments form wrote:
max_wal_senders (integer)Specifies the maximum number of concurrent connections from standby serversor streaming base backup clients (i.e., the maximum number of simultaneouslyrunning WAL sender processes). The default is 10. The value 0 meansreplication is disabled. Abrupt disconnection of a streaming client mightleave an orphaned connection slot behind until a timeout is reached, so thisparameter should be set slightly higher than the maximum number of expectedclients so disconnected clients can immediately reconnect. This parametercan only be set at server start. Also, wal_level must be set to replica orhigher to allow connections from standby servers.When running a standby server, you must set this parameter to the same orhigher value than on the primary server. Otherwise, queries will not beallowed in the standby server.In the above description， there is no description about "Logical Replicationalso use or occupy max_wal_senders ",
According to the glossary [1], standby server (referred as "replica") is
Replica (server)
A database that is paired with a primary database and is maintaining a copy of
some or all of the primary database's data. The foremost reasons for doing this
are to allow for greater access to that data, and to maintain availability of
the data in the event that the primary becomes unavailable.
... and it implies both (logical and physical) replicas. The logical
replication [2] setup also informs that you need to adjust max_wal_senders.
Maybe the "standby" terminology could be expanded to avoid confusion for users
from other technologies. If I were to suggest a modification, it would be in
the first paragraph in the "Replication" section [3] (something like "Primaries
can send data, while standbys are always receivers of physically or logically
replicated data") or even better rephrase the "Replica (server)" term in the
glossary [1].
so, I suggest the following modification:Specifies the maximum number of concurrent connections from standby serversor streaming base backup clients and Logical Replication (i.e., themaximum number of simultaneously running WAL sender processes). ---pleasenote ,"and Logical Replication" is newly added。
The logical replication feature wasn't newly added. It was added almost 6 years
ago and version 10 (that adds it) was EOL more than 9 months ago.
В списке pgsql-docs по дате отправления: