dhis2-devs team mailing list archive

[Bob Jolliffe <bobjolliffe@xxxxxxxxx>]

Hi Gerald

It sounds like you are now panicking a bit which is when you are most
likely to make mistakes.  The biggest concern I would have now is that you
are in danger of losing data.

You say that you have a backup of the database of 161MB but you don't know
if it is any good.  In which case DO NOT purge or remove anything else at
all until you have tested that backup.  To do that you will need to run
postgresql on another machine and restore the database on to there.

I don't know whether 161MB is a reasonable size or not.  Where in the world
are you?  Is this a country database?  How long has it been running.
 Anyway, lets verify that your backup is good (and safely off the machine)
before plotting your next step.

Bob


On 15 January 2014 20:44, Gerald Thomas <gerald.81@xxxxxxxxxxx> wrote:

>  Dan,
> I already done that as we but it is saying “can’t find postregsql”. Maybe
> I will I have to run a new Ubuntu if can’t remove it.
>
> Sent from Windows Mail
>
> *From:* Dan Cocos <dan@xxxxxxxxxxxx>
> *Sent:* Wednesday, January 15, 2014 7:59 PM
> *To:* Gerald Thomas <gerald.81@xxxxxxxxxxx>
> *Cc:* jason.p.pickering@xxxxxxxxx, dhis2-devs@xxxxxxxxxxxxxxxxxxx
>
> Hi Gerald,
>
> If you want to completely remove postgres did you try
> apt-get --purge remove postgresql
> This should remove it and everything related to it.
>
> Dan
>
>
> On Wed, Jan 15, 2014 at 2:26 PM, Gerald Thomas <gerald.81@xxxxxxxxxxx>wrote:
>
>>  Dear Jason,
>> This is currently one of my worst day using the dhis. I tried everything
>> I could be nothing works. I already backup the postregsql database but the
>> size of the file is too small, approximately 161MB. Secondly, I am trying
>> to uninstall the postregsql on the ubnutu and then install another
>> postregsql and finally import the database that I had exported.
>> But my biggest problem is to uninstall the postregsql???
>> when I running this command “sudo apt-get remove postregsql*” the process
>> run but it does not completely uninstall the postregsql and I don’t know
>> what to do now.
>> Please to the forum:
>> How can I completely uninstall postregsql????
>> Since this is a regional server is it possible, that the size of the
>> database is ok???
>> Will my steps finally solve this issue???
>>
>> Sent from Windows Mail
>>
>> *From:* jason.p.pickering@xxxxxxxxx
>> *Sent:* Wednesday, January 15, 2014 3:28 PM
>> *To:* Gerald Thomas <gerald.81@xxxxxxxxxxx>
>> *Cc:* Morten Olav Hansen <mortenoh@xxxxxxxxx>, Olav Poppe<olav.poppe@xxxxxx>,
>> dhis2-devs@xxxxxxxxxxxxxxxxxxx
>>
>> Hi Gerald,
>> In general, a downgrade is tricky. You would need to really restore to
>> 2.12 from a backup copy. In this case, I do not think it would really be
>> necessary, since 2.13 should work. Are you certain this is not a browser
>> caching issue? Did you try and confirm that no data is appearing in
>> incognito mode of your browser or by completely clearing the browser cache?
>> Are the analytics tables present in the database?
>>
>> Regards,
>> Jason
>>
>>
>>
>> On Wed, Jan 15, 2014 at 3:41 PM, Gerald Thomas <gerald.81@xxxxxxxxxxx>wrote:
>>
>>>  Please any help??? I just want to finish with this issue. Please can
>>> anyone help me.
>>>
>>> Sent from Windows Mail
>>>
>>> *From:* Gerald Thomas <gerald.81@xxxxxxxxxxx>
>>> *Sent:* Tuesday, January 14, 2014 9:36 PM
>>> *To:* Morten Olav Hansen <mortenoh@xxxxxxxxx>, Olav Poppe<olav.poppe@xxxxxx>
>>> *Cc:* dhis2-devs@xxxxxxxxxxxxxxxxxxx
>>>
>>> Hi all,
>>> I remotely access the sever and I found that the analytics table update
>>> was completed successfully. But there is still no data and I can’t access
>>> the “data entry”.
>>> Please can I take it back to version 2.12 and see if work on that
>>> version rather than 2.13????
>>> If that process didn’t work; can I backup the database and uninstall and
>>> install postregsql again??
>>> Finally, sorry about it but if I extract the database from the command
>>> line on Ubuntu where can I find the database???
>>>
>>> Sent from Windows Mail
>>>
>>> *From:* Morten Olav Hansen <mortenoh@xxxxxxxxx>
>>> *Sent:* Tuesday, January 14, 2014 9:13 PM
>>> *To:* Olav Poppe <olav.poppe@xxxxxx>
>>> *Cc:* Gerald Thomas <gerald.81@xxxxxxxxxxx>,
>>> dhis2-devs@xxxxxxxxxxxxxxxxxxx
>>>
>>> Hi,
>>>
>>> As Olav says, you might need to run the analytics table update. You can
>>> do this in:
>>> <server>/dhis-web-reporting/displayDataMartForm.action
>>>
>>> This will move all the required datavalues over to the analytics table
>>> (which is used for reporting). This usually happens late at night
>>> automatically, but if you server is down, it will not be run.
>>>
>>> --
>>> Morten
>>>
>>>
>>> On Tue, Jan 14, 2014 at 5:54 PM, Olav Poppe <olav.poppe@xxxxxx> wrote:
>>>
>>>> Hi, have you run the analytics update?
>>>>
>>>> Den 14. jan. 2014 kl. 17:27 skrev Gerald Thomas <gerald.81@xxxxxxxxxxx
>>>> >:
>>>>
>>>>  Dear All,
>>>> One of my regional server which was running on version 2.10
>>>> keeps saying “waiting for localhost” forever on the firefox browser. As a
>>>> means of maintenance, uninstall and install apache tomcat again without
>>>> touching the postregsql but I opted for version 2.13 war file. After the
>>>> installation, I login with the previous admin password but I can’t find any
>>>> data when running report.
>>>> Please can someone help me because I know those information are within
>>>> the database because my previous users profiles was still there.
>>>> Please it is urgent!!!!!
>>>>
>>>> Sent from Windows Mail
>>>>
>>>> _______________________________________________
>>>> Mailing list: https://launchpad.net/~dhis2-devs
>>>> Post to     : dhis2-devs@xxxxxxxxxxxxxxxxxxx
>>>> Unsubscribe : https://launchpad.net/~dhis2-devs
>>>> More help   : https://help.launchpad.net/ListHelp
>>>>
>>>>
>>>> _______________________________________________
>>>> Mailing list: https://launchpad.net/~dhis2-devs
>>>> Post to     : dhis2-devs@xxxxxxxxxxxxxxxxxxx
>>>> Unsubscribe : https://launchpad.net/~dhis2-devs
>>>> More help   : https://help.launchpad.net/ListHelp
>>>>
>>>>
>>>
>>> _______________________________________________
>>> Mailing list: https://launchpad.net/~dhis2-devs
>>> Post to     : dhis2-devs@xxxxxxxxxxxxxxxxxxx
>>> Unsubscribe : https://launchpad.net/~dhis2-devs
>>> More help   : https://help.launchpad.net/ListHelp
>>>
>>>
>>
>> _______________________________________________
>> Mailing list: https://launchpad.net/~dhis2-devs
>> Post to     : dhis2-devs@xxxxxxxxxxxxxxxxxxx
>> Unsubscribe : https://launchpad.net/~dhis2-devs
>> More help   : https://help.launchpad.net/ListHelp
>>
>>
>
> _______________________________________________
> Mailing list: https://launchpad.net/~dhis2-devs
> Post to     : dhis2-devs@xxxxxxxxxxxxxxxxxxx
> Unsubscribe : https://launchpad.net/~dhis2-devs
> More help   : https://help.launchpad.net/ListHelp
>
>