pg.ddx.io pgsql-admin@postgresql.org mailing list archive
help / color / mirror / Atom feedUpgrade postgresql
4+ messages / 3 participants
[nested] [flat]
* Upgrade postgresql
@ 2021-07-06 02:24 abbas alizadeh <ramkly@yahoo.com>
2021-07-06 03:01 ` Re: Upgrade postgresql David G. Johnston <david.g.johnston@gmail.com>
0 siblings, 1 reply; 4+ messages in thread
From: abbas alizadeh @ 2021-07-06 02:24 UTC (permalink / raw)
To: pgsql-admin
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?
Best regards
Abbas
^ permalink raw reply [nested|flat] 4+ messages in thread
* Re: Upgrade postgresql
2021-07-06 02:24 Upgrade postgresql abbas alizadeh <ramkly@yahoo.com>
@ 2021-07-06 03:01 ` David G. Johnston <david.g.johnston@gmail.com>
2021-07-06 04:43 ` Re: Upgrade postgresql abbas alizadeh <ramkly@yahoo.com>
0 siblings, 1 reply; 4+ messages in thread
From: David G. Johnston @ 2021-07-06 03:01 UTC (permalink / raw)
To: abbas alizadeh <ramkly@yahoo.com>; +Cc: pgsql-admin
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.
^ permalink raw reply [nested|flat] 4+ messages in thread
* Re: Upgrade postgresql
2021-07-06 02:24 Upgrade postgresql abbas alizadeh <ramkly@yahoo.com>
2021-07-06 03:01 ` Re: Upgrade postgresql David G. Johnston <david.g.johnston@gmail.com>
@ 2021-07-06 04:43 ` abbas alizadeh <ramkly@yahoo.com>
2021-07-15 11:23 ` Re: Upgrade postgresql Matti Linnanvuori <mattilinnanvuori@yahoo.com>
0 siblings, 1 reply; 4+ messages in thread
From: abbas alizadeh @ 2021-07-06 04:43 UTC (permalink / raw)
To: David G. Johnston <david.g.johnston@gmail.com>; +Cc: pgsql-admin
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.
>
^ permalink raw reply [nested|flat] 4+ messages in thread
* Re: Upgrade postgresql
2021-07-06 02:24 Upgrade postgresql abbas alizadeh <ramkly@yahoo.com>
2021-07-06 03:01 ` Re: Upgrade postgresql David G. Johnston <david.g.johnston@gmail.com>
2021-07-06 04:43 ` Re: Upgrade postgresql abbas alizadeh <ramkly@yahoo.com>
@ 2021-07-15 11:23 ` Matti Linnanvuori <mattilinnanvuori@yahoo.com>
0 siblings, 0 replies; 4+ messages in thread
From: Matti Linnanvuori @ 2021-07-15 11:23 UTC (permalink / raw)
To: David G. Johnston <david.g.johnston@gmail.com>; abbas alizadeh <ramkly@yahoo.com>; +Cc: pgsql-admin
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.
^ permalink raw reply [nested|flat] 4+ messages in thread
end of thread, other threads:[~2021-07-15 11:23 UTC | newest]
Thread overview: 4+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2021-07-06 02:24 Upgrade postgresql abbas alizadeh <ramkly@yahoo.com>
2021-07-06 03:01 ` David G. Johnston <david.g.johnston@gmail.com>
2021-07-06 04:43 ` abbas alizadeh <ramkly@yahoo.com>
2021-07-15 11:23 ` Matti Linnanvuori <mattilinnanvuori@yahoo.com>
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