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 1w29Xy-0002Ij-0A for pgsql-bugs@arkaria.postgresql.org; Mon, 16 Mar 2026 15:07:58 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.96) (envelope-from ) id 1w29Xw-00Ai5c-0e for pgsql-bugs@arkaria.postgresql.org; Mon, 16 Mar 2026 15:07:56 +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 1w29Xv-00Ai5O-2t for pgsql-bugs@lists.postgresql.org; Mon, 16 Mar 2026 15:07:56 +0000 Received: from mail-wr1-x42d.google.com ([2a00:1450:4864:20::42d]) by makus.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_128_GCM_SHA256 (Exim 4.98.2) (envelope-from ) id 1w29Xt-000000001qA-1WLs for pgsql-bugs@lists.postgresql.org; Mon, 16 Mar 2026 15:07:55 +0000 Received: by mail-wr1-x42d.google.com with SMTP id ffacd0b85a97d-439c56e822eso4953286f8f.2 for ; Mon, 16 Mar 2026 08:07:54 -0700 (PDT) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=cybertec.at; s=google; t=1773673673; x=1774278473; 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=weonBL/72GMajE/gjJI4emooMITS/Y0W/1HWhoCu1l0=; b=Dpm3dwvI2H8x1xemJrapaEC5H5ywPZWKSK2NIH810/sTF9qkVtiZoEruOLjUj7vjAv 0DqzVeeez1Km2pvwwem9YJOec5U91u3Dpf2XNlvvdz9yMS06EAI+wi111kAv+jGpNc19 QE4nA8d+o6Fihv/TAXGDP/sT1UvTP9mZn87RUx4ASJ+TqSNWBVs0RkL7V9oas2Ydqu6b 5Z+9Gv+xpBCOg2laBM1OeFC4nR2FJUxOWmSzpKcBFbtIWctZqa8T25ZzjUK/+3N3o5oh n9KHg152PX9wvsy3gTXMGNVUWEjizaap7dCqZ7y8ICwpsA+kCfwJjE1fhHxKAH+fVW7g 8QTQ== X-Google-DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=1e100.net; s=20251104; t=1773673673; x=1774278473; h=mime-version:user-agent:content-transfer-encoding:references :in-reply-to:date:cc:to:from:subject:message-id:x-gm-gg :x-gm-message-state:from:to:cc:subject:date:message-id:reply-to; bh=weonBL/72GMajE/gjJI4emooMITS/Y0W/1HWhoCu1l0=; b=L1Woc/ImMUUKxhJPrbotodFLl1y27wAUlse8V+QKuz/DptGuPQRxD9vWJgwS5w4O2G ZgysN7Brq3TpUn4qBZDNK/XLG45bUG3oLu4h8Z0Yz9EuDgNraGegMNCoRrVFNPbFkX5s 3WPwzYYI+xU+8pFcRSV9Gzcl8Vv8v8DPCzgZJSEyiOGknL7VuWr0uX3RqT3q4ZE4sbN0 pIE7P8UlYyEsaXXW82xMZd+1xjLxHBsR2CIyDDfk+FuNONS8lAzed5OVIy1D7TzIzN/3 4e4Rr00aXGhuKlyw+ipFNWCDZyEEba5Zg+WatJD/LanFS3L7zX44wDGFtJSSGa4JBBu4 7shw== X-Gm-Message-State: AOJu0YxhPi7Gk2a6BncoaUd/cYrfbo5yhh05t/gt5Dj91pkRDi+D5qQn AYDLM/PbGyX7pl5gBtRE9vLHmXTmuwxTVAzylPVxTXQjQWf9YwtaSrslThq4KE+/L9BLOj9P2nL WoLgJ X-Gm-Gg: ATEYQzy17A1i+P9MV4nA8XR+4DQ/kqCa8D4w9wMwfV6hqfvd03qwGMs/kFoTpxtggOh jqDYAycpep+YSsJMn9KYiVgp+EftPv/sOzq2ex9Ga9zo6/rZOqgoZPDxaam+H3Ncfgv3OI6GQT6 woUKKasonNccf101jWI8qz7+x00A8aswZiJHqnXhtBIjwpChiTT2s5hkOBF+ZySgZzkAoTlAnMN V1ZahJ9qBe0T+6gblEcgtllxkfipu3UThfQjyw1pJzfO2QrME2nEwxOQ+OHH/rd6k5AwGqotdZp hmKr0KFmMKOzHl3eridGhs4Azgy9wQEqECymWXlmiLA5Ooi4QJ2v0Yt3koRCk3hiG+fYsrr5mFj zE+hxllY4BC6k9yPqtayuoP1ujuyPzSjkI3GG/OrDx/p1fk9YJSSjyTLwh86TV/wxzqGn0wkPGX mBA11BS4e+0oRqjkXL0DchRYMU+aU6WHbyqGOtUQSV1YcbCWqZSn4k X-Received: by 2002:a05:6000:40de:b0:439:c62a:6dc2 with SMTP id ffacd0b85a97d-43a04dc07bcmr25906023f8f.41.1773673673293; Mon, 16 Mar 2026 08:07:53 -0700 (PDT) Received: from laurenz.albe-K4N0CV00F97414D ([2001:871:70:3334:64a8:3da4:f89b:8181]) by smtp.gmail.com with ESMTPSA id ffacd0b85a97d-43b4938854csm1155215f8f.34.2026.03.16.08.07.52 (version=TLS1_3 cipher=TLS_AES_256_GCM_SHA384 bits=256/256); Mon, 16 Mar 2026 08:07:52 -0700 (PDT) Message-ID: <1b26be28f1e33162728da58162fcb80874fae4d8.camel@cybertec.at> Subject: Re: BUG #19432: recovery fails at invalid checkpoint record From: Laurenz Albe To: Felix Hamme Cc: pgsql-bugs@lists.postgresql.org Date: Mon, 16 Mar 2026 16:07:51 +0100 In-Reply-To: References: <19432-3c569e9472f42cee@postgresql.org> <58ceb75034bf694d52f81e898df35e14122fe5c8.camel@cybertec.at> <7b029b1636b24069bfc0d3a779e0a5521f60e57f.camel@cybertec.at> Content-Type: text/plain; charset="UTF-8" Content-Transfer-Encoding: quoted-printable User-Agent: Evolution 3.58.3 (3.58.3-1.fc43) MIME-Version: 1.0 List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk On Mon, 2026-03-16 at 14:56 +0100, Felix Hamme wrote: > 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. Don't do that. Make the restore_command idempotent. Trying to optimize for storage space often causes problems elsewhere. Yours, Laurenz Albe