Re: Downgrade pgsql 17 to pgsql 12 question

Поиск
Список
Период
Сортировка
От Merlin Moncure
Тема Re: Downgrade pgsql 17 to pgsql 12 question
Дата
Msg-id CAHyXU0ynqbCHrw3XvofEzidHow4tx1FFGNB2FUR5-wj-EhLcNQ@mail.gmail.com
обсуждение исходный текст
Ответ на Downgrade pgsql 17 to pgsql 12 question  (Ashish Mukherjee <ashish.mukherjee@gmail.com>)
Ответы Re: Downgrade pgsql 17 to pgsql 12 question
Список pgsql-general
On Fri, Sep 26, 2025 at 8:16 AM Ashish Mukherjee <ashish.mukherjee@gmail.com> wrote:
Hello,

I have a strange requirement to downgrade from pgsql 17 to pgsql 12. This is because we found in production certain incompatibilities between both versions for our database. It should have been caught in testing but was not.

Agree with others that snap downgrade is not necessarily a good choice here.  Either way, if I were in your shoes, I'd be loading a plain text dump, maybe with some light massaging to strip out some compatibility issues.

Can you let us know what the hang up is?  Version upgrades these days are usually pretty painless except for some performance issues, unless you have some unusual situations, for example, exotic extensions. 

merlin

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