public inbox for [email protected]  

help / color / mirror / Atom feed

From: Justin Clift <[email protected]>
To: Durumdara <[email protected]>
Cc: Postgres General <[email protected]>
Subject: Re: Upgrading PG11 to PG17 without dump/restore
Date: Fri, 02 May 2025 08:27:30 +1000
Message-ID: <[email protected]> (raw)
In-Reply-To: <CAEcMXh=PtUgwj5exvV8PpyvY0H=eOtUkn-wAPcn7p35vkeHzmg@mail.gmail.com>
References: <CAEcMXh=PtUgwj5exvV8PpyvY0H=eOtUkn-wAPcn7p35vkeHzmg@mail.gmail.com>

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

view thread (4+ messages)

reply

Reply instructions:

You may reply publicly to this message via plain-text email
using any one of the following methods:

* Reply to all the recipients using the --to and --cc options:
  reply via email

  To: [email protected]
  Cc: [email protected], [email protected]
  Subject: Re: Upgrading PG11 to PG17 without dump/restore
  In-Reply-To: <[email protected]>

* Save the following mbox file, import it into your mail client,
  and reply-to-all from there: mbox

This inbox is served by agora; see mirroring instructions
for how to clone and mirror all data and code used for this inbox