pg.ddx.io pgsql-docs@postgresql.org mailing list archive
help / color / mirror / Atom feedmax_replication_slots in subscriber for subscription?
2+ messages / 2 participants
[nested] [flat]
* max_replication_slots in subscriber for subscription?
@ 2017-09-18 17:04 jonny.battiato@gmail.com
2017-10-02 13:12 ` Re: max_replication_slots in subscriber for subscription? Alvaro Herrera <alvherre@alvh.no-ip.org>
0 siblings, 1 reply; 2+ messages in thread
From: jonny.battiato@gmail.com @ 2017-09-18 17:04 UTC (permalink / raw)
To: pgsql-docs
The following documentation comment has been logged on the website:
Page: https://www.postgresql.org/docs/10/static/logical-replication-config.html
Description:
Hi!
In this section:
https://www.postgresql.org/docs/10/static/logical-replication-config.html
the following sentences make no sense in the way replication slots are
designed:
"The subscriber also requires the max_replication_slots to be set. In this
case it should be set to at least the number of subscriptions that will be
added to the subscriber."
I can understand if the subscriber would be used as a publisher as well, so
the second sentence could make more sense as follows:
"In this case it should be set to at least the number of publications that
will be added to the subscriber."
Could you please check?
And if I'm wrong, I would appreciate a little more clear explanation.
Many thanks,
Jonathan
--
Sent via pgsql-docs mailing list (pgsql-docs@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-docs
^ permalink raw reply [nested|flat] 2+ messages in thread
* Re: max_replication_slots in subscriber for subscription?
2017-09-18 17:04 max_replication_slots in subscriber for subscription? jonny.battiato@gmail.com
@ 2017-10-02 13:12 ` Alvaro Herrera <alvherre@alvh.no-ip.org>
0 siblings, 0 replies; 2+ messages in thread
From: Alvaro Herrera @ 2017-10-02 13:12 UTC (permalink / raw)
To: jonny.battiato@gmail.com; +Cc: pgsql-docs
jonny.battiato@gmail.com wrote:
> In this section:
> https://www.postgresql.org/docs/10/static/logical-replication-config.html
>
> the following sentences make no sense in the way replication slots are
> designed:
>
> "The subscriber also requires the max_replication_slots to be set. In this
> case it should be set to at least the number of subscriptions that will be
> added to the subscriber."
>
> I can understand if the subscriber would be used as a publisher as well, so
> the second sentence could make more sense as follows:
>
> "In this case it should be set to at least the number of publications that
> will be added to the subscriber."
>
> Could you please check?
> And if I'm wrong, I would appreciate a little more clear explanation.
Apparently, the reason for this (and correct me if I'm wrong) is that
the maximum number of replication origins is determined from
max_replication_slots, too. So the subscriber does not actually use any
slots, but it needs some replication origins, which is why you need to
increase the parameter.
This seems a little silly to me, but patching the server to add the new
variable is surely out of discussion for pg10. Should we change it in
pg11?
Also, do we want to add a footnote explaining this?
--
Álvaro Herrera https://www.2ndQuadrant.com/
PostgreSQL Development, 24x7 Support, Remote DBA, Training & Services
--
Sent via pgsql-docs mailing list (pgsql-docs@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-docs
^ permalink raw reply [nested|flat] 2+ messages in thread
end of thread, other threads:[~2017-10-02 13:12 UTC | newest]
Thread overview: 2+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2017-09-18 17:04 max_replication_slots in subscriber for subscription? jonny.battiato@gmail.com
2017-10-02 13:12 ` Alvaro Herrera <alvherre@alvh.no-ip.org>
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox