Re: Upgrade postgresql

[abbas alizadeh <ramkly@xxxxxxxxx>]

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@xxxxxxxxx> wrote:

On Monday, July 5, 2021, abbas alizadeh <ramkly@xxxxxxxxx> 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.

https://trac.osgeo.org/postgis/wiki/UsersWikiPostgreSQLPostGIS

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.