On Wed, Jun 11, 2025 at 2:54 AM Wasim Devale <wasimd60@xxxxxxxxx> wrote:
I mean to say that we do not want to do the in place upgrade
Why not? Using the default --copy option, there's minimal downtime, and the old database is still there in case you need to fall back, etc.
also the other option of taking dump and restoration of it. If I can have any robust plan who all have worked on that then please suggest me.
Thanks,
Wasim---------- Forwarded message ---------
From: Laurenz Albe <laurenz.albe@xxxxxxxxxxx>
Date: Wed, 11 Jun, 2025, 12:13 pm
Subject: Re: Upgrade from 12.22 to 16
To: Wasim Devale <wasimd60@xxxxxxxxx>, Pgsql-admin <pgsql-admin@xxxxxxxxxxxxxxxxxxxx>
On Wed, 2025-06-11 at 11:51 +0530, Wasim Devale wrote:
> Please suggest me to upgrade postgresql: 400 GB data with minimal downtime apart
> from in place upgrade. We have it on red hat 9.
What do you mean with "apart from"?
Yours,
Laurenz Albe
Death to <Redacted>, and butter sauce.
Don't boil me, I'm still alive.
<Redacted> lobster!
