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.96) (envelope-from ) id 1w28Qe-0001JD-0w for pgsql-bugs@arkaria.postgresql.org; Mon, 16 Mar 2026 13:56:20 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.96) (envelope-from ) id 1w28Qc-00AFwc-1b for pgsql-bugs@arkaria.postgresql.org; Mon, 16 Mar 2026 13:56:19 +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.96) (envelope-from ) id 1w28Qc-00AFwT-0l for pgsql-bugs@lists.postgresql.org; Mon, 16 Mar 2026 13:56:19 +0000 Received: from mail-lf1-x132.google.com ([2a00:1450:4864:20::132]) by makus.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_128_GCM_SHA256 (Exim 4.98.2) (envelope-from ) id 1w28QZ-000000001JX-0XDe for pgsql-bugs@lists.postgresql.org; Mon, 16 Mar 2026 13:56:18 +0000 Received: by mail-lf1-x132.google.com with SMTP id 2adb3069b0e04-5a12c19affeso6308581e87.1 for ; Mon, 16 Mar 2026 06:56:16 -0700 (PDT) ARC-Seal: i=1; a=rsa-sha256; t=1773669375; cv=none; d=google.com; s=arc-20240605; b=Vj9jmJph0s9DcT+qwVo2u/QGUjQl1NMy+W4+q0rpIcrbeDPjnjuOhiDwK/ftTf8mXM lQZSdD/sys8vMSIhzRJyumphSNrQOG1Trg8TNFnTeYwKrshNv34yvUwQZc57ztkYGd/5 hZcUSbS6m+z01s+l7N8y0Znl2NIImXWq6Kt3btBdLsg1kChSIGDl40hLpaZ8cefI2WuT hIpH1RUCwNTtce+jbT9+jOTTkQ5xaKM7GErecmD7XuE6iHbouN658JQ1sFJ7yb8Wgh5l NybJy7ZQm6lu4LNUKl6r9l5Ov/AJF0c3D91YywY5HjNFsZzImjkbvP/X9MvUNcujnuRn l8rA== ARC-Message-Signature: i=1; a=rsa-sha256; c=relaxed/relaxed; d=google.com; s=arc-20240605; h=content-transfer-encoding:cc:to:subject:message-id:date:from :in-reply-to:references:mime-version:dkim-signature; bh=NzmnCScOZXv8XCRrdMB7bUVatmSJmopciONHenrRHb4=; fh=vR25N3+d8dNHUTLhu+5NPbhqmVDzmSWekj9cOnxEonw=; b=jWkopsssIMZ3IeruPNka3t1dXSP7VLuQUdb6cbnNBT+d0q9GiovtHI7GREy1seqvN/ PncE+ryCL52gNv3+oA4v5wDJPwsMcDQlOQkPmd2L/VIe++YyFYfti28INUeQCmx6i7hr qW2QOiT4KKOFsLe0lu734ZvzYT5HuBpJbr1BX0VFyNauJcJbcrcQ2EoNF4PLe360EJ99 akq5ySi1tE+MIhWzas7tRHKePxyVXJokQ4osUSq1mNzZb7xtlxbSAsU1iJjsUS0pXLdg FjxKuwnosQQzHxD4f4EwT+Z8L/CRYH7vvVtN1vAJa0Itzs381bpoq4QvmsgViW/r0sYp xhug==; darn=lists.postgresql.org ARC-Authentication-Results: i=1; mx.google.com; arc=none DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=ionos.com; s=google; t=1773669375; x=1774274175; 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=NzmnCScOZXv8XCRrdMB7bUVatmSJmopciONHenrRHb4=; b=gEvbC2aS4nVc7QPLyUaHHMTgWUnduCIKsl1TfB8l5CayrTw18ijFxTABOnAjMZkcH1 oZMYGkk7uvj+UgqpJfnIaYAplWm3lVG/5Sd1FzS28u/hsdCbiaayOdgexA1LXvhDR6P9 u03yZ2pvkxiCR81RJwEC4GO9QpczzjfAA0VlCayls+PXoJ2vpv3nVK2vK75EtmUludu0 NZQAoFhYr4o3W3fv76UuBwL2qK/3gze9THi8oaaUGPHx/5eS2raUwNNeGMK55WBFoS0I 3m6XCBpKj6bkrJlVfBEmBfCzn1bl5ayMirIUapFQZQ02kFZGzDE+l1PFv+eRxbmv3dZX bEzA== X-Google-DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=1e100.net; s=20251104; t=1773669375; x=1774274175; h=content-transfer-encoding:cc:to:subject:message-id:date:from :in-reply-to:references:mime-version:x-gm-gg:x-gm-message-state:from :to:cc:subject:date:message-id:reply-to; bh=NzmnCScOZXv8XCRrdMB7bUVatmSJmopciONHenrRHb4=; b=PMt/Aix5GhthZfkedWMEGz4oTouy72/UXsW50EsjJb0kNk5cM/HZK1nkZKd4dlH1EE AedJtC3A1b/XEfBpy28hHCo1qt4nd+8oZfV+fTwgFHaRwU6ry3K6nTupyXGKiL57d+0p sMgIIunyrx9Lt+qKhR0tq1hgFoG504yOce6SV4t+iBkZG5XFvHCe1MNYOMX8uy8b23Bp Xe5iNzUPczq4N1JADDdOg6CjybT+P/jupMa6VPu3tbDdNNyqDMhR0dVJTHgYKKkx7Uuw 5KkaMr6gBb0cMMzyyk+8GdJdoPm95WFH0kSbB/pVdpEu52+VPbDI+zbUGdiCnn9TWM1u hmaA== X-Gm-Message-State: AOJu0YxyQhxFfDeCNjnpeNgR4hHzt/6jsxvnUnxuTUD+aRWK39D5npQT 4nzL95LCgztA8xL7J5f06dZxVKzEumxfD6uwTcbv0bzmi1822ZVdSgW8BlHj+j0PB47Ysax4GZm lW26mvhSvfIyKk3b9SWj6MmwbE8vfQt4LsUU4YyPWKw== X-Gm-Gg: ATEYQzzJT/MGu503Aquc/h/zQE8Ucuyi0lmYYLCcG7O27SBvmlg/P62UGMgzcFBsiXe tR1g4Mr1/EAfcL8sQV8mAv2X1G2h4nQprH4Wod3cR2lcQLuNW5jiKpAH3J3LudBh1AtPQ5v6a2l 68Dbw8sJiykVEsfFkb+Eakj/sYT0rM/VDFeH0Z8tV016OcK5t8700Hlyh0nKMhn221oBDqQm/J/ EI1yBeSaTjy4CQrxNKChE94i7SohP/D3zhKyzvy/DJ0oyVTerriSe/qWE8MEdgKtjkZRWYfVfQl TUYDMXMrm5Uy8V9T7fR25H/GXoAyeE2NaXRM/TQQCQ== X-Received: by 2002:ac2:5bc8:0:b0:5a1:5ac6:8312 with SMTP id 2adb3069b0e04-5a15bc5c8e6mr4140969e87.7.1773669374583; Mon, 16 Mar 2026 06:56:14 -0700 (PDT) MIME-Version: 1.0 References: <19432-3c569e9472f42cee@postgresql.org> <58ceb75034bf694d52f81e898df35e14122fe5c8.camel@cybertec.at> <7b029b1636b24069bfc0d3a779e0a5521f60e57f.camel@cybertec.at> In-Reply-To: <7b029b1636b24069bfc0d3a779e0a5521f60e57f.camel@cybertec.at> From: Felix Hamme Date: Mon, 16 Mar 2026 14:56:03 +0100 X-Gm-Features: AaiRm522JXsesgcAI9nql88ZPSSfSSMFopccyva4wGUAzCeM31vIvbO81WsXO7w Message-ID: Subject: Re: BUG #19432: recovery fails at invalid checkpoint record To: Laurenz Albe Cc: pgsql-bugs@lists.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 Timeline history files can be needed multiple times, ok. My question was about WAL files only. I'm tempted to use a restore_command which does cp for history files and mv for WAL files, to optimize performance and disk usage. An AI told me that a second restore attempt for the same WAL file could only happen if recovery is resumed after a crash. Kind regards Felix Hamme On Fri, Mar 13, 2026 at 5:37=E2=80=AFPM Laurenz Albe wrote: > > On Fri, 2026-03-13 at 09:35 +0100, Felix Hamme wrote: > > Is it safe in general to use mv for wal files? In other words, do the > > currently supported postgres versions run restore_command only once > > per wal file? > > As you found out, no... > > Yours, > Laurenz Albe