Hi Jeremy,
> Why don't you consider upgrading from postgres 9.4 and with it to a supported version of BDR? There is nothing better you can do to keep your infrastructure up to date, performant, secure, and actually meet your multi-master needs than to upgrade to a newer version of postgres which does have BDR support.
This is something that we have definitely thought of. That would be a good alternative but I have an strong feeling that the business won't be willing to pay for it. The cost of the paid BDR version, in comparison with the current fixed expenses of the infrastructure, are just too large. That's why we are researching alternatives.
The problem is that the version for BDR 1.0.7, which has an implementation for postgres 9.4, will be on end of live at the end of this year. Unfortunately the paid solution is out of our budget, so we currently have two options: find an alternative or remove the multi-region implementation. We are currently looking for alternatives.
You are missing all of the alternatives here. Why don't you consider upgrading from postgres 9.4 and with it to a supported version of BDR? There is nothing better you can do to keep your infrastructure up to date, performant, secure, and actually meet your multi-master needs than to upgrade to a newer version of postgres which does have BDR support.
Even "stock" postgres 9.4 is set for end of life soon. Upgrade!
Thanks,
Jeremy