Major upgrade from 9.6.15 to 12.2

Поиск
Список
Период
Сортировка
От Elizabeth Fernandez
Тема Major upgrade from 9.6.15 to 12.2
Дата
Msg-id CAKxEaKiGanCgqPGh21+_qa08UOOaTeNuduxLSmuzfKNrU3UBdg@mail.gmail.com
обсуждение исходный текст
Ответы Re: Major upgrade from 9.6.15 to 12.2  (Keith <keith@keithf4.com>)
Re: Major upgrade from 9.6.15 to 12.2  (Uwe Seher <uwe.seher@gmail.com>)
Список pgsql-novice
Hello,
 
We have installed  this versions:

- Ubuntu 16.04.6 LTS  Xenial
- PostgreSQL 9.6.15 on x86_64-pc-linux-gnu (Ubuntu 9.6.15-1.pgdg16.04+1), compiled by gcc (Ubuntu 5.4.0-6ubuntu1~16.04.11) 5.4.0 20160609, 64-bit
- PostGIS lib version 2.3.3
and we want to upgrade to PostgreSQL 12.2.

Taking into account that there are three major versions between the source and the target, in addition to the PostGIS extension installed, is this upgrade possible?
It would be better to upgrade one version at a time?
Do you have any additional recommendation?

Thanks in advanced

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

Предыдущее
От: Stephen Frost
Дата:
Сообщение: Re: pgbackrest creating new directories (messing up cron jobs).
Следующее
От: mimble9@danwin1210.me
Дата:
Сообщение: Re: pgbackrest creating new directories (messing up cron jobs).