Sorry Bhargav.
I tried to simulate the scenarios,
3 node cluster
1primary, 2hot standby
given:
max_replication_slots = 2 on primary, and i try to create 2 hot standby -> runs fine.
max_replication_slots = 1 on primary, and i try to create 2 hot standby -> gives PANIC, increase replication slots. (the standby only cries with replication slot does not exist, not increase number of replication slots)
max_replication_slots = 2 on primary, and max_replication_slots=1 on hot standby, delete recovery.conf and recover from pg_baseback works fine.
max_replication_slots = 2 on primary, on standby i try to use a replication_slot already existing, it gives correct error of slot in use and not increase replication slot error.
my pg_replslot folder is consistent of the replication slots i have on the master.
so i guess, i'll leave it to the experts.
but i still do not understand why would you get that error on standby, unless you are doing cascading replication.
I'll watch this thread to see how this is resolved.
Thanks,
Vijay
