From: Alvaro Herrera <alvherre@alvh.no-ip.org>
To: jonny.battiato@gmail.com
Cc: pgsql-docs@postgresql.org
Subject: Re: max_replication_slots in subscriber for subscription?
Date: Mon, 2 Oct 2017 15:12:41 +0200
Message-ID: <20171002131241.wi4zgyf2mhbchgbe@alvherre.pgsql> (raw)
In-Reply-To: <20170918170450.17363.89758@wrigleys.postgresql.org>
List-Unsubscribe: <mailto:majordomo@postgresql.org?body=unsub%20pgsql-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
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-docs@postgresql.org
Cc: alvherre@alvh.no-ip.org, jonny.battiato@gmail.com
Subject: Re: max_replication_slots in subscriber for subscription?
In-Reply-To: <20171002131241.wi4zgyf2mhbchgbe@alvherre.pgsql>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
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