From: abbas alizadeh <ramkly@yahoo.com>
To: pgsql-admin@lists.postgresql.org
Subject: Pg_upgrade issue
Date: Mon, 21 Dec 2020 17:51:59 +0800
Message-ID: <7074310B-DF7D-4CCD-A7B3-E14A11162952@yahoo.com> (raw)
References: <7074310B-DF7D-4CCD-A7B3-E14A11162952.ref@yahoo.com>
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?
Following picture is my plan to upgrade.
Best Rigards
Abbas.=
Attachments:
[image/png] solution.png (73.0K, ../7074310B-DF7D-4CCD-A7B3-E14A11162952@yahoo.com/3-solution.png)
download | view image
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, pgsql-admin@lists.postgresql.org
Subject: Re: Pg_upgrade issue
In-Reply-To: <7074310B-DF7D-4CCD-A7B3-E14A11162952@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