Re: [External] Slot issues - Mailing list pgsql-general

I guess max_replication_slots has to be greater than active replication slots.

maybe you need to increase max_replication_slots to 3 to have 2 active slots.

Regards,

Vijay

On Mon, Oct 15, 2018 at 12:54 AM bhargav kamineni <bhargavpostgres@gmail.com> wrote:

 for 9.x. Default was 0.  we have set max_replication_slot =2 , one is already being used , postgres should use  second slot for another server but dono why its throwing error 

On Mon, 15 Oct 2018 at 00:32, Vijaykumar Jain <vjain@opentable.com> wrote:

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@gmail.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