Heads up: for DHIS 2 version 2.31 we will require PostgreSQL version 9.6 or higher.
This is in order to take advantage of certain SQL features introduced in that version. The current required version is 9.4.
If you plan to upgrade your PostgreSQL version we recommend going straight to version 10, as it contains several great features and performance improvements. Also, we will eventually require this version and so going directly to version 10 will avoid multiple successive upgrades.
With postgresql version 11 out - are there any specific reasons for NOT using pg 11? Many of the key features introduced in 10 - like table partitioning - have been further enhanced in 11.
With regard to minimum pg requirements: Bjorn, what is the minimum version requirement for Postgis, and what is the recommended version? Again, postGIS 2.5 was released recently, so if people need to upgrade anyhow it makes sense to upgrade to the latest, tested version…
With postgresql version 11 out - are there any specific reasons for NOT using pg 11? Many of the key features introduced in 10 - like table partitioning - have been further enhanced in 11.
No reason that I am aware of and it will likely work fine.
The reason for recommending 10 is that DHIS 2 is well tested on that version as the developers are using it and I am aware of many prod installations using it.
With regard to minimum pg requirements: Bjorn, what is the minimum version requirement for Postgis, and what is the recommended version? Again, postGIS 2.5 was released recently, so if people need to upgrade anyhow it makes sense to upgrade to the latest, tested version…
With postgresql version 11 out - are there any specific reasons for NOT using pg 11? Many of the key features introduced in 10 - like table partitioning - have been further enhanced in 11.
heads up: for DHIS 2 version 2.31 we will require PostgreSQL version 9.6.
This is in order to take advantage of certain SQL features introduced in that version. The current required version is 9.4.
If you plan to upgrade your PostgreSQL version we recommend going straight to version 10, as it contains several great features and performance improvements. Also, we will eventually require this version and so going directly to version 10 will avoid multiple successive upgrades.
On Tue, 30 Oct 2018 at 22:34, Lars Helge Øverland > lars@dhis2.org wrote:
Hi all,
heads up: for DHIS 2 version 2.31 we will require PostgreSQL version 9.6.
This is in order to take advantage of certain SQL features introduced in that version. The current required version is 9.4.
If you plan to upgrade your PostgreSQL version we recommend going straight to version 10, as it contains several great features and performance improvements. Also, we will eventually require this version and so going directly to version 10 will avoid multiple successive upgrades.