What was the whole point of this divergence :)
We use replication slots and it is for this reason we are able to scale our
applications by redirecting reads and writes backed by haproxy and
pgbouncer. with the health check of replication lag. It works awesome and
at a much much lower cost to what
ah that explains.
Thanks andres.
I do not use rsync, hence was not able to reproduce i guess :)
Regards,
Vijay
On Mon, Oct 15, 2018 at 2:46 AM bhargav kamineni
wrote:
> Yeah i have used rsync , Got it now will increase the
> max_replication_slots to high enough , Thank you Andres Freund :-)
>
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.
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 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 t
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 wrote:
> i guess he is trying to confirm if the value of max_replication_slot
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//main/pg_replslot/*
also the value of max_replication_slot on the maste
