Обсуждение: Can I make logical replication behave like synchronous streaming?
All; We are going to be replication across platforms (risc ti intel), so we will be using logical replication (PostgreSQL v11) However we need a sunchronous solution as opposed to async. Does logical replication perform like synchronous streaming? If not can I force it to do so? Thanks in advance
On Wed, 2021-10-20 at 15:47 -0600, sbob wrote: > Does logical replication perform like synchronous streaming? If not can > I force it to do so? Sure! Set "application_name" to some name in the CONNECTION clause of CREATE SUBSCRIPTION and use that name in "synchronous_standby_names" on the primary. Yours, Laurenz Albe -- Cybertec | https://www.cybertec-postgresql.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/