pg_replslot # ls -lrth total 4.0K drwx------ 2 postgres postgres 4.0K Oct 14 14:55 replication_slot
On Mon, 15 Oct 2018 at 02:11, Vijaykumar Jain <vj...@opentable.com> wrote: > ok wait, you data directory path may be different :) > i mean wherever your pg data dir is, from there find pg_replslot folder > and list the contents of it. > > Regards, > Vijay > > > On Mon, Oct 15, 2018 at 2:10 AM Vijaykumar Jain <vj...@opentable.com> > wrote: > >> i guess he is trying to confirm if the value of max_replication_slot is >> the same on all the master and the standby nodes. >> >> also, >> >> I am trying to shoot in the dark. >> >> can you give the output of (on master) >> ls /var/lib/postgresql/<pg_version>/main/pg_replslot/* >> >> also the value of max_replication_slot on the master and all the >> standby's. >> also, how are you creating the replication slot? >> >> can you share the query? >> >> also pls share the content of the recovery.conf on the standby nodes >> (both currently running and currently not running). >> you can scribble company secret stuff. >> >> >> Regards, >> Vijay >> >> >> On Mon, Oct 15, 2018 at 1:58 AM bhargav kamineni < >> bhargavpostg...@gmail.com> wrote: >> >>> 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 <and...@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 >>>> >>>