Обсуждение: Upgrade postgresql
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? Best regards Abbas
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.
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.
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.