Logical Replication extension for PostgreSQL 17, 16, 15, 14, 13, 12, 11, 10, 9.6, 9.5, 9.4 (Postgres), providing much faster replication than Slony, Bucardo or Londiste, as well as cross-version upgrades.
Issue i am facing is as follows I am on Ubuntu 20.04,postgresql 14 ,Pglogical for postgres 14
I have 35 branches and one regional site. All branches including regional sites have it's own transaction. All Transaction from branches will be replicated to regional using pglogical. Almost 50 Tables out of 350 tables.entire tables in the database are not replicated.
Now I need high availability in all branches and regional sites. Which is the best open source solution available with PostgreSQL which will support pglogical replication with high availability. In case of failover to secondary, how I will reroute my replication to regional without manual intervention. How I will make sure /control replication from branches to regional are happening only from current primary.
Which is the pooling /load balancing and virtual IP solution compatible with my solution using which i can connect to current primary in case of failover from application
Issue i am facing is as follows I am on Ubuntu 20.04,postgresql 14 ,Pglogical for postgres 14
I have 35 branches and one regional site. All branches including regional sites have it's own transaction. All Transaction from branches will be replicated to regional using pglogical. Almost 50 Tables out of 350 tables.entire tables in the database are not replicated.
Now I need high availability in all branches and regional sites. Which is the best open source solution available with PostgreSQL which will support pglogical replication with high availability. In case of failover to secondary, how I will reroute my replication to regional without manual intervention. How I will make sure /control replication from branches to regional are happening only from current primary.
Which is the pooling /load balancing and virtual IP solution compatible with my solution using which i can connect to current primary in case of failover from application
Thanks in advance