Re: PG Dump on 11 - Restore on 16 - is possible? - Mailing list pgsql-general

From Ron Johnson
Subject Re: PG Dump on 11 - Restore on 16 - is possible?
Date
Msg-id CANzqJaBh3cu=RspmXCjkWeu0-GL0mtf5-iNaj9YSE9-AyEQ1KQ@mail.gmail.com
Whole thread Raw
In response to Re: PG Dump on 11 - Restore on 16 - is possible?  (Tomas Vondra <tomas@vondra.me>)
List pgsql-general
On Tue, Aug 13, 2024 at 2:21 PM Tomas Vondra <tomas@vondra.me> wrote:
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.

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

pgsql-general by date:

Previous
From: Tomas Vondra
Date:
Subject: Re: PG Dump on 11 - Restore on 16 - is possible?
Next
From: Durgamahesh Manne
Date:
Subject: Re: autovacuum freeze recommendations at table level