From: "Deepak Pahuja ." <deepakpahuja@hotmail.com>
To: =?iso-8859-1?Q?Devrim_G=FCnd=FCz?= <devrim@gunduz.org>,
	"pgsql-admin@lists.postgresql.org" <pgsql-admin@lists.postgresql.org>, vrms
	<vrms@netcologne.de>
Subject: Re: Postgres compatibility with RHEL
Thread-Topic: Postgres compatibility with RHEL
Thread-Index: AQHbRk0A6Asz7V0SokuH4nUH169jmbLbAZqAgAAZZgCAAOF4Rg==
Date: Sun, 8 Dec 2024 07:41:59 +0000
Message-ID: 
 <BY1P223MB1208C644D69B24BDFE0C306DD6332@BY1P223MB1208.NAMP223.PROD.OUTLOOK.COM>
References: 
 <CALOSYAfZvYFYpqNgiLG=GbZK5UNakcvqE6Pm7x9mRGqsEnQ6hQ@mail.gmail.com>
 <7882d3da-3445-4c80-a766-1246e55415da@netcologne.de>
 <35A8A86D-132E-4FF8-8C63-6CC9ECD5BFAE@gunduz.org>
In-Reply-To: <35A8A86D-132E-4FF8-8C63-6CC9ECD5BFAE@gunduz.org>
Accept-Language: en-US
Content-Language: en-US
x-ms-exchange-messagesentrepresentingtype: 1
x-ms-publictraffictype: Email
x-ms-traffictypediagnostic: BY1P223MB1208:EE_|DS7P223MB0430:EE_
x-ms-office365-filtering-correlation-id: 2adadca9-b908-42e7-5ef3-08dd175bcca4
x-microsoft-antispam: 
 BCL:0;ARA:14566002|12050799009|7092599003|8060799006|19110799003|14030799003|9400799027|15080799006|461199028|8062599003|102099032|1602099012|10035399004|4302099013|3412199025|440099028;
x-microsoft-antispam-message-info: 
 =?iso-8859-1?Q?cNEo0waFqsMncbh8a99/l1AJYZURrGbRI/CfOzMd0SCoCRVpKuBXW5Dhr2?=
 =?iso-8859-1?Q?H9m7RsUnfuDMIGkao7ejOkex8NVROxmVy0yPdLveXhxbiNO78I0zBOQ8tw?=
 =?iso-8859-1?Q?84hUjIClsPzyktGvM7l+xMEsN2nweWHJbFELf+7M+cXhPP6bASds3DC/c5?=
 =?iso-8859-1?Q?Mi6zQS+ocNgBSd9ulv64Z+0bEiuTV62jzFUv7VckzD2IeQ1KzGxSDl8u5x?=
 =?iso-8859-1?Q?UZeKIpTPOAcNLN0zHCUZrg1jelGCFpsSPq1X9Eb4yieEhTiuMNAcbIl59Y?=
 =?iso-8859-1?Q?zs98yOIFM7sXtJgXbL8HtFFuRQYKeYDcL7iDl3p3LK9f+rAIgsK+E9KmN+?=
 =?iso-8859-1?Q?U54IlQ4LDKF5FHpVin3ps7ePQh3Sdc3AjaZOWyM4roap3VisXeVIsoaX1U?=
 =?iso-8859-1?Q?BjCtePWH1dqtzWhpI9BMeRzWQFogc73nUZ9sGBgCR+kADfws6uT4mmGKEq?=
 =?iso-8859-1?Q?BGl6X8zDOd5gJxMv7qm3ud/nGUQuHnEhL3jqBa2kivzwioycOxwZ96kGCb?=
 =?iso-8859-1?Q?2XgBTVRa75O6vKB0QzzJYDL9zoY/IYCp+G+vaBVg3/HcXY9FAHmDL3Bnu0?=
 =?iso-8859-1?Q?fyGKpMIgLkPyUnGXvRTCXJzh5fW/poZHnpXtd7V856LFRBY34gsviyeSKJ?=
 =?iso-8859-1?Q?JAv9NKg1OMBh1xNnogTTR1hze94+ZIPHCLoZWzrQNiqqtvcooL5MQnBtCi?=
 =?iso-8859-1?Q?wD7TR83XoWhzVXuBahACL1ZH9lGNmLwiyp6OoEObwQTDnstrHPeDAkTI+d?=
 =?iso-8859-1?Q?U+l//3XMjLc3/SnuQGUZ5V/6QYlV4swzQz4ByIFvY7PxGjfU2QXqGBeh+5?=
 =?iso-8859-1?Q?mEPs5CR0iivE2ckxWd/E/77g1pkS1qb7sK7/XRuTqpwmNqT6zOFQ1jGoAI?=
 =?iso-8859-1?Q?O5PI2k/ZA+qjm+O11+BaB513JunFnepIfmOLApi3WlgoP66dKEnMRE0lF6?=
 =?iso-8859-1?Q?YuN5oEcW39bojO3s7yTVb5C4zTSZ9gzvU92sfT7i6uSNoe3Scx9mIlA+jt?=
 =?iso-8859-1?Q?M8bVcI5tDgA91yJgBrUeKx5wvpPjycJ/SlvQwgBcY3nhfUPbbTpX5WoQEu?=
 =?iso-8859-1?Q?uwsgKZWTPevnfK/djyRkXR9LkcJv4zQIP3Rp/vJTcyddOe7uCVGPZslcsP?=
 =?iso-8859-1?Q?DhnHwUL+A9ItDGCeEgup/L1FPLAajkTXfzIn3AGXHu3f82k24tONoZQsWs?=
 =?iso-8859-1?Q?Y+IuKwqSn+J+VjMWxhlBDyD7WkBnriyUf2E+aFLQIUSTyOZipwfFyM9qZp?=
 =?iso-8859-1?Q?FwuGeARHrO+L90k16IC+vASHyw5DJOqPmhi7yQRMQ=3D?=
