Re: Slot issues

From: Andreas Kretschmer <andreas(at)a-kretschmer(dot)de>
To: pgsql-general(at)lists(dot)postgresql(dot)org
Subject: Re: Slot issues
Date: 2018-10-14 19:03:40
Message-ID: a6b21fda-bb11-300d-9596-32526b51bb81@a-kretschmer.de
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Am 14.10.2018 um 20:45 schrieb bhargav kamineni:
> 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 ?

please check on the master how many slots are in use:

select * from pg_replication_slots ;

please also tell us the exact version you are using.

Regards, Andreas

--
2ndQuadrant - The PostgreSQL Support Company.
www.2ndQuadrant.com

In response to

  • Slot issues at 2018-10-14 18:45:53 from bhargav kamineni

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Andreas Kretschmer 2018-10-14 19:09:17 Re: [External] Slot issues
Previous Message Vijaykumar Jain 2018-10-14 19:02:16 Re: [External] Slot issues