public inbox for [email protected]  
help / color / mirror / Atom feed
From: Ron Johnson <[email protected]>
To: pgsql-admin <[email protected]>
Subject: Re: Upgrade from 12.22 to 16
Date: Wed, 11 Jun 2025 09:38:53 -0400
Message-ID: <CANzqJaAg4Tdk-ip-DNr0LLiHkYbDmUb7ZO9Gbi5AX-VdhkyCfw@mail.gmail.com> (raw)
In-Reply-To: <CAB5fag7za_UOfax3Yb7meGRUm4sC5gdOdhMugM5Eafq_BMsySQ@mail.gmail.com>
References: <CAB5fag5dJZj-woa92nu+nO22J08UAzXeaDZAnPJQ_TQxhKPtLQ@mail.gmail.com>
	<[email protected]>
	<CAB5fag7za_UOfax3Yb7meGRUm4sC5gdOdhMugM5Eafq_BMsySQ@mail.gmail.com>

On Wed, Jun 11, 2025 at 2:54 AM Wasim Devale <[email protected]> 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 <[email protected]>
> Date: Wed, 11 Jun, 2025, 12:13 pm
> Subject: Re: Upgrade from 12.22 to 16
> To: Wasim Devale <[email protected]>, Pgsql-admin <
> [email protected]>
>
>
> 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!


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]
  Subject: Re: Upgrade from 12.22 to 16
  In-Reply-To: <CANzqJaAg4Tdk-ip-DNr0LLiHkYbDmUb7ZO9Gbi5AX-VdhkyCfw@mail.gmail.com>

* 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