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 1utLX7-005Keb-S2 for pgsql-docs@arkaria.postgresql.org; Tue, 02 Sep 2025 07:34:26 +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 1utLX7-002Y7q-1p for pgsql-docs@arkaria.postgresql.org; Tue, 02 Sep 2025 07:34:25 +0000 Received: from magus.postgresql.org ([2a02:c0:301:0:ffff::29]) by malur.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.94.2) (envelope-from ) id 1utLX6-002Y7h-Pr for pgsql-docs@lists.postgresql.org; Tue, 02 Sep 2025 07:34:25 +0000 Received: from mail-wm1-x329.google.com ([2a00:1450:4864:20::329]) by magus.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_128_GCM_SHA256 (Exim 4.96) (envelope-from ) id 1utLX4-0008XD-0C for pgsql-docs@lists.postgresql.org; Tue, 02 Sep 2025 07:34:24 +0000 Received: by mail-wm1-x329.google.com with SMTP id 5b1f17b1804b1-45b83ae1734so20614735e9.0 for ; Tue, 02 Sep 2025 00:34:22 -0700 (PDT) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=cybertec.at; s=google; t=1756798462; x=1757403262; darn=lists.postgresql.org; h=mime-version:user-agent:content-transfer-encoding:references :in-reply-to:date:cc:to:from:subject:message-id:from:to:cc:subject :date:message-id:reply-to; bh=98syCCG5g66ZxxD2t11efo/MDMla3tQV3upjZT/5/mA=; b=Ng6ow+BPh9AO9+9H/YWTmvJc8jL/1hQ3nB7TE2YJBVElKxCoJCBn2W3rY+Fz0rPUhQ Fyl4rBcfwE6g9smFPRC0bWnPNHkma3CFzdWrQOwyrpp5f8aQNA5MxFJ0eREVneo/jb1K UM8H7sCKWplRvJEk9ByNRvR34gOPeVevFkVlKL1gss6i3Q6BZLaPYHEoHS9LZMpyI8Js wIrkwKdkulu5vnAILO5smOBR606qYa/FXt63/N7t/mssFVk7Y2qkJud3PJt1/sODWqG7 T9gWW8kWrvFFy3F3jzCSf+23Or4x+PWFLbRZR3/sHl848M3qdkvIFng5+zEFxaiW1SYs u7UQ== X-Google-DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=1e100.net; s=20230601; t=1756798462; x=1757403262; h=mime-version:user-agent:content-transfer-encoding:references :in-reply-to:date:cc:to:from:subject:message-id:x-gm-message-state :from:to:cc:subject:date:message-id:reply-to; bh=98syCCG5g66ZxxD2t11efo/MDMla3tQV3upjZT/5/mA=; b=FihTTqlIxWcUuKAYsodTiL7bj6H3rc4SaJLxE4lxE271k1/qBDtErnkNsf9CUEokF6 wR+m9HNMeXpI8yYmYzeBDuci3vdOyXRB5QA5ElJgZlnWIscJtOmCsLzg/mUEjtHilHgx Q8gXb4EmX0Nd89U1dN2U2yU5992mQ4jamjfUKHpjZH6FvlnRKrqp/vkCZQDmZXnpDfxe WDATQDNJOnmYB9+aswaiIrhVgQ0ZYQWtgRG5tWwfaMFpuwYNTN58QAa26+S/hOszx/Yw rDlXRDOcWQ3OG3kHf2TRYgbXbNi3hO7YTBhuKR8sNW8AkL6yfvl0+BFpb8dpC3PF3g90 wygg== X-Gm-Message-State: AOJu0YyFHIbLlAHvB0XtW/xWg8C5yG+LTuzybNcJjKMFcwGqjwcE0YGC Wq6LFdx573OL4TRYVNT3x2wWL3UISI9xSQQvahUyrdeDp5LjjZ0texGb3ORDBh8hrqEGzMp3Qg1 2BuoFFVw= X-Gm-Gg: ASbGnctVjnrktVGuALcDuYYEi/YQB5K/Kek9ynoCpP4uD4NtBbvEUaGAaqAUQG3Qoeh ZiJu44sm1jqZVR5YfJRf9bD/TJLW28ke7Wa9Cn7qVzYFne8X3ywdY0SNrB3m2zVxjkiffxbZY0/ vdsNWyLXbuFNOfEuerORrcb0QR4mVaCJ/3DTrJZsSmbBm8tjhDzdyY9X5LjiFrusuAvTLFF0Ub2 AbXbzusGbRZ5apI5Y4eS6rg0ewYvie3ex0K4KSkL3X2vJjQxjRZgmpkgIc0h4o/+E1D/3LR5jN+ 3tSRkBh4rp3Iywm49Z5/mHeNnJnnsYBJL2POJOs6jetzOzvv/WGrZW8UbMTFtk3NyruBHYYgJxC zA8BhQJLbe6jluy/h1mPGTlclWPMpg3GmO9RLt89u9NglZNKzMLP0xQ== X-Google-Smtp-Source: AGHT+IGZiN4a8nWslB7FNJYEBeyZiZMth7cou30fyEwGuf1Z1v38BPw8PhsnYieJu5WBO9OZtCqhAA== X-Received: by 2002:a05:6000:188f:b0:3d5:2c3f:99c0 with SMTP id ffacd0b85a97d-3d52c3fa1a5mr5697235f8f.5.1756798461668; Tue, 02 Sep 2025 00:34:21 -0700 (PDT) Received: from laurenz.albe-K4N0CV00F97414D ([2001:871:260:4d40:896e:d702:196e:5a83]) by smtp.gmail.com with ESMTPSA id ffacd0b85a97d-3d690f2edf1sm7758821f8f.16.2025.09.02.00.34.21 (version=TLS1_3 cipher=TLS_AES_256_GCM_SHA384 bits=256/256); Tue, 02 Sep 2025 00:34:21 -0700 (PDT) Message-ID: <93913aeb398b264ca0dc781095d36d6ad2d3be71.camel@cybertec.at> Subject: Re: Inaccurate statement about log shipping replication mode From: Laurenz Albe To: Artem Gavrilov , Michael Paquier Cc: pgsql-docs@lists.postgresql.org Date: Tue, 02 Sep 2025 09:34:20 +0200 In-Reply-To: References: <175578964049.806.14564779365418625473@wrigleys.postgresql.org> <568ff8638e011b2726d06a4b95124ec51ee1e5af.camel@cybertec.at> Content-Type: text/plain; charset="UTF-8" Content-Transfer-Encoding: quoted-printable User-Agent: Evolution 3.56.2 (3.56.2-1.fc42) MIME-Version: 1.0 List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk On Mon, 2025-09-01 at 13:51 +0200, Artem Gavrilov wrote: > 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? I don't quite understand. Sure, you can have synchronous replication between the master and upstream. It is the "isn't always async" part that confuses me. Do you mean that WAL can reach downstream before the master commits? That is certainly the case. Yours, Laurenz Albe