On Wed, 20 Oct 2021 at 22:47, sbob <sbob(at)quadratum-braccas(dot)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/