Re: Upgrade postgresql

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(dot)g(dot)johnston(at)gmail(dot)com> wrote:
>
> On Monday, July 5, 2021, abbas alizadeh <ramkly(at)yahoo(dot)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.
>
> 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.
>