x-ms-exchange-antispam-messagedata-chunkcount: 1
x-ms-exchange-antispam-messagedata-0: 
 =?iso-8859-1?Q?Fp/xjn+hHJvWW4Jq83/0FxWPt3QQkxyAFvx02hWrxqE4SiN87zZPeJWtSE?=
 =?iso-8859-1?Q?/hFKBKJQBofblxkK6Hp/rASvj1XwY67GovUjeJaZZAKzueOkw/NHmP38ws?=
 =?iso-8859-1?Q?jeJf4wvEMJx1HSEcVMcHww4TLIdhGobK1otR7laVlDB0PUdYQmZ4/u5lXg?=
 =?iso-8859-1?Q?JmexiKxsTFXdp81a0swhVQ41D0Nx9ATvQlStB4uvXbhEYNOQkq64LrGvZX?=
 =?iso-8859-1?Q?VpOgRkPSfg91TbQvJyut4zSayCAa4se8g1ePPe9l4PUpyWt5kF70X85HdC?=
 =?iso-8859-1?Q?zN0uNSHAHWOyR+2Xnk3rvtEfc4n+vdstkdOfonvcYmkSazN8T3VJQMgpF0?=
 =?iso-8859-1?Q?oASngcYGOBKGWsW8zBFw5vYG4YLI842qkAqIjdq5yQwdmzPY0IDliWtVEi?=
 =?iso-8859-1?Q?b7+uAFsHhu93rxVIpfiBGVfGBh0CvzmyqJ2X0LagrpnfLyJnQe5Fz/68tP?=
 =?iso-8859-1?Q?jypVJ6rd7TDdBEpI7zqKJ4eAeyFmClFisSL7kwQC0b+HdReEv8A0mCCotd?=
 =?iso-8859-1?Q?rUhIXJLqvBxKa95vZNu6hkjPu9VmcXpJkhD9kQLdhJX271umjMwzoKy+yA?=
 =?iso-8859-1?Q?YNzvjMedGpCfaYutGGckyt1kX4n1bw21p4i7xfpeETqiShA8Thr7G4Om2Q?=
 =?iso-8859-1?Q?uP14vx6QpxrC2LzYPwwkd1Bmt+KhwEcnsgacBGpFZs5YFoagbP1CDn240P?=
 =?iso-8859-1?Q?v7hV8uLgyHVX+7yXJm+lisKHNTQVaQv5H4v9VYpmjbVtP09ms11plUbg+s?=
 =?iso-8859-1?Q?zvfPCOaC+7SmLCfftPR4bjJM3ZqjAleP9aL4oNdtwtriBRMnQVnsrF4WVl?=
 =?iso-8859-1?Q?VL53LP+kcEy3nER+xyatdH5fBOozjclnYSREvgKaEICvctuC7FPm8IECOB?=
 =?iso-8859-1?Q?OpDwyZQQiWHb8jdJTtHaCHprFoZ9BvK6kWgWDK+v40ZJYDft3/WKVahAAL?=
 =?iso-8859-1?Q?HlFvpdnXf2J+iu2fmPOfNeEBZ1UvEHuuBnPCRQqhtPvk/pq87n/sANB8g6?=
 =?iso-8859-1?Q?pWq10QT6KQs2DV0EAImp+OABBB2RijA0iT/CCanABSdlhAWHQeerohinK1?=
 =?iso-8859-1?Q?H3EhANaidyOSpglfotqmU69yBZGBSE5RaBWHXfw7kAvHWYfQbTrdXtPsOO?=
 =?iso-8859-1?Q?KxdC/YlPcZSY4rz5EYVgOrcErEyUzvEdkoZLMSiA4/Nte4jE4IHjXLl1Jb?=
 =?iso-8859-1?Q?rCGsaORlKJOTghtzUVyPa/Z0VljNLDnYqxG1qdxYebjsQ1f2NiCYtMRmfG?=
 =?iso-8859-1?Q?n/x4yjedxHrsGUGylZ4wnqwPY6j9NKD9K/+2m0E3xwYkQ7zhGuEmb+GhVD?=
 =?iso-8859-1?Q?Vhbb?=
