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 1sUtpY-006WTg-Pt for pgsql-hackers@arkaria.postgresql.org; Fri, 19 Jul 2024 20:03:52 +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 1sUtpW-00556N-Cu for pgsql-hackers@arkaria.postgresql.org; Fri, 19 Jul 2024 20:03:50 +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 1sUtpW-00556E-36 for pgsql-hackers@lists.postgresql.org; Fri, 19 Jul 2024 20:03:50 +0000 Received: from mail-ed1-x52c.google.com ([2a00:1450:4864:20::52c]) by magus.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_128_GCM_SHA256 (Exim 4.94.2) (envelope-from ) id 1sUtpT-000R7G-T8 for pgsql-hackers@postgresql.org; Fri, 19 Jul 2024 20:03:49 +0000 Received: by mail-ed1-x52c.google.com with SMTP id 4fb4d7f45d1cf-5a3b866ebc9so638622a12.3 for ; Fri, 19 Jul 2024 13:03:47 -0700 (PDT) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=20230601; t=1721419427; x=1722024227; darn=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=YyD9CRBPGvNhyAjY/DDkGjaQuZBEn1iQOwbxP7BT2PI=; b=iZxVrlB3DY2qqpxRwFWS43b/JI2WxakzpDqnzgpgF9aEunaFD7NT+hQS+0oTUFh0cm uW+Obdu/INh2Rwy1mVS4V4CTimz78mrYugk2pnnh9zMEauiff6Ez+IlVAL2DsqXyA7iX 7x0I70C0QuUHmiJGO1AC/Ov5NcvS0QTKGXTOwPrnJ0/9Z6w+0x3l+LK3t3NYTGNI+uT7 tBkUMc2TWZBWCaTwRmzCS2Ym5S60EwvWupaLlPGyJHeOWQr739DoD/cUOsTuytJkrB5P Y2+H3ELnzXf/gWV3W///nuG+bdThQqm4tQHTFqkaIulWzz7gREmHB0MrestjaG7psqaB WAPw== X-Google-DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=1e100.net; s=20230601; t=1721419427; x=1722024227; 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=YyD9CRBPGvNhyAjY/DDkGjaQuZBEn1iQOwbxP7BT2PI=; b=F9BTPBIBhUc0HsLhymIyHBH7ZYYPzsnKXZjT1FWWFORkSkTVBZpjSRRmOaM0b3BqRf Itf+ttRpx/tFM4UchTGOddYIiU4pmza/pOLCZVz9atGQPJOOCOMRxmXkIe5DXOLWUD9R bJrH9hgWJCyUMG4kqcDuSUE01YP1eH1bp1faXUsgIbqvbmgybe2hb63y0O5jkZZK49Fh OMGnan6WHnpdRFgRgRGayU2FnIOgmQ4B//vEl2GC/EWnV6Pv2QkBuFsX/ORRnSuucn4j UzdJS7th8hxInRrrIlvhdfM7M5x1ETNVzaXP5yj6WfOJxJ3vuUFCUWw1oOj/4jAipih7 Y7VA== X-Forwarded-Encrypted: i=1; AJvYcCVOLvHIPXt6BF0YcJ9H8U0nL6IQUicu354c4qE61D7bjqChC0NWiN/y83xPjDn/KSS+PUIx4em7XEsWJ6HRptLuRGUn8FEwtvV+GjmX X-Gm-Message-State: AOJu0YyHHRvqdBxmXE7XmCyj6yXUx5Qdcc9KoNUH74kD87+o8YEOhjJT qRmwp0iMIBmg0Mrse41OZi8fOv+sr958oSXM6oQ7FHQ1ejZnGwzUUk0a+6roP8nSeeOm5OajPsz T4ADmJzIf5qtHtOrmOw65/FXicEq9bQ== X-Google-Smtp-Source: AGHT+IEmqRvo+jU+E1JElMFoIzkb1PgHYs7oACCGJ4owoUrnEIQA0IkFU0XrZoSpZ36yPP7FTr9lsHcHaXhYR7KAwpo= X-Received: by 2002:a17:906:d191:b0:a77:e94c:5bf with SMTP id a640c23a62f3a-a7a0135ed3fmr652180766b.61.1721419426539; Fri, 19 Jul 2024 13:03:46 -0700 (PDT) MIME-Version: 1.0 References: <04f4277e5ed4046773e46837110bed1381a2583f.camel@cybertec.at> <5468641ad821dad7aa3b2d65bf843146443a1b68.camel@cybertec.at> <985825083da240ef8f3e32e2f49fc93fe1aeac7e.camel@cybertec.at> In-Reply-To: <985825083da240ef8f3e32e2f49fc93fe1aeac7e.camel@cybertec.at> From: Robert Haas Date: Fri, 19 Jul 2024 16:03:34 -0400 Message-ID: Subject: Re: Incremental backup from a streaming replication standby fails To: Laurenz Albe Cc: David Steele , pgsql-hackers@postgresql.org Content-Type: text/plain; charset="UTF-8" Content-Transfer-Encoding: quoted-printable List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk On Fri, Jul 19, 2024 at 2:41=E2=80=AFPM Laurenz Albe wrote: > I'd be alright with the hint, but I'd say "during making an *incremental* > standby backup", because that's the only case where it can happen. > > I think it would also be sufficient if we document that possibility. > When I got the error, I looked at the documentation of incremental > backup for any limitations with standby servers, but didn't find any. > A remark in the documentation would have satisfied me. Would you like to propose a patch adding a hint and/or adjusting the documentation? Or are you wanting me to do that? --=20 Robert Haas EDB: http://www.enterprisedb.com