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