MIME-Version: 1.0
References: 
 <CALOSYAfZvYFYpqNgiLG=GbZK5UNakcvqE6Pm7x9mRGqsEnQ6hQ@mail.gmail.com>
In-Reply-To: 
 <CALOSYAfZvYFYpqNgiLG=GbZK5UNakcvqE6Pm7x9mRGqsEnQ6hQ@mail.gmail.com>
From: Ron Johnson <ronljohnsonjr@gmail.com>
Date: Wed, 4 Dec 2024 09:45:07 -0500
Message-ID: 
 <CANzqJaAcdNpSrhQ1K2b8cvWKnRqgSt6nEeL2gZotfK7qJe++Xw@mail.gmail.com>
Subject: Re: Postgres compatibility with RHEL
To: Pgsql-admin <pgsql-admin@lists.postgresql.org>
Content-Type: multipart/alternative; boundary="000000000000a46dba062872d417"
Archived-At: 
 <https://www.postgresql.org/message-id/CANzqJaAcdNpSrhQ1K2b8cvWKnRqgSt6nEeL2gZotfK7qJe%2B%2BXw%40mail.gmail.com>
Precedence: bulk

--000000000000a46dba062872d417
Content-Type: text/plain; charset="UTF-8"
Content-Transfer-Encoding: quoted-printable

On Wed, Dec 4, 2024 at 8:03=E2=80=AFAM Siddhartha Jain <siddharthajain92@gm=
ail.com>
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.
>

Are you doing an in-place RHEL upgrade on the server?  If so, then I'd:
1) run pg_dump, "pg_dumpall -g", and save postgresql.conf, pg_hba.conf, etc
files when the server is still RHEL 7.9 and PG 11.22,
2) upgrade to RHEL 9.1 (out of scope for this list),
3) install PG 16.6,
4) what you do next depends on your mount points.

--=20
Death to <Redacted>, and butter sauce.
Don't boil me, I'm still alive.
<Redacted> lobster!

--000000000000a46dba062872d417
Content-Type: text/html; charset="UTF-8"
Content-Transfer-Encoding: quoted-printable

<div dir=3D"ltr"><div dir=3D"ltr">On Wed, Dec 4, 2024 at 8:03=E2=80=AFAM Si=
ddhartha Jain &lt;<a href=3D"mailto:siddharthajain92@gmail.com">siddharthaj=
ain92@gmail.com</a>&gt; wrote:</div><div class=3D"gmail_quote"><blockquote =
class=3D"gmail_quote" style=3D"margin:0px 0px 0px 0.8ex;border-left:1px sol=
id rgb(204,204,204);padding-left:1ex"><div dir=3D"auto">Hi,<div dir=3D"auto=
"><br></div><div dir=3D"auto">Please let me know if Postgresql 16 is compat=
ible with RHEL 7.9 version and RHEL 9.1 version.</div><div dir=3D"auto">I n=
eed 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.=C2=A0</div><div dir=3D=
"auto">Also, let me know the strategies if any to upgrade both RHEL and DB.=
=C2=A0</div></div></blockquote><div><br></div><div>Are you doing an in-plac=
e RHEL upgrade on the server?=C2=A0 If so, then I&#39;d:</div><div>1) run p=
g_dump,=C2=A0&quot;pg_dumpall -g&quot;, and save postgresql.conf, pg_hba.co=
nf, etc files when the server is still RHEL 7.9 and PG 11.22,=C2=A0</div><d=
iv>2) upgrade to RHEL 9.1 (out of scope for this list),=C2=A0</div><div>3) =
install PG 16.6,</div><div>4) what you do next depends on your mount points=
.</div><div><br></div></div><span class=3D"gmail_signature_prefix">-- </spa=
n><br><div dir=3D"ltr" class=3D"gmail_signature"><div dir=3D"ltr">Death to =
&lt;Redacted&gt;, and butter sauce.<div>Don&#39;t boil me, I&#39;m still al=
ive.<br><div><div>&lt;Redacted&gt; lobster!</div></div></div></div></div></=
div>

--000000000000a46dba062872d417--