Exactly. Database upgrade is a bit of a task to be planned for. There is also the all the db user accounts and the like. Sometimes it is easier to just update the whole cluster than individually exporting and importing databases. All of which is why I was hoping folk with 9.3 would be able to enjoy the new functionality without going through this first - it looks like they should be able to.
On 26 April 2016 at 20:34, Dan Cocos <[email protected]> wrote: > Hi All, > > Admins should also be careful because Postgres doesn't automatically > update between versions, you usually have to export, drop then import into > the new version and postgres 9.4 won't start if there is a 9.3 database > still around. > > Dan > > > *Dan Cocos* > Principal, BAO Systems > +1 202-352-2671 | [email protected] <[email protected]> | > http://www.baosystems.com | 2900 K Street, Suite 404, Washington D.C. > 20007 > > > > > On Apr 26, 2016, at 7:21 AM, Lars Helge Øverland <[email protected]> wrote: > > Hi Bob, > > I have not tested all combinations of postgresql and postgis versions. > > However, according to the docs, PostGIS 2.2 works against PostgreSQL 9.1 > and later: > > > http://postgis.net/docs/manual-2.2/postgis_installation.html#install_requirements > > We have of course tested DHIS 2 against PostGIS 2.2, so this should be > safe. > > Lars > > > > > > On Tue, Apr 26, 2016 at 11:35 AM, Bob Jolliffe <[email protected]> > wrote: > >> Hi Lars >> >> I know that a lot of production servers are running postgres 9.3 >> (default with ubuntu 14.04). >> >> The instructions assume postgres 9.4 is used. I know they could >> upgrade, but I wonder has anybody tested the gis extensions with 9.3? >> >> Regards >> Bob >> >> On 25 April 2016 at 18:38, Lars Helge Øverland <[email protected]> wrote: >> > Hi all, >> > >> > a few things to be aware of when upgrading to DHIS 2.23 (click on the >> link >> > below or continue reading this email): >> > >> > https://www.dhis2.org/223-upgrade >> > >> > >> > >> > Database >> > >> > Run the database SQL upgrade script once before updating the WAR file. >> It >> > only applies if you have set up program rules for your system. >> > >> > >> > Server >> > >> > In order to take advantage of the GIS clustering functionality >> introduced in >> > DHIS 2.23 you must install the PostGIS extender on the server. After >> > installing the extender, PostGIS will be installed in the database >> > automatically when DHIS 2 is started. Please read the installation >> guide. >> > Basically you can invoke: >> > >> > sudo apt-get install postgresql-9.4 postgresql-9.4-postgis-2.2 >> > postgresql-contrib-9.4 >> > >> > User Interface >> > >> > The Organisation unit module has been merged into the Maintenance app. >> > >> > The Data elements and Indicators module has been merged into the >> Maintenance >> > app. >> > >> > The schedule program messages function has been moved from the Program >> app >> > to the Data administration app under Scheduling. >> > >> > The local SMS modem functionality which could be configured under the >> Mobile >> > Configuration app has been removed from the system. >> > >> > >> > >> > regards, >> > >> > Lars >> > >> > >> > >> > -- >> > Lars Helge Øverland >> > Lead developer, DHIS 2 >> > University of Oslo >> > Skype: larshelgeoverland >> > http://www.dhis2.org >> > >> > >> > _______________________________________________ >> > Mailing list: https://launchpad.net/~dhis2-devs >> > Post to : [email protected] >> > 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 > http://www.dhis2.org <https://www.dhis2.org/> > > _______________________________________________ > Mailing list: https://launchpad.net/~dhis2-devs > Post to : [email protected] > Unsubscribe : https://launchpad.net/~dhis2-devs > More help : https://help.launchpad.net/ListHelp > > >
_______________________________________________ Mailing list: https://launchpad.net/~dhis2-devs Post to : [email protected] Unsubscribe : https://launchpad.net/~dhis2-devs More help : https://help.launchpad.net/ListHelp
