MIME-Version: 1.0
References: 
 <CAB5fag5dJZj-woa92nu+nO22J08UAzXeaDZAnPJQ_TQxhKPtLQ@mail.gmail.com>
In-Reply-To: 
 <CAB5fag5dJZj-woa92nu+nO22J08UAzXeaDZAnPJQ_TQxhKPtLQ@mail.gmail.com>
From: Zaid Shabbir <zaidshabbir@gmail.com>
Date: Wed, 11 Jun 2025 20:15:16 +0500
Message-ID: 
 <CABCJe_VFUbp8p3N_vz=jSK_E0vTd_FmqVD+bWEB=BR=DEvwTsA@mail.gmail.com>
Subject: Re: Upgrade from 12.22 to 16
To: Wasim Devale <wasimd60@gmail.com>
Cc: pgsql-admin <pgsql-admin@postgresql.org>,
	Pgsql-admin <pgsql-admin@lists.postgresql.org>
Content-Type: multipart/alternative; boundary="0000000000008d85c406374d480d"
Archived-At: 
 <https://www.postgresql.org/message-id/CABCJe_VFUbp8p3N_vz%3DjSK_E0vTd_FmqVD%2BbWEB%3DBR%3DDEvwTsA%40mail.gmail.com>
Precedence: bulk

--0000000000008d85c406374d480d
Content-Type: text/plain; charset="UTF-8"
Content-Transfer-Encoding: quoted-printable

Hello Wasim,

Minimum downtime can be achieved in a couple of ways, depending entirely on
the specific requirements. If you're considering using logical replication
to achieve this, the following article will definitely help you.

https://www.pgedge.com/blog/always-online-or-bust-zero-downtime-major-versi=
on-postgres-upgrades

Thanks & Regards
Zaid

On Wed, Jun 11, 2025 at 11:22=E2=80=AFAM Wasim Devale <wasimd60@gmail.com> =
wrote:

> Hi All
>
> Please suggest me to upgrade postgresql: 400 GB data with minimal downtim=
e
> apart from in place upgrade. We have it on red hat 9.
>
> Thanks,
> Wasim
>

--0000000000008d85c406374d480d
Content-Type: text/html; charset="UTF-8"
Content-Transfer-Encoding: quoted-printable

<div dir=3D"ltr">Hello Wasim,<div><br></div>Minimum downtime can be achieve=
d in a couple of ways, depending entirely on the specific requirements. If =
you&#39;re considering using logical replication to achieve this, the follo=
wing article will definitely help you.<div><br></div><div><a href=3D"https:=
//www.pgedge.com/blog/always-online-or-bust-zero-downtime-major-version-pos=
tgres-upgrades">https://www.pgedge.com/blog/always-online-or-bust-zero-down=
time-major-version-postgres-upgrades<br></a></div><div><br></div><div>Thank=
s &amp;=C2=A0Regards</div><div>Zaid</div></div><br><div class=3D"gmail_quot=
e gmail_quote_container"><div dir=3D"ltr" class=3D"gmail_attr">On Wed, Jun =
11, 2025 at 11:22=E2=80=AFAM Wasim Devale &lt;<a href=3D"mailto:wasimd60@gm=
ail.com">wasimd60@gmail.com</a>&gt; wrote:<br></div><blockquote class=3D"gm=
ail_quote" style=3D"margin:0px 0px 0px 0.8ex;border-left-width:1px;border-l=
eft-style:solid;border-left-color:rgb(204,204,204);padding-left:1ex"><div d=
ir=3D"auto">Hi All<div dir=3D"auto"><br></div><div dir=3D"auto">Please sugg=
est me to upgrade postgresql: 400 GB data with minimal downtime apart from =
in place upgrade. We have it on red hat 9.</div><div dir=3D"auto"><br></div=
><div dir=3D"auto">Thanks,</div><div dir=3D"auto">Wasim</div></div>
</blockquote></div>

--0000000000008d85c406374d480d--