Received: from malur.postgresql.org ([217.196.149.56]) by arkaria.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.94.2) (envelope-from ) id 1ut34v-00F5Pw-DO for pgsql-docs@arkaria.postgresql.org; Mon, 01 Sep 2025 11:52:05 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.94.2) (envelope-from ) id 1ut34t-005wxL-Sk for pgsql-docs@arkaria.postgresql.org; Mon, 01 Sep 2025 11:52:03 +0000 Received: from makus.postgresql.org ([2001:4800:3e1:1::229]) by malur.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.94.2) (envelope-from ) id 1ut34t-005wxD-K7 for pgsql-docs@lists.postgresql.org; Mon, 01 Sep 2025 11:52:03 +0000 Received: from mail-ej1-x62f.google.com ([2a00:1450:4864:20::62f]) by makus.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_128_GCM_SHA256 (Exim 4.96) (envelope-from ) id 1ut34r-002q4M-18 for pgsql-docs@lists.postgresql.org; Mon, 01 Sep 2025 11:52:02 +0000 Received: by mail-ej1-x62f.google.com with SMTP id a640c23a62f3a-afcb732eee6so738065366b.0 for ; Mon, 01 Sep 2025 04:52:01 -0700 (PDT) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=percona.com; s=google; t=1756727520; x=1757332320; darn=lists.postgresql.org; h=content-transfer-encoding:cc:to:subject:message-id:date:from :in-reply-to:references:mime-version:from:to:cc:subject:date :message-id:reply-to; bh=zr2plPtwUuJFEzDlEZVAFWMmDfucz7XtksQQUr2rGho=; b=RVfJowAIV8lwk6IoAR+/LNn/53rWz7ijvQR6I3HSllMx62xaIdzLTPRZGhUeOFmr6i px4e6t9Wf0bnCNqIZJD+xU+gB7WX9d7Sc+RCZgjp06qGOfBGZAnEOaNLzR3Syk05bvBM 0HCL5TpejAQENB3hCyL0XugPYJ9oWwPUw7LDk= X-Google-DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=1e100.net; s=20230601; t=1756727520; x=1757332320; h=content-transfer-encoding:cc:to:subject:message-id:date:from :in-reply-to:references:mime-version:x-gm-message-state:from:to:cc :subject:date:message-id:reply-to; bh=zr2plPtwUuJFEzDlEZVAFWMmDfucz7XtksQQUr2rGho=; b=VBE/GmXNC///CsasYR1PyuOrPONahCc5FZE4rV5Wph5Oz34GCgMTmB6MYMZJkyhEYR pkgeSjLyFaoCJjgnH/gr7EbKjFUfWDxdnSpUwRmX8qf9J7405MbntohRybV9asP2ZL7i cfe7hnXQrBN/BaWxCMgLoA3KfDqBYES38S0QdCxzW2Vb6nejAkWjE7QxhZrkeRMyQmcb TZ1S8amxN4yDITp8DnlpiPVugHlNz97FE8+uaYu6FOo07WSUla1ENN7imR+yZGn/r3ev rUE4H6nBvcb27yPRtXNbKw10TGvy6/ivcBKcTxpPCnaJhDLUI3GwQpnqqA9aKX6Np/w9 sgMA== X-Forwarded-Encrypted: i=1; AJvYcCU3eU05JN3/fzL1vJ0EImH3gu3FnmWDjjZv410vuX/tXPSomPHd7G+7Gf8n0Wyd6QpI/zZSyarz+jNC@lists.postgresql.org X-Gm-Message-State: AOJu0YxCztq/zQl5RxzyQQuQ93TIdgd1FHLWbswYhbYbE41ZWjCMlMz3 O4ZCCtAxO31PulodALTxEY4nefdrsTRrbIQvW96fcqeiyv1TCAv3ybcXWaz4LFgXNdny6JuBILb RJSpZDjKBjHUq4aXFKh6IFdzn92jMgc/27xRpIC2SOsYXVnjLgbIx8ZIKqY3Aza9vvrKzkxrTe6 atLutSkQHW1KK/9llXwG42KvefMTmKpRRoKwIEQA5ShNSpScsmjIArN4b9TpfmhTLYA5NaVM5/W mdNpFGtMS81qOzwKr6PnuSeVDCAj7gbWH4K14qsaY4M4iBiN2AgCgXExwY= X-Gm-Gg: ASbGncuPBJoGHD8YsBEnXO1JwwrQiIxAr2gLVpdfiXYi3SVhCqgLkoQZUiaklxJTgS6 Gf6hqJ2kRRyl3TnFv+zHhFn9O/UNSy2AKd9Hig3Dbl75f67IY3aAJ3AL67K5debQQ9m3fazfHSF 0b3FvrbxK2jWGBQeYZKk4TKrEG/bSWDXikACnQLHyU5u2fiI8ifmtALTGSy1Lbaw8QQB8de7cCQ mdjsKD4yyubApmnLw4= X-Google-Smtp-Source: AGHT+IF6vcV+DHRv4irYg1rITlTvUuFHI5zeJ5euCU9iudnBYER7fi/J0dxdidIA/1ksazWDmbbv8W5xJkftQ8+dWgg= X-Received: by 2002:a17:907:3c8d:b0:afe:ca26:547b with SMTP id a640c23a62f3a-b01d9719141mr635168066b.35.1756727519574; Mon, 01 Sep 2025 04:51:59 -0700 (PDT) MIME-Version: 1.0 References: <175578964049.806.14564779365418625473@wrigleys.postgresql.org> <568ff8638e011b2726d06a4b95124ec51ee1e5af.camel@cybertec.at> In-Reply-To: From: Artem Gavrilov Date: Mon, 1 Sep 2025 13:51:48 +0200 X-Gm-Features: Ac12FXw1U9CbKGfYTwYQMTYbAYao4TcA46PYqxYcVIwH6RdU7W4eieTs98dihpA Message-ID: Subject: Re: Inaccurate statement about log shipping replication mode To: Michael Paquier Cc: Laurenz Albe , pgsql-docs@lists.postgresql.org Content-Type: text/plain; charset="UTF-8" Content-Transfer-Encoding: quoted-printable X-CLOUD-SEC-AV-Sent: true X-CLOUD-SEC-AV-Info: percona,google_mail,monitor X-Gm-Spam: 0 X-Gm-Phishy: 0 List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk On Mon, Sep 1, 2025 at 1:20=E2=80=AFAM Michael Paquier wrote: > > Yep, the original statement is rather inexact. Now, your new wording > does not make me really comfortable with the case of cascading stanbys > in scope, because the asynchronous property applies to them all the > time. This is another unclear part. As I understand in configuration `Master -> Upstream -> Downstream` replication between Master And Upstream still can be synchronous, while between Upstream and Downstream is't always async. Am I wrong here? -- Artem Gavrilov Senior Software Engineer, Percona artem.gavrilov@percona.com