| From: | Devrim Gündüz <devrim(at)gunduz(dot)org> |
|---|---|
| To: | abbas alizadeh <ramkly(at)yahoo(dot)com>, pgsql-admin(at)lists(dot)postgresql(dot)org |
| Subject: | Re: Pg_upgrade issue |
| Date: | 2020-12-24 15:12:48 |
| Message-ID: | 2878a62940de45383e074123f5312971105b6f38.camel@gunduz.org |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-admin |
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
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Marcelo Miranda | 2020-12-25 15:34:22 | ImportError: /usr/lib64/python3.6/site-packages/psycopg2/_psycopg.cpython-36m-x86_64-linux-gnu.so: undefined symbol: PQencryptPasswordConn |
| Previous Message | Yambu | 2020-12-24 07:24:15 | Re: Logical replication and truncate table |