dhis2-users team mailing list archive

["Raminosoa Rabemanantsoa, Tantely" <traminosoa@xxxxxxxxxx>]

Thank you Bob and Knut for those instructions. I am trying to figure out
and will be back to report some news.

Best Regards.

On Fri, Apr 1, 2016 at 5:27 PM, Bob Jolliffe <bobjolliffe@xxxxxxxxx> wrote:

> 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
>>
>>
>

-- 
*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.*