Re: Pg_upgrade issue

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



Hi,

On Mon, 2020-12-21 at 17:51 +0800, abbas alizadeh wrote:
> I wanna upgrade a postgresql database from version 9.0 to 12.4 using
> pg_upgrade.
> But I have an issue with postgis, in current postgresql, postgis v2.0
> (possible to upgrade to 2.2) is in use which is not compatible with
> pg v12.4 and is the last version we can use in pg v9.0(postgis v2.2),
> so it seems I can’t upgrade database directly from 9.0 to 12.4, the
> solution I try to use is to upgrade pg v9.2 to v9.6 then on pg v9.6
> upgrade postgis to v3.0, and then upgrade pg v9.6 to pg v12.4.
> I just wanna know if there is any better solution I can use in this
> case ir no?

That is the suggested solution in the PostGIS docs.

Regards,

-- 
Devrim Gündüz
Open Source Solution Architect, Red Hat Certified Engineer
Twitter: @DevrimGunduz , @DevrimGunduzTR

Attachment: signature.asc
Description: This is a digitally signed message part


[Index of Archives]     [Postgresql Home]     [Postgresql General]     [Postgresql Performance]     [Postgresql PHP]     [Postgresql Jobs]     [PHP Users]     [PHP Databases]     [PHP Home]     [PHP on Windows]     [Kernel Newbies]     [PHP Classes]     [PHP Databases]     [Yosemite Forum]

  Powered by Linux