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.94.2) (envelope-from ) id 1sknLa-002vmx-K4 for pgsql-general@arkaria.postgresql.org; Sun, 01 Sep 2024 16:22:39 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.94.2) (envelope-from ) id 1sknLZ-00Ghud-Nc for pgsql-general@arkaria.postgresql.org; Sun, 01 Sep 2024 16:22:37 +0000 Received: from magus.postgresql.org ([2a02:c0:301:0:ffff::29]) by malur.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.94.2) (envelope-from ) id 1sknLZ-00Ghtl-CJ for pgsql-general@lists.postgresql.org; Sun, 01 Sep 2024 16:22:37 +0000 Received: from fhigh5-smtp.messagingengine.com ([103.168.172.156]) by magus.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.94.2) (envelope-from ) id 1sknLV-0009sK-Mo for pgsql-general@lists.postgresql.org; Sun, 01 Sep 2024 16:22:36 +0000 Received: from phl-compute-01.internal (phl-compute-01.nyi.internal [10.202.2.41]) by mailfhigh.nyi.internal (Postfix) with ESMTP id 295AB1140076 for ; Sun, 1 Sep 2024 12:22:32 -0400 (EDT) Received: from phl-mailfrontend-02 ([10.202.2.163]) by phl-compute-01.internal (MEProxy); Sun, 01 Sep 2024 12:22:32 -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:subject:subject:to:to; s=fm3; t=1725207752; x=1725294152; bh=0niECWpEabmgad++4SucMzx6KOW5QnxhBL2zXuwDJ8w=; b= 8YnnSlUB7uEHC3aWqzn1i5NoGPrVxHDfyiLNon/cfQoW1psPCho6DCitbbyWk/7y qfKySabrC3R0iNsckSXRQ74hG/pOOm3/LyfH5X4+KynjtdPRt7t+K7k7kv40OKKp 0VYZbt6wPKC4FjjB7pkVmr5q8f1iMDWjCuzv8C95iFIcSnwbry2wKmvcQikJMLtl iqYxHniWapDPUNJ6jGI9rr2BaAckUVjRwUQJB++RJxRwfoap/vxdGOoDja3Ee/rX G9ovQoNMT6sIMOoylCJlqRxcTsVP7Xz2y/HF9EFUfnc6Ax4jaSAoroiMlsaZD/DW Taei34DwUnbnrcjGWqD9ng== 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:subject:subject:to:to:x-me-proxy:x-me-proxy :x-me-sender:x-me-sender:x-sasl-enc; s=fm1; t=1725207752; x= 1725294152; bh=0niECWpEabmgad++4SucMzx6KOW5QnxhBL2zXuwDJ8w=; b=k dcecYzVt5BU6wHPeCX4YPp27yvxKWvkdynidiE5KFzNfd4AJZaC3pJaRokiXffh5 /ouI2D8xK88XHawn9xbC+v+RLml4plFaQhx1gg0k7NEAohk8Bdwiud5b2dzLV8EA vSN9JRUriduMIpGCK9El0Yxja+rQ7+lnsPJDlfI0PTVwZq+cYc+ph3y6Zva3Rv/0 2Hhpsbqnk8h43YGOJ2rco/uZgG9fBcoV/M2MdVTGSRN/rYneH5NEfO7NFmExnG6s shCD3jm1Ynsd/uxlomSzqZg9wyvpWsvvGXlmRCWv5hPoLU1GClq8K2jGil9gtCSl 07QPk1WuPdkMPdYFpMgIw== X-ME-Sender: X-ME-Received: X-ME-Proxy-Cause: gggruggvucftvghtrhhoucdtuddrgeeftddrudegjedgtdejucetufdoteggodetrfdotf fvucfrrhhofhhilhgvmecuhfgrshhtofgrihhlpdggtfgfnhhsuhgsshgtrhhisggvpdfu rfetoffkrfgpnffqhgenuceurghilhhouhhtmecufedttdenucenucfjughrpefkffggfg fuvfhfhfgjtgfgsehtjeertddtvdejnecuhfhrohhmpeetughrihgrnhcumfhlrghvvghr uceorggurhhirghnrdhklhgrvhgvrhesrghklhgrvhgvrhdrtghomheqnecuggftrfgrth htvghrnhepkeefheduvdejiefgieefjedtudduffelvdefleehfedtieffuefgvdekleeg tddvnecuffhomhgrihhnpehpohhsthhgrhgvshhqlhdrohhrghenucevlhhushhtvghruf hiiigvpedtnecurfgrrhgrmhepmhgrihhlfhhrohhmpegrughrihgrnhdrkhhlrghvvghr segrkhhlrghvvghrrdgtohhmpdhnsggprhgtphhtthhopedupdhmohguvgepshhmthhpoh huthdprhgtphhtthhopehpghhsqhhlqdhgvghnvghrrghlsehlihhsthhsrdhpohhsthhg rhgvshhqlhdrohhrgh X-ME-Proxy: Feedback-ID: i76984098:Fastmail Received: by mail.messagingengine.com (Postfix) with ESMTPA for ; Sun, 1 Sep 2024 12:22:31 -0400 (EDT) Message-ID: <8af6bc33-f35b-4962-be07-9df3aecd9451@aklaver.com> Date: Sun, 1 Sep 2024 09:22:31 -0700 MIME-Version: 1.0 User-Agent: Mozilla Thunderbird Subject: Re: Upgrade Ubuntu 22 -> 24 may break PostgreSQL To: pgsql-general@lists.postgresql.org References: <20240831165445.7kqb4ezzghaysbc7@hjp.at> <20240831180213.ia27hp5ki2vq46nw@hjp.at> Content-Language: en-US From: Adrian Klaver In-Reply-To: <20240831180213.ia27hp5ki2vq46nw@hjp.at> Content-Type: text/plain; charset=UTF-8; format=flowed Content-Transfer-Encoding: 7bit List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk On 8/31/24 11:02, Peter J. Holzer wrote: > On 2024-08-31 10:35:01 -0700, Adrian Klaver wrote: >> On 8/31/24 09:54, Peter J. Holzer wrote: >>> 'Tis the season again. >>> >>> Ubuntu 24.04.1 has just been released, so many Ubuntu LTS users will now >>> be prompted to upgrade from 22.04 to 24.04. >> >> Which I ignore. > But I think our personal preferences are besides the point. Many people > will upgrade Ubuntu in the next weeks or months. So I wanted to give > them a heads-up that this might not be as smooth as expected. Major updates rarely are. That is why I tend to look before I leap. One way to make the leap easier is to change the Postgres repo from the Ubuntu to the PGDG repo on the current Ubuntu version being run then do the Ubuntu upgrade. The caveat being what the current version of Ubuntu/Postgres is you are running and whether that Postgres version is still supported in the main PGDG repo. Otherwise you are going to: https://apt-archive.postgresql.org/ -- Adrian Klaver adrian.klaver@aklaver.com