From: Peter Eisentraut <peter.eisentraut@enterprisedb.com>
To: Padmakumar Kadayaprth <padmakumark26@gmail.com>
To: PostgreSQL mailing lists <pgsql-bugs@lists.postgresql.org>
Subject: Re: Postgres HA and Pglogical
Date: Wed, 12 Jan 2022 12:16:37 +0100
Message-ID: <a0729a0f-aa19-f617-bc0f-244669de4231@enterprisedb.com> (raw)
In-Reply-To: <CAMjUpCqtLZE8pGDKbLibVV_ecPm-utqMkfJaLytL+c-5_KOCLg@mail.gmail.com>
References: <CAMjUpCqtLZE8pGDKbLibVV_ecPm-utqMkfJaLytL+c-5_KOCLg@mail.gmail.com>
This is the bug reporting address, and what you are writing is not a bug
report.
What you are asking about is very complex and will probably involve many
different software components with specific configurations and
nontrivial interactions. That's not something someone can answer in a
single email in their discretionary time. I think you need to do some
more research on your own or hire some help.
On 09.01.22 09:18, Padmakumar Kadayaprth wrote:
> 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
>
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-bugs@postgresql.org
Cc: peter.eisentraut@enterprisedb.com, padmakumark26@gmail.com, pgsql-bugs@lists.postgresql.org
Subject: Re: Postgres HA and Pglogical
In-Reply-To: <a0729a0f-aa19-f617-bc0f-244669de4231@enterprisedb.com>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox