Postgres Pro
Downloads
Home   >   mailing lists

Re: switch between async to sync automatically - Mailing list pgsql-novice

From Bruce Momjian
Subject Re: switch between async to sync automatically
Date
Msg-id YvWoS4bgr9cFPo47@momjian.us
Whole thread Raw
In response to switch between async to sync automatically  (Sacheen Birhade <sacheen.birhade@veritas.com>)
List pgsql-novice
Tree view 
On Thu, Aug  4, 2022 at 07:40:56AM +0000, Sacheen Birhade wrote:
> Hi All,
> 
>  
> 
> Can my streaming replication switch between async to sync automatically
> depending upon bandwidth? If bandwith/replication link is very healthy, then I
> want async replication otherwise sync replication. It should switch between
> sync to async.

No.  We have discussed the option of going from sync to async if the
standby stops responding but never agreed on a safe API for this.

-- 
  Bruce Momjian  <bruce@momjian.us>        https://momjian.us
  EDB                                      https://enterprisedb.com

  Indecision is a decision.  Inaction is an action.  Mark Batterson

pgsql-novice by date:

Previous
From: Sacheen Birhade
Date:
Subject: switch between async to sync automatically
Next
From: Steve T
Date:
Subject: database encoding migration from a pg_dumpall set