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 1nY1qq-0005y1-8o for pgsql-admin@arkaria.postgresql.org; Sat, 26 Mar 2022 08:32:48 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.92) (envelope-from ) id 1nY1qp-00079X-0R for pgsql-admin@arkaria.postgresql.org; Sat, 26 Mar 2022 08:32:47 +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 1nY1qo-00079I-JI for pgsql-admin@lists.postgresql.org; Sat, 26 Mar 2022 08:32:46 +0000 Received: from mail-wr1-x433.google.com ([2a00:1450:4864:20::433]) by makus.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_128_GCM_SHA256:128) (Exim 4.92) (envelope-from ) id 1nY1qm-00025a-9J for pgsql-admin@lists.postgresql.org; Sat, 26 Mar 2022 08:32:45 +0000 Received: by mail-wr1-x433.google.com with SMTP id j18so13584591wrd.6 for ; Sat, 26 Mar 2022 01:32:44 -0700 (PDT) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=20210112; h=message-id:sender:date:from:to:cc:subject:references:mime-version :content-disposition:in-reply-to:user-agent; bh=53FhSEe5qRruuui140ou0ryhZD8nV6VNVihA5+7ETSY=; b=LjWXqImRPQkJrmBfJUpsB4nYug8e7Y+fuepO0rshnHGVWO0K3csfzo/in+GEyYuBYo RZw++YC9OeHvzblDdLlNE8Q24fRoEbzlhCm4jzup72SItDOhGrvCE41dPkIC1HiWvIaw t9SOWiZ3vtpsqhuhrtCtN6/d5We4K+cUxYRykVj6OFEwoKQvEdV1SXXyzHwGiQh558y+ 7RHax+ApLoxgA7DrGuAi/0aYN3J/RuMoQQJAhIBSroW5p304mMwNJjvbSL5FICYsT7fF /t0PUCYzqoNgptRTssl01YBJQRzAKZGssjKmzKK+x4DWbMNZOSzCVtZhvYrB7M4uyrbi LpCA== X-Google-DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=1e100.net; s=20210112; h=x-gm-message-state:message-id:sender:date:from:to:cc:subject :references:mime-version:content-disposition:in-reply-to:user-agent; bh=53FhSEe5qRruuui140ou0ryhZD8nV6VNVihA5+7ETSY=; b=h39UIBrI6DNaZRshSQlDKQmaF/7D737Im1dOjidEj1tS/uc3oOXnQy8KPgR2ZNdLzJ s2ur4or0WViardoNti6H+lO9t0mAUHaUvRCgA+8hKeODtEo/4UJzt5PXAvjBrezHmha9 r3lHoH7U5tQjnhN0Jzhi03DxrNGNNcKaTQNYHS3kuLM1L2Pp78xIyf72Wm+bS/oo9ml3 VBBF3Q/ru/ZG6vZSAb54ItoMItEGUp//432doHTnvwAqsXc2dk1FzDoSW/W/B44t80Hv sLAjb1ShP21j0D4JJg3aMSFPpxOaXT2x3H4GysOOwpqoUxztYqU7ShX+gsDMRq+IArZR j76A== X-Gm-Message-State: AOAM532RGEGIgpxIFapoOK9e46QCErn2p87mBbuYTmNYNxktO0N4h6C5 ihLXv/me8r6r0QI9SzN7v3g= X-Google-Smtp-Source: ABdhPJzNpUrGlFPXeYpoHBkj4WO85tNRQlwdqCZQh9Gr5QNKdpq8htrmbpmIt2xdzzq++ENevQchHA== X-Received: by 2002:a5d:64a3:0:b0:203:d7e5:67ff with SMTP id m3-20020a5d64a3000000b00203d7e567ffmr12681457wrp.617.1648283562674; Sat, 26 Mar 2022 01:32:42 -0700 (PDT) Received: from lightning.caipicrew.dd-dns.de ([2001:a61:3b75:9d01:b8f:88fd:f8ad:3b58]) by smtp.gmail.com with ESMTPSA id m20-20020a05600c4f5400b0038b5162260csm9764859wmq.23.2022.03.26.01.32.41 (version=TLS1_3 cipher=TLS_AES_256_GCM_SHA384 bits=256/256); Sat, 26 Mar 2022 01:32:42 -0700 (PDT) Message-ID: <623ecfaa.1c69fb81.2bb05.620b@mx.google.com> X-Google-Original-Message-ID: <20220326083240.GF10551@caipicrew.dd-dns.de;lightning.caipicrew.dd-dns.de> Sender: Michael Banck Received: from mbanck by lightning.caipicrew.dd-dns.de with local (Exim 4.92) (envelope-from ) id 1nY1qj-00049i-5u; Sat, 26 Mar 2022 09:32:41 +0100 Date: Sat, 26 Mar 2022 09:32:41 +0100 From: Michael Banck To: Loles Cc: Laurenz Albe , Ron , pgsql-admin@lists.postgresql.org Subject: Re: Avoid Wraparound Failures References: <965a52fe849ec6e5759d349b4063b5077353f24b.camel@cybertec.at> MIME-Version: 1.0 Content-Type: text/plain; charset=us-ascii Content-Disposition: inline In-Reply-To: User-Agent: Mutt/1.10.1 (2018-07-13) List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk Hi, On Sat, Mar 26, 2022 at 07:47:17AM +0100, Loles wrote: > PostgreSQL version 9.5.5 (I know. I do not like it. In Spanish there > is a saying that says "the things of the Palace go slowly") Note that 9.5 does not have the freeze map yet (that came in 9.6), so anything freeze-related is way worse there. So maybe just get some sign-off from the higher-ups that they are aware of the risks of running an unpatched, end-of-lifed database to cover your own bases. Michael