Re: Upgrading PG11 to PG17 without dump/restore - Mailing list pgsql-general

From Justin Clift
Subject Re: Upgrading PG11 to PG17 without dump/restore
Date
Msg-id f49758e620f7dfa42207d4c7ffdaffa0@postgresql.org
Whole thread Raw
In response to Upgrading PG11 to PG17 without dump/restore  (Durumdara <durumdara@gmail.com>)
List 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



pgsql-general by date:

Previous
From: Justin Clift
Date:
Subject: Is anyone up for hosting the online PG game "Schemaverse"?
Next
From: Abdul Sayeed
Date:
Subject: Re: Pgbackrest : Resumable backup of same type exists