dhis2-users team mailing list archive

[Bob Jolliffe <bobjolliffe@xxxxxxxxx>]

There are two ways to apply the upgrade script.  First you have to get it
the server, for example using wget as Knut mentions.  Then you can either
do:

cat upgrade-220.sql | psql dhis2

which might seem a bit obscure if you are not familiar with unix pipes.
Alternatively:

psql -f upgrade-220.sql dhis2

has the same effect.

Note that this assumes you have the permissions to perform the operation on
the database.  I don't know how your database has been setup.  But if your
user is raminosoa then you might first create yourself superuser rights to
the postgres database like:

sudo -u postgres createuser -s raminosoa

If your database is setup on a different machine you would probably have to
use a password.

On 31 March 2016 at 09:51, Raminosoa Rabemanantsoa, Tantely <
traminosoa@xxxxxxxxxx> wrote:

> Dear Knut,
>
> In order to launch the SQL script mentionned here (
> https://github.com/dhis2/dhis2-utils/blob/master/resources/sql/upgrade-220.sql) to
> run against the database to perform necessary upgrades, could you please
> mention a tutorial link illustrating about how to run the script? Our
> postgreSQL database is installed on an Amazon web services with Linux
> operating system.
>
> Thanks,
>
> Tantely.
>
> On Fri, Mar 25, 2016 at 11:21 AM, Knut Staring <knutst@xxxxxxxxx> wrote:
>
>> Hi,
>>  Bob wrote a nice step-by-step here:
>> https://lists.launchpad.net/dhis2-users/msg08793.html
>>
>> I think the most tricky point may be around the shift in encryption
>> mechanisms for passwords in 2.21, as described in the notes.
>>
>> With systematic  backups in the beginning and along the way, and starting
>> and stopping of Tomcat etc, and checking that things are ok, it may take
>> few hours.
>>
>> Good luck,
>> Knut
>>
>> On Fri, Mar 25, 2016 at 7:26 AM, Raminosoa Rabemanantsoa, Tantely <
>> traminosoa@xxxxxxxxxx> wrote:
>>
>>> Hello everyone,
>>>
>>>
>>> We are using DHIS2 2.19 and we are planning to upgrade to the 2.22
>>> version. We have been informed about the upgrade script like the one
>>> mentioned here
>>> https://github.com/dhis2/dhis2-utils/blob/master/resources/sql/upgrade-220.sql
>>> and we would like to ask if there is an upgrade procedure for us to follow
>>> in order to keep all the components for the new version (data values, data
>>> elements, data sets, indicators…). Do you have some idea on how long this
>>> procedure may take?
>>>
>>>
>>> Regards,
>>>
>>>
>>> Tantely
>>>
>>> *This message and its attachments are confidential and solely for the
>>> intended recipients. If received in error, please delete them and notify
>>> the sender via reply e-mail immediately.*
>>> _______________________________________________
>>> Mailing list: https://launchpad.net/~dhis2-users
>>> Post to     : dhis2-users@xxxxxxxxxxxxxxxxxxx
>>> Unsubscribe : https://launchpad.net/~dhis2-users
>>> More help   : https://help.launchpad.net/ListHelp
>>>
>>>
>>
>>
>> --
>> Knut Staring
>> Dept. of Informatics, University of Oslo
>> Norway: +4791880522
>> Skype: knutstar
>> http://dhis2.org
>>
>
>
>
> --
> *Tantely Raminosoa*
> *Data Officer*
> Management Sciences for Health
> Madagascar-Antananarivo Madagascar
> Mobile: 0321180040
> E-mail: traminosoa@xxxxxxxxxx
> Skype: traminosoa
> <http://www.msh.org/>
> Stronger health systems. Greater health impact.
> <https://www.facebook.com/ManagementSciencesForHealth>
> <https://twitter.com/MSHHealthImpact>
> <https://www.youtube.com/user/MSHHealthImpact>
> www.msh.org
>
> *This message and its attachments are confidential and solely for the
> intended recipients. If received in error, please delete them and notify
> the sender via reply e-mail immediately.*
>
> _______________________________________________
> Mailing list: https://launchpad.net/~dhis2-users
> Post to     : dhis2-users@xxxxxxxxxxxxxxxxxxx
> Unsubscribe : https://launchpad.net/~dhis2-users
> More help   : https://help.launchpad.net/ListHelp
>
>