Re: Slot issues - Mailing list pgsql-general

From bhargav kamineni
Subject Re: Slot issues
Date
Msg-id CADCf-WPFr7JbVjjbTdqisdWbBVKg8QUx1=c=Mpa20OyraDwUXQ@mail.gmail.com
Whole thread Raw
In response to Re: Slot issues  (Andres Freund <andres@anarazel.de>)
Responses Re: [External] Re: Slot issues  (Vijaykumar Jain <vjain@opentable.com>)
Re: Slot issues  (Andres Freund <andres@anarazel.de>)
List pgsql-general
I got his on standby,  could you please explain in detail about 
 --but that *on the standby* haven't set max_replication_slots high enough.  

Thanks, 
Bhargav 

On Mon, 15 Oct 2018 at 01:50, Andres Freund <andres@anarazel.de> wrote:
Hi,

On 2018-10-15 00:15:53 +0530, bhargav kamineni 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 ?

You're getting that error on the standby, not the primary, right?   In
all likelihood the problem is that you copied over replication slots to
your standby server, but that *on the standby* haven't set
max_replication_slots high enough.

Greetings,

Andres Freund

pgsql-general by date:

Previous
From: Andres Freund
Date:
Subject: Re: Slot issues
Next
From: Vijaykumar Jain
Date:
Subject: Re: [External] Re: Slot issues