Postgres Pro
Downloads
Home   >   mailing lists

Re: Major upgrade from 9.6.15 to 12.2 - Mailing list pgsql-novice

From Uwe Seher
Subject Re: Major upgrade from 9.6.15 to 12.2
Date
Msg-id CADtXaag9J0j_+TWLJWT93dYOVShSC-H5gxV2gKf9LYFwD5FgEw@mail.gmail.com
Whole thread Raw
In response to Major upgrade from 9.6.15 to 12.2  (Elizabeth Fernandez <elizabethfordonez@gmail.com>)
List pgsql-novice
Tree view
Hello!
For postgres i do not see any problems. For postgis you need to read the changes, there are possible isues. But for a first try you can keep your postgis version.

Bye Uwe

Am Di., 10. März 2020 um 22:39 Uhr schrieb Elizabeth Fernandez <elizabethfordonez@gmail.com>:
Hello,
 
We have installed  this versions:

- Ubuntu 16.04.6 LTS  Xenial
- PostgreSQL 9.6.15 on x86_64-pc-linux-gnu (Ubuntu 9.6.15-1.pgdg16.04+1), compiled by gcc (Ubuntu 5.4.0-6ubuntu1~16.04.11) 5.4.0 20160609, 64-bit
- PostGIS lib version 2.3.3
and we want to upgrade to PostgreSQL 12.2.

Taking into account that there are three major versions between the source and the target, in addition to the PostGIS extension installed, is this upgrade possible?
It would be better to upgrade one version at a time?
Do you have any additional recommendation?

Thanks in advanced

pgsql-novice by date:

Previous
From: Keith
Date:
Subject: Re: Major upgrade from 9.6.15 to 12.2
Next
From: Elizabeth Fernandez
Date:
Subject: Re: Major upgrade from 9.6.15 to 12.2