From: Simon Riggs <simon.riggs@enterprisedb.com>
To: sbob <sbob@quadratum-braccas.com>
Cc: pgsql-admin <pgsql-admin@postgresql.org>
Subject: Re: Can I make logical replication behave like synchronous streaming?
Date: Thu, 21 Oct 2021 14:18:29 +0100
Message-ID: <CANbhV-FyRYDntBWzcoOPqxPh5MhK3E-HySQMSMSdEExzb05OXg@mail.gmail.com> (raw)
In-Reply-To: <8381e958-e437-cc8c-f912-02bfd420cead@quadratum-braccas.com>
References: <8381e958-e437-cc8c-f912-02bfd420cead@quadratum-braccas.com>
On Wed, 20 Oct 2021 at 22:47, sbob <sbob@quadratum-braccas.com> wrote:
> We are going to be replication across platforms (risc ti intel), so we
> will be using logical replication (PostgreSQL v11)
>
> However we need a synchronous solution as opposed to async.
>
>
> Does logical replication perform like synchronous streaming? If not can
> I force it to do so?
Yes, it is designed to use the same connection interfaces.
https://www.postgresql.org/docs/devel/logical-replication-subscription.html
Note that sync rep in this mode is equivalent to synchronous_commit =
remote_apply.
--
Simon Riggs http://www.EnterpriseDB.com/
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-admin@postgresql.org
Cc: simon.riggs@enterprisedb.com, sbob@quadratum-braccas.com
Subject: Re: Can I make logical replication behave like synchronous streaming?
In-Reply-To: <CANbhV-FyRYDntBWzcoOPqxPh5MhK3E-HySQMSMSdEExzb05OXg@mail.gmail.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