Date: Thu, 11 Aug 2022 21:09:31 -0400
From: Bruce Momjian <bruce@momjian.us>
To: Sacheen Birhade <sacheen.birhade@veritas.com>
Cc: "pgsql-novice@postgresql.org" <pgsql-novice@postgresql.org>
Subject: Re: switch between async to sync automatically
Message-ID: <YvWoS4bgr9cFPo47@momjian.us>
References: 
 <MW4PR20MB4525084D8A9384F105A433C2F39F9@MW4PR20MB4525.namprd20.prod.outlook.com>
MIME-Version: 1.0
Content-Type: text/plain; charset=us-ascii
Content-Disposition: inline
In-Reply-To: 
 <MW4PR20MB4525084D8A9384F105A433C2F39F9@MW4PR20MB4525.namprd20.prod.outlook.com>
Archived-At: 
 <https://www.postgresql.org/message-id/YvWoS4bgr9cFPo47%40momjian.us>
Precedence: bulk

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