From: abbas alizadeh <ramkly@yahoo.com>
To: David G. Johnston <david.g.johnston@gmail.com>
Cc: pgsql-admin <pgsql-admin@postgresql.org>
Subject: Re: Upgrade postgresql
Date: Tue, 6 Jul 2021 12:43:36 +0800
Message-ID: <6696AE88-3B1C-4DAA-A3AE-62EB08140FD8@yahoo.com> (raw)
In-Reply-To: <CAKFQuwaPufE1Nc67-EyXm+hGbzpU=ZQpZPGYjvRroP4wiiCChw@mail.gmail.com>
References: <CAKFQuwaPufE1Nc67-EyXm+hGbzpU=ZQpZPGYjvRroP4wiiCChw@mail.gmail.com>
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.
>
> 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.
>
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-admin@postgresql.org
Cc: ramkly@yahoo.com, david.g.johnston@gmail.com
Subject: Re: Upgrade postgresql
In-Reply-To: <6696AE88-3B1C-4DAA-A3AE-62EB08140FD8@yahoo.com>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox