Postgres Pro
Downloads
Home   >   mailing lists

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

From Vijaykumar Jain
Subject Re: [External] Slot issues
Date
Msg-id CAE7uO5hpt0CLjunq_93EdQoZ0+4W8GHkOmTdy9y8040FQ=4rZg@mail.gmail.com
Whole thread Raw
In response to Slot issues  (bhargav kamineni <bhargavpostgres@gmail.com>)
Responses Re: [External] Slot issues  (Andreas Kretschmer <andreas@a-kretschmer.de>)
List pgsql-general
Tree view
I guess max_replication_slots has to >  current total slots in use. (and not >= ) 


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

pgsql-general by date:

Previous
From: bhargav kamineni
Date:
Subject: Slot issues
Next
From: Andreas Kretschmer
Date:
Subject: Re: Slot issues