Received: from malur.postgresql.org ([217.196.149.56]) by arkaria.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.92) (envelope-from ) id 1pGHFG-00046i-Dz for pgsql-general@arkaria.postgresql.org; Fri, 13 Jan 2023 10:25:10 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.92) (envelope-from ) id 1pGHFF-0007GK-0A for pgsql-general@arkaria.postgresql.org; Fri, 13 Jan 2023 10:25:09 +0000 Received: from makus.postgresql.org ([2001:4800:3e1:1::229]) by malur.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.92) (envelope-from ) id 1pGHFE-00078V-IA for pgsql-general@lists.postgresql.org; Fri, 13 Jan 2023 10:25:08 +0000 Received: from mail-ej1-x635.google.com ([2a00:1450:4864:20::635]) by makus.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_128_GCM_SHA256:128) (Exim 4.92) (envelope-from ) id 1pGHFB-0003fP-Tq for pgsql-general@lists.postgresql.org; Fri, 13 Jan 2023 10:25:07 +0000 Received: by mail-ej1-x635.google.com with SMTP id v6so8232114ejg.6 for ; Fri, 13 Jan 2023 02:25:05 -0800 (PST) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=cybertec-at.20210112.gappssmtp.com; s=20210112; h=mime-version:user-agent:content-transfer-encoding:references :in-reply-to:date:to:from:subject:message-id:from:to:cc:subject:date :message-id:reply-to; bh=qlYdoow0txPnUwI8ELRCE0MNOr7NqmLlz1LaMXa1kmE=; b=aEPGq9zr9cWZiJB9RsvWqLyoXNDXQ6E5jav77bvfiqeeBarWZ1BniKuFn9wwpv2ip0 bbF33fobxU8GjYlmaAUn0SpJ1DEEftiscWb/yJR2vo4bZ+Dyi81a9bxvTdyKrdSf5d1A OANvK8JVQUFfPJjNAl14IXa7ofg/+AteB9L//1LARz+6PwoFoYFrF57+8GLtopxvkhbL ylxuALWyZ9pPXoVOgWREz+/sfxQ+JHiaLU/rwpnreFOCVo6vSbjkGAiwmuQmiqxQNd7w pHK6GaJazcplDo6/sJDrXT+N2hswt98+h3SvHOJkdTZtV5neT8B+cDWoNe+CabI+EgXY ubXA== X-Google-DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=1e100.net; s=20210112; h=mime-version:user-agent:content-transfer-encoding:references :in-reply-to:date:to:from:subject:message-id:x-gm-message-state:from :to:cc:subject:date:message-id:reply-to; bh=qlYdoow0txPnUwI8ELRCE0MNOr7NqmLlz1LaMXa1kmE=; b=Q2mU+2lBhMQVlhsaAnjeEBOAjXJLACrMxOsy516Nnaa24uAQ8ZpUrzTTSdxHi2l9gC JBm9k/oYoomy2H13yP3w97QZAAK8igp5Vvhx99YZ5YbnOPXwtXJQo7VDDMxL1bt5nfIJ UUler2HZJ3dFwCwPRTd+QCI+ViGxaHD5gAfNPnDsRgCpp+0UZzmmjhz6bKXI87uDefjW GGuW+Z23DUg3laykhGh8xsyBQa/D8NuBhNHvT9bAkfEbQ0lIlgMyhB9VmlKc8S7/FyYb QpxinUfOlxeuIg/FxVkiO+cvnXOUTz3+FyOhxRetQcuBIyKLpI6sl1RBhuLbADAegVio M+4w== X-Gm-Message-State: AFqh2krVoB5Ngnh+HEN18E/105nVl5HvACyu2eN+oT4dv/ho23Cfjio+ PGjMsZk2kPqSMDVs70gJ2mY3xglZop+thhqm X-Google-Smtp-Source: AMrXdXv5zLGlYhS8Pgz6/lZw4WGM6VvQTnUhJzZyN4LBGhMPb+2FVnFatzuAbNlvmSzDzQaG9bsffQ== X-Received: by 2002:a17:907:a407:b0:84c:7974:8a73 with SMTP id sg7-20020a170907a40700b0084c79748a73mr64004629ejc.57.1673605503696; Fri, 13 Jan 2023 02:25:03 -0800 (PST) Received: from localhost.localdomain (178-190-174-62.adsl.highway.telekom.at. [178.190.174.62]) by smtp.gmail.com with ESMTPSA id x3-20020a170906b08300b007c0688a68cbsm8507303ejy.176.2023.01.13.02.25.03 (version=TLS1_3 cipher=TLS_AES_256_GCM_SHA384 bits=256/256); Fri, 13 Jan 2023 02:25:03 -0800 (PST) Message-ID: <6b0bc60cae8d0268f70b33d491d8399a0e4e0db2.camel@cybertec.at> Subject: Re: AW: [Extern] Re: postgres restore & needed history files From: Laurenz Albe To: "Zwettler Markus (OIZ)" , "pgsql-general@lists.postgresql.org" Date: Fri, 13 Jan 2023 11:25:02 +0100 In-Reply-To: <6a648ddf9d8747e7bc18fa06ac7f48a2@zuerich.ch> References: <0ce7906d55174fa6902c011c0aa0e884@zuerich.ch> <6a648ddf9d8747e7bc18fa06ac7f48a2@zuerich.ch> Content-Type: text/plain; charset="UTF-8" Content-Transfer-Encoding: quoted-printable User-Agent: Evolution 3.46.3 (3.46.3-1.fc37) MIME-Version: 1.0 List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk On Thu, 2023-01-12 at 16:50 +0000, Zwettler Markus (OIZ) wrote: > What would you do in case of a disaster when all history files in pg_wal = are gone > and also deleted in the backup due to the backup retention? Easy. Take a new base backup immediately and don't try to restore a backup that was taken on an earlier timeline. Yours, Laurenz Albe