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 1pG18J-0000Z4-5l for pgsql-general@arkaria.postgresql.org; Thu, 12 Jan 2023 17:12:55 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.92) (envelope-from ) id 1pG18I-0004oF-0Y for pgsql-general@arkaria.postgresql.org; Thu, 12 Jan 2023 17:12:54 +0000 Received: from magus.postgresql.org ([2a02:c0:301:0:ffff::29]) by malur.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.92) (envelope-from ) id 1pG18H-0004o5-Mt for pgsql-general@lists.postgresql.org; Thu, 12 Jan 2023 17:12:53 +0000 Received: from mail-yw1-x1136.google.com ([2607:f8b0:4864:20::1136]) by magus.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_128_GCM_SHA256:128) (Exim 4.92) (envelope-from ) id 1pG18F-0006UG-Et for pgsql-general@lists.postgresql.org; Thu, 12 Jan 2023 17:12:53 +0000 Received: by mail-yw1-x1136.google.com with SMTP id 00721157ae682-4db05a4db9bso26283327b3.10 for ; Thu, 12 Jan 2023 09:12:51 -0800 (PST) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=20210112; h=content-transfer-encoding:in-reply-to:from:references:to :content-language:subject:user-agent:mime-version:date:message-id :from:to:cc:subject:date:message-id:reply-to; bh=9oG2l6rg6z167rRWKrkHxMHFfyHy+OjfXk+5jxfrE3w=; b=WZbo+RYnIfY6HJuyD901565oluxq5HBFCXwCj1nktOJAaC4w6H65X3M/YWT+UpX03R vTgkWUdgKuK/PY8cIAgTZt0TPB/QxkQl/WCPytu/Ex0XbYxRjY0RD0KaE6GhrW2znF3g wMsccQoL5tooC/V6n5u59/wdFsTgVLzKYYpvLSAW+4lUxGmmQI1XjNWnchFtXVczOTJb Px5mJK5PyJiezEhaSZKYgpuxNb1iMxXoXSp+Nb5z7mAeFadJYY8YzuRzPLQk0PtZojbg xezZyCUpXli4t1kEsI1Az9FZXxpm67dFF1k2xZ5d3w/HN2nkk43C7R2GWycmomLH6GXj ulrA== X-Google-DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=1e100.net; s=20210112; h=content-transfer-encoding:in-reply-to:from:references:to :content-language:subject:user-agent:mime-version:date:message-id :x-gm-message-state:from:to:cc:subject:date:message-id:reply-to; bh=9oG2l6rg6z167rRWKrkHxMHFfyHy+OjfXk+5jxfrE3w=; b=3S7uVv2lDtbsk4MEVQfQcpv3anEgQ+tIEA/h2p0Dgtwfo9yDjs3m0CSw4ABioQkKE/ zCtwnS0GkGsMtcevzQSy9ci1WlHaz4M33xVdW5O8NAt3YFzQ5CHrBAEylkmsE2Dl9dWS oQlySItwaw+PfggGVfRYLu/wNPy2YZ+k+TxGB79rADS7Cem60Gge2UCyXggsESNt5c/4 9Lp0642ssTK/WuXeF3j+65X5Wn58BAz/Xelloivd1EZFlEKWVp57B0H19KrOmEB5RYuv PoJlMnBSwaMiHhX8NYQE3k8nimV7XzMjR5CIINvGwXfN6GkjD9E3MEszrLkl4q3Ur0lG Bh0A== X-Gm-Message-State: AFqh2kqYnAI+xPzl37Y7cA25KeadgZaEXeCPGh6rTrZFMC5GqrsEGTv7 +u8zon7NmppNnJPB7m72ukwrxQFzECt8Wg== X-Google-Smtp-Source: AMrXdXsXpWaPbBaa2/u96QR0PyEMAspJkj5JSSXJ0hdnCqadV7F8AJ94Pu1cub1/kXUjR1IsET0nPg== X-Received: by 2002:a05:7500:2194:b0:f1:8ec7:3515 with SMTP id g20-20020a057500219400b000f18ec73515mr286639gac.32.1673543569650; Thu, 12 Jan 2023 09:12:49 -0800 (PST) Received: from [192.168.1.66] (108-250-206-84.lightspeed.nworla.sbcglobal.net. [108.250.206.84]) by smtp.googlemail.com with ESMTPSA id w19-20020a05620a445300b006fc3fa1f589sm11095487qkp.114.2023.01.12.09.12.49 for (version=TLS1_3 cipher=TLS_AES_128_GCM_SHA256 bits=128/128); Thu, 12 Jan 2023 09:12:49 -0800 (PST) Message-ID: <8129a929-8dfe-89e3-4104-fbf7e9d4eaaa@gmail.com> Date: Thu, 12 Jan 2023 11:12:48 -0600 MIME-Version: 1.0 User-Agent: Mozilla/5.0 (X11; Linux x86_64; rv:102.0) Gecko/20100101 Thunderbird/102.2.2 Subject: Re: AW: [Extern] Re: postgres restore & needed history files Content-Language: en-US To: pgsql-general@lists.postgresql.org References: <0ce7906d55174fa6902c011c0aa0e884@zuerich.ch> <6a648ddf9d8747e7bc18fa06ac7f48a2@zuerich.ch> From: Ron In-Reply-To: <6a648ddf9d8747e7bc18fa06ac7f48a2@zuerich.ch> Content-Type: text/plain; charset=UTF-8; format=flowed Content-Transfer-Encoding: 8bit List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk On 1/12/23 10:50, Zwettler Markus (OIZ) wrote: [snip] > 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? Yet another reason why you should not roll your own PITR backup solution.  Use something like pgBackRest (what I use) or BarMan. -- Born in Arizona, moved to Babylonia.