MIME-Version: 1.0
References: <CAEcMXhmBGDWQnVwvhcg-2SPn4PM=PS+aZCouZiu=FEusevWskA@mail.gmail.com>
 <37ed3aef-58e6-417b-8015-cdf030a6df4b@vondra.me>
In-Reply-To: <37ed3aef-58e6-417b-8015-cdf030a6df4b@vondra.me>
From: Ron Johnson <ronljohnsonjr@gmail.com>
Date: Tue, 13 Aug 2024 14:32:50 -0400
Message-ID: <CANzqJaBh3cu=RspmXCjkWeu0-GL0mtf5-iNaj9YSE9-AyEQ1KQ@mail.gmail.com>
Subject: Re: PG Dump on 11 - Restore on 16 - is possible?
To: Postgres General <pgsql-general@postgresql.org>
Content-Type: multipart/alternative; boundary="000000000000e85c42061f94d698"
Archived-At: <https://www.postgresql.org/message-id/CANzqJaBh3cu%3DRspmXCjkWeu0-GL0mtf5-iNaj9YSE9-AyEQ1KQ%40mail.gmail.com>
Precedence: bulk

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

On Tue, Aug 13, 2024 at 2:21=E2=80=AFPM Tomas Vondra <tomas@vondra.me> wrot=
e:

> On 8/13/24 11:47, Durumdara wrote:
> > Hello!
> >
> > We have to upgrade our server. The PG upgrade is impossible because of
> > too much data.
>
> I'm not sure I understand. What exactly is the problem with the amount
> of data?
>

OP has a physical server, and the cabinet's disk trays are all full (or at
least not enough free trays to add enough disk space).

But, you say, 20TB disks exist!!  Yeah, and the channel speed is slow.
Besides, given that it's PG 11, the OS (RHEL?) is probably also EOL (or
soon to be).

Thus, better to buy a new / faster server, install RHEL9 and PG 16.

--=20
Death to America, and butter sauce.
Iraq lobster!

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

<div dir=3D"ltr"><div dir=3D"ltr">On Tue, Aug 13, 2024 at 2:21=E2=80=AFPM T=
omas Vondra &lt;<a href=3D"mailto:tomas@vondra.me">tomas@vondra.me</a>&gt; =
wrote:<br></div><div class=3D"gmail_quote"><blockquote class=3D"gmail_quote=
" style=3D"margin:0px 0px 0px 0.8ex;border-left:1px solid rgb(204,204,204);=
padding-left:1ex">On 8/13/24 11:47, Durumdara wrote:<br>
&gt; Hello!<br>
&gt; <br>
&gt; We have to upgrade our server. The PG upgrade is impossible because of=
<br>
&gt; too much=C2=A0data.<br>
<br>
I&#39;m not sure I understand. What exactly is the problem with the amount<=
br>
of data?=C2=A0<br>
</blockquote></div><div><br></div>OP has a physical server, and the cabinet=
&#39;s disk trays are all full (or at least not enough free trays to add en=
ough disk space).<br clear=3D"all"><div><br></div><div>But, you say, 20TB d=
isks exist!!=C2=A0 Yeah, and the channel speed is slow.=C2=A0 Besides, give=
n that it&#39;s PG 11, the OS (RHEL?) is probably also EOL (or soon to be).=
</div><div><br></div><div>Thus, better to buy a new / faster server, instal=
l RHEL9 and PG 16.</div><div><br></div><span class=3D"gmail_signature_prefi=
x">-- </span><br><div dir=3D"ltr" class=3D"gmail_signature"><div dir=3D"ltr=
">Death to America, and butter sauce.<div>Iraq lobster!</div></div></div></=
div>

--000000000000e85c42061f94d698--