Re: Upgrade postgresql

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_upgradeI 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(at)yahoo(dot)com> wrote:

Thanks DavidI 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 regardsAbbas

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.