public inbox for [email protected]  

help / color / mirror / Atom feed

From: Laurenz Albe <[email protected]>
To: Wasim Devale <[email protected]>
Cc: Pgsql-admin <[email protected]>
Subject: Re: Upgrade from 12.22 to 16
Date: Wed, 11 Jun 2025 09:38:47 +0200
Message-ID: <[email protected]> (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, 2025-06-11 at 12:23 +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.
>
> I mean to say that we do not want to do the in place upgrade 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.

"I want to upgrade with minimal downtime, but I don't want the natural, simple
 solution for upgrade with minimal downtime."

Strange requirement, but if you feel you want to make your life more difficult, you
can use logical replication for an upgrade with very short downtime.

Yours,
Laurenz Albe

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], [email protected]
  Subject: Re: Upgrade from 12.22 to 16
  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