Re: Upgrading PG11 to PG17 without dump/restore

From: Justin Clift <justin(at)postgresql(dot)org>
To: Durumdara <durumdara(at)gmail(dot)com>
Cc: Postgres General <pgsql-general(at)postgresql(dot)org>
Subject: Re: Upgrading PG11 to PG17 without dump/restore
Date: 2025-05-01 22:27:30
Message-ID: f49758e620f7dfa42207d4c7ffdaffa0@postgresql.org
Views: Whole Thread | Raw Message | Download mbox | Resend email
Thread:
Lists: pgsql-general

On 2025-05-01 23:06, Durumdara wrote:
<snip>
> The PG_Upgrade is not possible because of lesser space and too old
> debian.

As a data point, pg_upgrade has an option to do an in-place upgrade
which
reuses the vast majority of the data files as they are on disk, rather
than
making a copy.

It's useful for larger databases, and for situations where you don't
have
much space.

BUT, you *do* have backups don't you?

Because stuff *can* go wrong, even though it's not common. ;)

Regards and best wishes,

Justin Clift

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Abdul Sayeed 2025-05-02 05:52:11 Re: Pgbackrest : Resumable backup of same type exists
Previous Message Justin Clift 2025-05-01 22:23:00 Is anyone up for hosting the online PG game "Schemaverse"?