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 1rhuHe-00Dz2Z-OL for pgsql-admin@arkaria.postgresql.org; Wed, 06 Mar 2024 16:38:23 +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 1rhuHc-00BzMx-MZ for pgsql-admin@arkaria.postgresql.org; Wed, 06 Mar 2024 16:38:21 +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 1rhuHc-00BzMp-Bg for pgsql-admin@lists.postgresql.org; Wed, 06 Mar 2024 16:38:20 +0000 Received: from mail-qt1-x836.google.com ([2607:f8b0:4864:20::836]) by magus.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_128_GCM_SHA256 (Exim 4.94.2) (envelope-from ) id 1rhuHU-003712-FV for pgsql-admin@lists.postgresql.org; Wed, 06 Mar 2024 16:38:20 +0000 Received: by mail-qt1-x836.google.com with SMTP id d75a77b69052e-42ee984152cso22473601cf.1 for ; Wed, 06 Mar 2024 08:38:12 -0800 (PST) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=20230601; t=1709743091; x=1710347891; darn=lists.postgresql.org; h=content-language:thread-index:content-transfer-encoding :mime-version:message-id:date:subject:in-reply-to:references:to:from :from:to:cc:subject:date:message-id:reply-to; bh=bNQKTbauqt1Lytglubu/0rCGlpSCappFaPNrbv7ARgM=; b=jhPJSDjVBtA4pxMG79gvHTcm86Irud5NhRL/XBOv7FV9lL+m0pouY6fFfFyzSeV9dk g3/gpW8/8sdt9PhvvfUpWa4a8Oyle7uyD5KtW7wALon8dPWb1mL0UtXVxPQ3c6A9aojC c/B8+r9/ye4/GOgaoOWkRWP610lVnoWB/wIRTXj8izfLYDJ2Fzb5YkxH7obAG2SzM9xJ R7f3kMd0Sbh3afb4Fmr0lhqlexS+Pa8ExB5BEi5cs/9+sQyg0lh5UayA8Ejkeud/Gjw4 q4Glm42u450DQIhQPNiOlLMtvEp9vmIuGYyIpcnswhD6Az3NJTe6O+isYO+vkKoeW0yI 3Q1Q== X-Google-DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=1e100.net; s=20230601; t=1709743091; x=1710347891; h=content-language:thread-index:content-transfer-encoding :mime-version:message-id:date:subject:in-reply-to:references:to:from :x-gm-message-state:from:to:cc:subject:date:message-id:reply-to; bh=bNQKTbauqt1Lytglubu/0rCGlpSCappFaPNrbv7ARgM=; b=iTccmRW/n1qm4601N8JitbNSzH0b/t0jiFKZbq7EZClRRIQfV+XrOkQNfiSQD0FxHk OBKVTTX8R8z+ZQ2vWYw71+lkpflEXK/VSa8B7I48VpxoTLhpJVLfg//R5DT9aq/p0c0O rEt9g07bO/Iww3+seab/0Vju5Fr7HluNCGnJFe5jKEiG8CHx+yOqKkoFzz2IZ2ompt7h 5TYu4ws5M9rNIuy5jXQjt4jj1J2OQybClbo4JZhbKZAKv7t6VAcLKQdeVcQNcc67hwap mH8OH0ytrMbVZClYGTyMsLcdXfpYa6nxOQENoVmqozd54IerygvRi8viyoLGnWA+KsOP RVTw== X-Forwarded-Encrypted: i=1; AJvYcCVktxqHh1PijU0KEn/5ksXmkeXXIcWDZCHoW3hRg8+BSUD1nL9h5naNjLdn1w3yIicIB4LGLAPGILVa+9dfw+FHG/ebIeEAVo/1WFb0DCLzPg== X-Gm-Message-State: AOJu0YwY+6HdziDttDMI2w9pWIjTCICYRx5PVvkfAuQVhV8/cqhZPH8X 0KGgoT+59vL8ctZYgI0tce4T+UNP505MoANoOFHA1ZYBjCf5yqTzpxWodvd+ X-Google-Smtp-Source: AGHT+IHHbuBxG7yomT86Dbprn8BI2l8apms/wSJDOahHRGE04Qo4HXlnSV78Tj+QtqchxgDk+stViA== X-Received: by 2002:ac8:5fc5:0:b0:42e:e2b0:68e1 with SMTP id k5-20020ac85fc5000000b0042ee2b068e1mr6582757qta.66.1709743090512; Wed, 06 Mar 2024 08:38:10 -0800 (PST) Received: from LindaFLex (c-98-221-240-180.hsd1.nj.comcast.net. [98.221.240.180]) by smtp.gmail.com with ESMTPSA id jz14-20020a05622a81ce00b0042f00334f26sm1846628qtb.72.2024.03.06.08.38.09 (version=TLS1_2 cipher=ECDHE-ECDSA-AES128-GCM-SHA256 bits=128/128); Wed, 06 Mar 2024 08:38:09 -0800 (PST) From: To: "'Joe Conway'" , References: <18e801da6fe3$22ccaff0$68660fd0$@gmail.com> <9cc30cb6-7496-4508-bd6f-0640213ed12b@joeconway.com> In-Reply-To: <9cc30cb6-7496-4508-bd6f-0640213ed12b@joeconway.com> Subject: RE: Upgrade Rhel7.9 to Rhel9.3 Date: Wed, 6 Mar 2024 11:38:08 -0500 Message-ID: <18f701da6fe4$ac2fc790$048f56b0$@gmail.com> MIME-Version: 1.0 Content-Type: text/plain; charset="UTF-8" Content-Transfer-Encoding: quoted-printable X-Mailer: Microsoft Outlook 16.0 Thread-Index: AQIMX9EqKAWZXTuDkAOyuQBnmEJW7QJYMayDsLRHdFA= Content-Language: en-us List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk When we tried on a test server we were seeing issues with = libcrypto.so.10 and libssl.so.10=20 I know sometimes symlinks are needed but we can't seem to get these to = work which led to my question of if postgres12 was supported on rhel9.3=20 -----Original Message----- From: Joe Conway =20 Sent: Wednesday, March 6, 2024 11:31 AM To: garyorban@gmail.com; pgsql-admin@lists.postgresql.org Subject: Re: Upgrade Rhel7.9 to Rhel9.3 On 3/6/24 11:27, garyorban@gmail.com wrote: > We are upgrading our servers from rhel7.9 to rhel9.3. Currently we run = > postgres version 12 on Rhel 7.9. >=20 > After the upgrade will postgres 12 run on rhel9.3 ? Presumably you will install the RHEL 9 packages which will be built with = all of the needed dependencies. If so, you should be fine there. > Will I have issues with shared libraries etc=E2=80=A6 But beware of collation changes. You will almost certainly need to = rebuild some indexes afterwards. Lest you think you will not be affected, see: https://www.joeconway.com/presentations/glibc_issues-PGCon-2023.pdf -- Joe Conway PostgreSQL Contributors Team RDS Open Source Databases Amazon Web Services: https://aws.amazon.com