Content-Type: multipart/alternative;
	boundary="_000_BY1P223MB1208C644D69B24BDFE0C306DD6332BY1P223MB1208NAMP_"
MIME-Version: 1.0
X-OriginatorOrg: sct-15-20-4755-11-msonline-outlook-1ff67.templateTenant
X-MS-Exchange-CrossTenant-AuthAs: Internal
X-MS-Exchange-CrossTenant-AuthSource: BY1P223MB1208.NAMP223.PROD.OUTLOOK.COM
X-MS-Exchange-CrossTenant-RMS-PersistedConsumerOrg: 
 00000000-0000-0000-0000-000000000000
X-MS-Exchange-CrossTenant-Network-Message-Id: 
 2adadca9-b908-42e7-5ef3-08dd175bcca4
X-MS-Exchange-CrossTenant-originalarrivaltime: 08 Dec 2024 07:41:59.8815
 (UTC)
X-MS-Exchange-CrossTenant-fromentityheader: Hosted
X-MS-Exchange-CrossTenant-id: 84df9e7f-e9f6-40af-b435-aaaaaaaaaaaa
X-MS-Exchange-CrossTenant-rms-persistedconsumerorg: 
 00000000-0000-0000-0000-000000000000
X-MS-Exchange-Transport-CrossTenantHeadersStamped: DS7P223MB0430
List-Id: <pgsql-admin.lists.postgresql.org>
List-Help: <https://lists.postgresql.org/manage/>
List-Subscribe: <https://lists.postgresql.org/manage/>
List-Post: <mailto:pgsql-admin@lists.postgresql.org>
List-Owner: <mailto:pgsql-admin-owner@lists.postgresql.org>
List-Archive: <https://www.postgresql.org/list/pgsql-admin>
Archived-At: 
 <https://www.postgresql.org/message-id/BY1P223MB1208C644D69B24BDFE0C306DD6332%40BY1P223MB1208.NAMP223.PROD.OUTLOOK.COM>
Precedence: bulk

--_000_BY1P223MB1208C644D69B24BDFE0C306DD6332BY1P223MB1208NAMP_
Content-Type: text/plain; charset="iso-8859-1"
Content-Transfer-Encoding: quoted-printable

Hi

Kindly share the best way in this scenario, as pg_dumpall will be easiest I=
 think too.

Thanks Deepak

Sent from Outlook for Android<https://aka.ms/AAb9ysg>
________________________________
From: Devrim G=FCnd=FCz <devrim@gunduz.org>
Sent: Sunday, December 8, 2024 2:14:06 AM
To: pgsql-admin@lists.postgresql.org <pgsql-admin@lists.postgresql.org>; vr=
ms <vrms@netcologne.de>
Subject: Re: Postgres compatibility with RHEL

Sorry, but pg_dumpall is almost never the best way - or even good way.


On 7 December 2024 17:43:11 CET, vrms <vrms@netcologne.de> wrote:
I believe the best way would be to

  1. setup a new rhel9 server with pg16
  2. get a dump (pg_dumpall) from the old machine onto the new machine
  3. restore that dump
  4. copy pg_hba.conf and postgresql.conf over to the new machine
  4.1. make sure to keep the new postgresql.conf and adjust custom settings=
 you may have on the old machine with making sure those settings have not c=
hanged

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


