| From: | Andres Freund <andres(at)anarazel(dot)de> |
|---|---|
| To: | bhargav kamineni <bhargavpostgres(at)gmail(dot)com> |
| Cc: | pgsql-general(at)lists(dot)postgresql(dot)org |
| Subject: | Re: Slot issues |
| Date: | 2018-10-14 20:20:42 |
| Message-ID: | 20181014202042.gi6o3kitjvczc5ym@alap3.anarazel.de |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
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
| From | Date | Subject | |
|---|---|---|---|
| Next Message | bhargav kamineni | 2018-10-14 20:27:53 | Re: Slot issues |
| Previous Message | bhargav kamineni | 2018-10-14 20:09:44 | Re: [External] Slot issues |