Hi,

so I got two questions:

1) I have multiple Postgresql Standby servers replicating over WAN, and I would like to reduce that to a single connection. Is there a utility that can be put in between and store the wal files from the primary and provide it to the standby server, even if they are delayed by > 1 day or more (provided there is storage?)

2) These standby servers sometimes run very long queries (2 - 3 hours) and at some point the replication stops, because I guess some row version which are used are removed on the master. I do have hot_standby_feedback "on", why does this still happen, shouldn't this prevent the removal on the primary and allow replication to continue even if queries are active?

Thanks
Thomas


Reply via email to