Hi ^^
I want to synchronize two master DB clusters. (Each generates its own DML statements)
I'm using postgresql-10 server.
I know BDR can synchronize two master DB clusters.
But current BDR2 cannot synchronize postgresql-10 servers.
As I know, upcoming BDR3 can synchronize postgresql-10 servers but I cannot afford to pay for it. ( $9,000 per server and I'm startup. )
I'm considering two methods.
(1) Retain postgresql-10 server and find some method to synchronize two master DB clusters.
- I know logical replication cannot deal with my problem. ( it's one direction only )
- Is there other method to use ?
(2) Downgrade my DB server to 9.4 and use BDR1 for synchronizing.
- As I know, I can use BDR1 for free now.
- I'm using basic functions of postgresql-10 so I think downgrading itself may not cause big problem. But I'm worrying about unknown problem.
- Are 9.4 and 10 different significantly?
- Can I upgrade my 9.4 data to 10 later ? This is what I really worry about.
Could you give me any idea ?