Re: Upgrade from 12.22 to 16

Поиск
Список
Период
Сортировка
От Ron Johnson
Тема Re: Upgrade from 12.22 to 16
Дата
Msg-id CANzqJaAg4Tdk-ip-DNr0LLiHkYbDmUb7ZO9Gbi5AX-VdhkyCfw@mail.gmail.com
обсуждение исходный текст
Ответ на Re: Upgrade from 12.22 to 16  (Wasim Devale <wasimd60@gmail.com>)
Список pgsql-admin
On Wed, Jun 11, 2025 at 2:54 AM Wasim Devale <wasimd60@gmail.com> 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@cybertec.at>
Date: Wed, 11 Jun, 2025, 12:13 pm
Subject: Re: Upgrade from 12.22 to 16
To: Wasim Devale <wasimd60@gmail.com>, Pgsql-admin <pgsql-admin@lists.postgresql.org>


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!

В списке pgsql-admin по дате отправления: