From: Matti Linnanvuori <mattilinnanvuori@yahoo.com>
To: David G. Johnston <david.g.johnston@gmail.com>
To: abbas alizadeh <ramkly@yahoo.com>
Cc: pgsql-admin <pgsql-admin@postgresql.org>
Subject: Re: Upgrade postgresql
Date: Thu, 15 Jul 2021 11:23:53 +0000 (UTC)
Message-ID: <172713955.3216472.1626348233909@mail.yahoo.com> (raw)
In-Reply-To: <6696AE88-3B1C-4DAA-A3AE-62EB08140FD8@yahoo.com>
References: <CAKFQuwaPufE1Nc67-EyXm+hGbzpU=ZQpZPGYjvRroP4wiiCChw@mail.gmail.com>
<6696AE88-3B1C-4DAA-A3AE-62EB08140FD8@yahoo.com>
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@yahoo.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.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: mattilinnanvuori@yahoo.com, david.g.johnston@gmail.com, ramkly@yahoo.com
Subject: Re: Upgrade postgresql
In-Reply-To: <172713955.3216472.1626348233909@mail.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