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 1q01JM-0000WZ-Td for pgsql-general@arkaria.postgresql.org; Fri, 19 May 2023 14:42:30 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.92) (envelope-from ) id 1q01JL-0004dX-TA for pgsql-general@arkaria.postgresql.org; Fri, 19 May 2023 14:42:27 +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 1q01JK-0004cu-Ce for pgsql-general@lists.postgresql.org; Fri, 19 May 2023 14:42:27 +0000 Received: from out4-smtp.messagingengine.com ([66.111.4.28]) by magus.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.94.2) (envelope-from ) id 1q01JF-000jsT-Bv for pgsql-general@lists.postgresql.org; Fri, 19 May 2023 14:42:25 +0000 Received: from compute6.internal (compute6.nyi.internal [10.202.2.47]) by mailout.nyi.internal (Postfix) with ESMTP id C10945C0062; Fri, 19 May 2023 10:42:18 -0400 (EDT) Received: from mailfrontend1 ([10.202.2.162]) by compute6.internal (MEProxy); Fri, 19 May 2023 10:42:18 -0400 DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=aklaver.com; h= cc:content-transfer-encoding:content-type:content-type:date:date :from:from:in-reply-to:in-reply-to:message-id:mime-version :references:reply-to:sender:subject:subject:to:to; s=fm3; t= 1684507338; x=1684593738; bh=N55MFWDRgbJK5tGBfFCVJpl700rTxyvB5sV oE3yzDXI=; b=dLorw34A2Nb1HLojSGdxDve9E56sBfeLncPpJXZD4x+eA0WiI/U mOEWVvxNXfKP2v8X09jZS23piLiRvs75sj9NYzi0Bgxs20hjmvPU7t5fQVGe62N6 xWJ3DfcyY0m0UnZnu89pE3ySozXAfe2XjAMh66GdtBSC233swmZk7u0rhfSj8nUC yJrhAR612R6mANYdjO93g0I2bFhapsa1VDQpqNXEYIK//sV9YaIhHekudQbbi+Sr abZDC441pJYqc0z3Nyro/cjSBGwQ3gyrZoJPo6zUmK6WzSIuSiNzK7yV7N6gmhal TfVg8SL7KQb+yzC80fik0JW1FqPjcfVwWgA== DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d= messagingengine.com; h=cc:content-transfer-encoding:content-type :content-type:date:date:feedback-id:feedback-id:from:from :in-reply-to:in-reply-to:message-id:mime-version:references :reply-to:sender:subject:subject:to:to:x-me-proxy:x-me-proxy :x-me-sender:x-me-sender:x-sasl-enc; s=fm1; t=1684507338; x= 1684593738; bh=N55MFWDRgbJK5tGBfFCVJpl700rTxyvB5sVoE3yzDXI=; b=Y nDxIYeVF/yQdfmP+VyW/SdZXYBFmWZCzbjDzzUddqF9u9hCt4GDcKCaoSOufICDX uP6rjAlY9O4KlbOVpN7sfhdEogg01UvQSa4uVsovojkL2WMy9DYb+iUb9sHj6lYZ 3baov0unftvziSmpkcpvdaBBaLdxd+eNyO6gFgIKhGFfZqP5UnqAo0gKOlHQ5GiS mYJRHNdLynmnNo3uXoW0xjqPW3mxDyVtZo5fGvLRXKEhbLj+ZGnB4jA4F47ge9oc bE23NjBm2l0Ovb+BlmH6aagAg8fX09usQ/m5UVTPDJfLTilDapQ3TUEwPsyrtu2W LM5kLY/+n8mKlMmOW9H5w== X-ME-Sender: X-ME-Received: X-ME-Proxy-Cause: gggruggvucftvghtrhhoucdtuddrgedvhedrfeeihedgkedtucetufdoteggodetrfdotf fvucfrrhhofhhilhgvmecuhfgrshhtofgrihhlpdfqfgfvpdfurfetoffkrfgpnffqhgen uceurghilhhouhhtmecufedttdenucesvcftvggtihhpihgvnhhtshculddquddttddmne cujfgurhepkfffgggfuffvfhfhjggtgfesthekredttdefjeenucfhrhhomheptegurhhi rghnucfmlhgrvhgvrhcuoegrughrihgrnhdrkhhlrghvvghrsegrkhhlrghvvghrrdgtoh hmqeenucggtffrrghtthgvrhhnpeelkeegjefhkeetheefudevteehiedvudehkeduleet fedvffeuhedtvdegtdeffeenucffohhmrghinhepphhoshhtghhrvghsqhhlrdhorhhgne cuvehluhhsthgvrhfuihiivgeptdenucfrrghrrghmpehmrghilhhfrhhomheprggurhhi rghnrdhklhgrvhgvrhesrghklhgrvhgvrhdrtghomh X-ME-Proxy: Feedback-ID: i76984098:Fastmail Received: by mail.messagingengine.com (Postfix) with ESMTPA; Fri, 19 May 2023 10:42:18 -0400 (EDT) Message-ID: <6bf7dd6f-0452-fa82-cd2d-a54e2cce6498@aklaver.com> Date: Fri, 19 May 2023 07:42:17 -0700 MIME-Version: 1.0 User-Agent: Mozilla/5.0 (X11; Linux x86_64; rv:102.0) Gecko/20100101 Thunderbird/102.10.1 Subject: Re: a simple-minded question about updating To: Martin Mueller , "pgsql-general@lists.postgresql.org" References: Content-Language: en-US From: Adrian Klaver In-Reply-To: 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 5/19/23 07:25, Martin Mueller wrote: > I currently work with Postgres 13. I forgot to mention that. From which > I gather that around version 18 it would be time to upgrade. But in the > interim I’d be OK. > > Right? Strictly speaking yes, though the longer you wait the greater the number of changes you will have to deal with. It is a good idea to read the Release Notes: https://www.postgresql.org/docs/current/release.html for each new release to see how far away the new code is getting from your existing version. Breaking changes are restricted(with some exceptions) to the X.0 release where X is new major version. So you can save some time by just looking at the notes for the .0 releases. > -- > Adrian Klaver > adrian.klaver@aklaver.com > -- Adrian Klaver adrian.klaver@aklaver.com