Re: [External] Slot issues

I guess max_replication_slots has to > current total slots in use. (and
not >= )

https://www.postgresql.org/docs/10/static/runtime-config-replication.html
https://github.com/postgres/postgres/blob/d6e98ebe375e115c29028f9bd090f0f7e07e2527/src/backend/replication/slot.c#L1506

from the doc, it says defaults are 10, any reason why you have set it to 2.
You need to set it at a value higher than number of slots active.
also, i guess changing this parameter would require a server restart.

Regards,
Vijay

On Mon, Oct 15, 2018 at 12:16 AM bhargav kamineni <bhargavpostgres(at)gmail(dot)com>
wrote:

> Hi Team,
>
> I am getting this ERROR while starting my second slave server
>
> PANIC: too many replication slots active before shutdown
> HINT: Increase max_replication_slots and try again.
>
> max_replication_slots on my master is 2 and one of them is already active
> for another slave,
> do i need to increase this parameter for the need of working of another
> slave ? if so whats the reason ?
>
>
>
> Thanks
> Bhargav K
>