[ask] how to determine max_wal_senders

[OctopusRage]

im getting error [25360]:FATAL: number of requested standby connections exceeds max_wal_senders (currently 25) while replicating my production db
my db currently on RDS and have 2 slave
how to determin max_wal_senders to avoid getting this error?

[cpursley]

We need to add this as a config setting. I'll take a look int it next week (unless you'd like to submit a PR before then).

[cpursley]

https://hexdocs.pm/postgrex/Postgrex.ReplicationConnection.html#module-logical-replication

I think this might just be a database setting, I'll dive in deeper next week.

[OctopusRage]

aight thx, i got a hunch my connection restarting somewhere in the middle.. gotta monitor next try using pg_stat_replication

[OctopusRage]

running query below

select application_name, sent_lsn, write_lsn, state, backend_start from pg_stat_replication where usename = 'myapprepluser'

resulting this, why some states starting up and keep idle all the time?