On Wed, 20 Oct 2021 at 22:47, sbob <sbob@xxxxxxxxxxxxxxxxxxxxx> 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/
