| From: | Laurenz Albe <laurenz(dot)albe(at)cybertec(dot)at> |
|---|---|
| To: | Wasim Devale <wasimd60(at)gmail(dot)com> |
| Cc: | Pgsql-admin <pgsql-admin(at)lists(dot)postgresql(dot)org> |
| Subject: | Re: Upgrade from 12.22 to 16 |
| Date: | 2025-06-11 07:38:47 |
| Message-ID: | ad7db41dc1963182e561645d5a2e6dc558e3eb4e.camel@cybertec.at |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-admin |
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
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Kushal Shri | 2025-06-11 10:54:54 | PostgreSQL Upgrade (v9.5 to v12) with Django 2.0 |
| Previous Message | Domen Šetar | 2025-06-11 06:57:08 | RE: Upgrade from 12.22 to 16 |