Re: Upgrade postgresql

Поиск
Список
Период
Сортировка
От Matti Linnanvuori
Тема Re: Upgrade postgresql
Дата
Msg-id 172713955.3216472.1626348233909@mail.yahoo.com
обсуждение исходный текст
Ответ на Re: Upgrade postgresql  (abbas alizadeh <ramkly@yahoo.com>)
Список pgsql-admin
Дерево обсуждения
Hi!

There is PostGIS hard upgrade from e.g. PostgreSQL 9.2 to PostgreSQL 13. 
https://postgis.net/docs/manual-3.1/postgis_administration.html#hard_upgrade
I could not make pg_upgrade work for that.

Best regards, Matti Linnanvuori

On Thursday, July 15, 2021, 02:14:51 PM GMT+3, abbas alizadeh <ramkly@yahoo.com> wrote:


Thanks David
I did the same, the big issue is postgresql v9.2 suport postgis up to bersion 2.3 and minimum postgis version which is support bty postgresql v13 is version 2.5.
So what I did was to upgrade postgres v9.2 ti v9.6, then upgrade postgis on pg v9.6 to postgis v.3 and again I upgraded the postgres v9.6 to 13.
But out of curiosity I asked this question to figure out if there is any better solution to upgrade directly from 9.2 to 13 or no

Best regards
Abbas

On 6 Jul 2021, at 11:01 AM, David G. Johnston <david.g.johnston@gmail.com> wrote:

On Monday, July 5, 2021, abbas alizadeh <ramkly@yahoo.com> wrote:
Hi guys
Do we have any chance to upgrade postgresql v9.2 with postgis 2.0 to postgresql v13.3 with postgis 3.0 using pg_upgrade?

I’m gonna say probably not, but you can do your own research if you want to figure whether you might be able to get away with it.


My assumption is that you need to upgrade PostGIS independently from upgrading PostgreSQL - i.e., the PostGIS version should not change during the upgrade.

David J.

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

Предыдущее
От: Ilmir Mulyukov
Дата:
Сообщение: Re: Lc_collate & lc_type? whitespace and nbsp unique index...
Следующее
От: Wells Oliver
Дата:
Сообщение: Partitioning on the date part of a timestamp & PK issues