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 1tJzJo-006CNr-6V for pgsql-admin@arkaria.postgresql.org; Sat, 07 Dec 2024 18:14:16 +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 1tJzJl-00GNON-Ep for pgsql-admin@arkaria.postgresql.org; Sat, 07 Dec 2024 18:14:14 +0000 Received: from makus.postgresql.org ([2001:4800:3e1:1::229]) by malur.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.94.2) (envelope-from ) id 1tJzJl-00GNOA-3B for pgsql-admin@lists.postgresql.org; Sat, 07 Dec 2024 18:14:14 +0000 Received: from ns7.gunduz.org ([165.232.104.158]) by makus.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.94.2) (envelope-from ) id 1tJzJi-001XUm-N6 for pgsql-admin@lists.postgresql.org; Sat, 07 Dec 2024 18:14:12 +0000 Received: from [127.0.0.1] (host-94-88-107-122.business.telecomitalia.it [94.88.107.122]) (using TLSv1.3 with cipher TLS_AES_128_GCM_SHA256 (128/128 bits) key-exchange X25519 server-signature ECDSA (P-256) server-digest SHA256) (No client certificate requested) by ns7.gunduz.org (Postfix) with ESMTPSA id E5A8030001D8; Sat, 7 Dec 2024 18:14:07 +0000 (UTC) Date: Sat, 07 Dec 2024 19:14:06 +0100 From: =?ISO-8859-1?Q?Devrim_G=FCnd=FCz?= To: pgsql-admin@lists.postgresql.org, vrms Subject: Re: Postgres compatibility with RHEL User-Agent: K-9 Mail for Android In-Reply-To: <7882d3da-3445-4c80-a766-1246e55415da@netcologne.de> References: <7882d3da-3445-4c80-a766-1246e55415da@netcologne.de> Message-ID: <35A8A86D-132E-4FF8-8C63-6CC9ECD5BFAE@gunduz.org> MIME-Version: 1.0 Content-Type: multipart/alternative; boundary=----KSZHWU8HMUD31GJY33MOVOYBRE1M5I Content-Transfer-Encoding: 7bit List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk ------KSZHWU8HMUD31GJY33MOVOYBRE1M5I Content-Type: text/plain; charset=utf-8 Content-Transfer-Encoding: quoted-printable Sorry, but pg_dumpall is almost never the best way - or even good way=2E=20 On 7 December 2024 17:43:11 CET, vrms wrote: >I believe the best way would be to > >=C2=A0 1=2E setup a new rhel9 server with pg16 >=C2=A0 2=2E get a dump (pg_dumpall) from the old machine onto the new mac= hine >=C2=A0 3=2E restore that dump >=C2=A0 4=2E copy pg_hba=2Econf and postgresql=2Econf over to the new mach= ine >=C2=A0 4=2E1=2E make sure to keep the new postgresql=2Econf and adjust cu= stom settings you may have on the old machine with making sure those settin= gs have not changed > >If you want to do this close to zero downtime, you could set up logical r= eplication to the new pg16 machine and once that is finished switch over an= d promote that to be the new main=2E > > > >On 04=2E12=2E24 14:03, Siddhartha Jain wrote: >> Hi, >>=20 >> Please let me know if Postgresql 16 is compatible with RHEL 7=2E9 versi= on and RHEL 9=2E1 version=2E >> I need to upgrade postgres from 11=2E22 to 16=2E6 and need information = for that as the OS version is going to upgrade from 7=2E9 to 9=2E1=2E >> Also, let me know the strategies if any to upgrade both RHEL and DB=2E >>=20 >> Thanks, >> Siddhartha ------KSZHWU8HMUD31GJY33MOVOYBRE1M5I Content-Type: text/html; charset=utf-8 Content-Transfer-Encoding: quoted-printable

Sorry, but pg_dumpall is almost never the best w= ay - or even good way=2E

On 7 December 2024 17:43:11 CET, vrms <vrms@netcologne=2Ede>= ; wrote:

I believe the best way would be to

1=2E setup a new rhel9 server with pg16
2=2E get a dump (pg_dumpall) from the old machine onto t= he new machine
3=2E restore that dump
4=2E copy pg_hba=2Econf and postgresql=2Econf over to the new m= achine
4=2E1=2E make sure to keep the new postgresql=2Econf and adjust= custom settings you may have on the old machine with making sure those settings have not changed

If you want to do this close to zero downtime, you could set up logical replication to the new pg16 machine and once that is finished switch over and promote that to be the new main=2E

On 04=2E12=2E24 14:03, Siddhartha Jain wrote:

Hi,

Please let me know if Postgresql 16 is compatible with RHEL 7=2E9 version and RHEL 9=2E1 version=2E
I need to upgrade postgres from 11=2E22 to 16=2E= 6 and need information for that as the OS version is going to upgrade from 7=2E9 to 9=2E1=2E

Also, let me know the strategies if any to upgrade both RHEL and DB=2E

Thanks,

Siddhartha

------KSZHWU8HMUD31GJY33MOVOYBRE1M5I--