Re: Upgrading PG11 to PG17 without dump/restore

Justin Clift <justin@postgresql.org>

From: Justin Clift <justin@postgresql.org>
To: Durumdara <durumdara@gmail.com>
Cc: Postgres General <pgsql-general@postgresql.org>
Date: 2025-05-01T22:27:30Z
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