On 04.12.24 14:03, Siddhartha Jain wrote:
Hi,

Please let me know if Postgresql 16 is compatible with RHEL 7.9 version and=
 RHEL 9.1 version.
I need to upgrade postgres from 11.22 to 16.6 and need information for that=
 as the OS version is going to upgrade from 7.9 to 9.1.
Also, let me know the strategies if any to upgrade both RHEL and DB.

Thanks,
Siddhartha

--_000_BY1P223MB1208C644D69B24BDFE0C306DD6332BY1P223MB1208NAMP_
Content-Type: text/html; charset="iso-8859-1"
Content-Transfer-Encoding: quoted-printable

<html>
<head>
<meta http-equiv=3D"Content-Type" content=3D"text/html; charset=3Diso-8859-=
1">
</head>
<body>
<div dir=3D"auto">Hi</div>
<div dir=3D"auto"><br>
</div>
<div dir=3D"auto">Kindly share the best way in this scenario, as pg_dumpall=
 will be easiest I think too.</div>
<div dir=3D"auto"><br>
</div>
<div dir=3D"auto">Thanks Deepak&nbsp;</div>
<div id=3D"ms-outlook-mobile-signature" dir=3D"auto">
<div><br>
</div>
Sent from <a href=3D"https://aka.ms/AAb9ysg">Outlook for Android</a></div>
<hr style=3D"display:inline-block;width:98%" tabindex=3D"-1">
<div id=3D"divRplyFwdMsg" dir=3D"ltr"><font face=3D"Calibri, sans-serif" st=
yle=3D"font-size:11pt" color=3D"#000000"><b>From:</b> Devrim G=FCnd=FCz &lt=
;devrim@gunduz.org&gt;<br>
<b>Sent:</b> Sunday, December 8, 2024 2:14:06 AM<br>
<b>To:</b> pgsql-admin@lists.postgresql.org &lt;pgsql-admin@lists.postgresq=
l.org&gt;; vrms &lt;vrms@netcologne.de&gt;<br>
<b>Subject:</b> Re: Postgres compatibility with RHEL</font>
<div>&nbsp;</div>
</div>
<div>
<div dir=3D"auto">Sorry, but pg_dumpall is almost never the best way - or e=
ven good way.
</div>
<br>
<br>
<div class=3D"x_gmail_quote">
<div dir=3D"auto">On 7 December 2024 17:43:11 CET, vrms &lt;vrms@netcologne=
.de&gt; wrote:</div>
<blockquote class=3D"x_gmail_quote" style=3D"margin:0pt 0pt 0pt 0.8ex; bord=
er-left:1px solid rgb(204,204,204); padding-left:1ex">
<font face=3D"Helvetica, Arial, sans-serif">I believe the best way would be=
 to <br>
<br>
&nbsp; 1. setup a new rhel9 server with pg16<br>
</font>&nbsp; 2. get a dump (pg_dumpall) from the old machine onto the new =
machine<br>
&nbsp; 3. restore that dump<br>
&nbsp; 4. copy pg_hba.conf and postgresql.conf over to the new machine<br>
&nbsp; 4.1. make sure to keep the new postgresql.conf and adjust custom set=
tings you may have on the old machine with making sure those settings have =
not changed<br>
<br>
If you want to do this close to zero downtime, you could set up logical rep=
lication to the new pg16 machine and once that is finished switch over and =
promote that to be the new main.<br>
<br>
<br>
<br>
<div class=3D"x_moz-cite-prefix">On 04.12.24 14:03, Siddhartha Jain wrote:<=
br>
</div>
<blockquote type=3D"cite">
<div dir=3D"auto">Hi,
<div dir=3D"auto"><br>
</div>
<div dir=3D"auto">Please let me know if Postgresql 16 is compatible with RH=
EL 7.9 version and RHEL 9.1 version.</div>
<div dir=3D"auto">I need to upgrade postgres from 11.22 to 16.6 and need in=
formation for that as the OS version is going to upgrade from 7.9 to 9.1.&n=
bsp;</div>
<div dir=3D"auto">Also, let me know the strategies if any to upgrade both R=
HEL and DB.&nbsp;</div>
<div dir=3D"auto"><br>
</div>
<div dir=3D"auto">Thanks,</div>
<div dir=3D"auto">Siddhartha&nbsp;</div>
</div>
</blockquote>
</blockquote>
</div>
</div>
</body>
</html>

--_000_BY1P223MB1208C644D69B24BDFE0C306DD6332BY1P223MB1208NAMP_--