DHIS 2, PostgreSQL only

Hi all,

after gathering feedback from the community we have decided to support PostgreSQL only as database platform for DHIS 2 starting from version 2.29 (i.e. the next release).

This will allow us to utilize some of the sophisticated features specific to PostgreSQL in order to make a better system. As example, this will help us to improve the analytics and data import/export functionality.

The minimum version required will be PostgreSQL version 9.0. We do however recommend migrating to PostgreSQL 10 as it provides performance improvements and new features which may be utilized in near-future DHIS 2 releases.

best regards,

Lars

···


Lars Helge Øverland

Lead developer, DHIS 2

University of Oslo

Skype: larshelgeoverland

lars@dhis2.org

http://www.dhis2.org

1 Like

Good decision. I assume this means H2 will also no longer be a fallback? So dhis2 live will also require PG?

Knut

···

On Nov 9, 2017 3:32 PM, “Lars Helge Øverland” lars@dhis2.org wrote:

Hi all,

after gathering feedback from the community we have decided to support PostgreSQL only as database platform for DHIS 2 starting from version 2.29 (i.e. the next release).

This will allow us to utilize some of the sophisticated features specific to PostgreSQL in order to make a better system. As example, this will help us to improve the analytics and data import/export functionality.

The minimum version required will be PostgreSQL version 9.0. We do however recommend migrating to PostgreSQL 10 as it provides performance improvements and new features which may be utilized in near-future DHIS 2 releases.

best regards,

Lars


Lars Helge Øverland

Lead developer, DHIS 2

University of Oslo

Skype: larshelgeoverland

lars@dhis2.org

http://www.dhis2.org


Mailing list: https://launchpad.net/~dhis2-devs

Post to : dhis2-devs@lists.launchpad.net

Unsubscribe : https://launchpad.net/~dhis2-devs

More help : https://help.launchpad.net/ListHelp

We will continue to use H2 for internal purposes (unit testing) for a
while, and the system will still start and mostly work on H2. However there
will gradually be more features requiring PostgreSQL, and we hope to
replace Live with a Docker image in near future.

As part of the move to PostgreSQL we will also require the PostGIS
extension.

Lars

···

On Thu, Nov 9, 2017 at 5:42 PM, Knut Staring <knutst@gmail.com> wrote:

Good decision. I assume this means H2 will also no longer be a fallback?
So dhis2 live will also require PG?

--
Lars Helge Øverland
Lead developer, DHIS 2
University of Oslo
Skype: larshelgeoverland
lars@dhis2.org
http://www.dhis2.org <https://www.dhis2.org/>

Very good Lars! Looking at the move to postgresql 10 (presumably one
or two more versions down the line), have you been considering the
native partitioning support for dealing with huge datavalue tables?
This looks like it might be very suited to our classic problem of
large amounts of historic data..

···

On 9 November 2017 at 20:47, Lars Helge Øverland <lars@dhis2.org> wrote:

On Thu, Nov 9, 2017 at 5:42 PM, Knut Staring <knutst@gmail.com> wrote:

Good decision. I assume this means H2 will also no longer be a fallback?
So dhis2 live will also require PG?

We will continue to use H2 for internal purposes (unit testing) for a while,
and the system will still start and mostly work on H2. However there will
gradually be more features requiring PostgreSQL, and we hope to replace Live
with a Docker image in near future.

As part of the move to PostgreSQL we will also require the PostGIS
extension.

Lars

--
Lars Helge Øverland
Lead developer, DHIS 2
University of Oslo
Skype: larshelgeoverland
lars@dhis2.org
http://www.dhis2.org

_______________________________________________
Mailing list: https://launchpad.net/~dhis2-devs
Post to : dhis2-devs@lists.launchpad.net
Unsubscribe : https://launchpad.net/~dhis2-devs
More help : https://help.launchpad.net/ListHelp

Yes. The datavalue table is definitely a good candidate for partitioning.

···

On Thu, Nov 9, 2017 at 5:53 PM, Bob Jolliffe bobjolliffe@gmail.com wrote:

Very good Lars! Looking at the move to postgresql 10 (presumably one

or two more versions down the line), have you been considering the

native partitioning support for dealing with huge datavalue tables?

This looks like it might be very suited to our classic problem of

large amounts of historic data…

On 9 November 2017 at 20:47, Lars Helge Øverland lars@dhis2.org wrote:

On Thu, Nov 9, 2017 at 5:42 PM, Knut Staring knutst@gmail.com wrote:

Good decision. I assume this means H2 will also no longer be a fallback?

So dhis2 live will also require PG?

We will continue to use H2 for internal purposes (unit testing) for a while,

and the system will still start and mostly work on H2. However there will

gradually be more features requiring PostgreSQL, and we hope to replace Live

with a Docker image in near future.

As part of the move to PostgreSQL we will also require the PostGIS

extension.

Lars

Lars Helge Øverland

Lead developer, DHIS 2

University of Oslo

Skype: larshelgeoverland

lars@dhis2.org

http://www.dhis2.org


Mailing list: https://launchpad.net/~dhis2-devs

Post to : dhis2-devs@lists.launchpad.net

Unsubscribe : https://launchpad.net/~dhis2-devs

More help : https://help.launchpad.net/ListHelp

Lars Helge Øverland

Lead developer, DHIS 2

University of Oslo

Skype: larshelgeoverland

lars@dhis2.org

http://www.dhis2.org