Postgres HA and Pglogical

From: Padmakumar Kadayaprth <padmakumark26(at)gmail(dot)com>
To: PostgreSQL mailing lists <pgsql-bugs(at)lists(dot)postgresql(dot)org>
Subject: Postgres HA and Pglogical
Date: 2022-01-09 08:18:01
Message-ID: CAMjUpCqtLZE8pGDKbLibVV_ecPm-utqMkfJaLytL+c-5_KOCLg@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-bugs

Dear All,
I am not sure this is the mailing list to which I have to send this
issue.If you know the correct mailing address please let me know or forward
this mail to that address.

Issue i am facing is as follows
I am on Ubuntu ,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. 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,
Padmakumar

Responses

Browse pgsql-bugs by date

  From Date Subject
Next Message Alexander Lakhin 2022-01-09 17:00:00 Re: BUG #17116: Assert failed in SerialSetActiveSerXmin() on commit of parallelized serializable transaction
Previous Message Tom Lane 2022-01-09 00:38:41 Re: BUG #17358: While using --with-uuid=bsd option, uuid_ossp test fails on NetBSD 9.2