Hub & Spoke Realtime Database Replication

Ignition
2

I would use PostgreSQL Logical replication for such a case. Make sure your primary keys are UUIDs, to avoid clashes when merging from multiple sources.