dhis2-devs team mailing list archive

[Knut Staring <knutst@xxxxxxxxx>]

Also, if you are on Windows, you can use something like PeaZip to unzip:
http://peazip.sourceforge.net/


On Thu, Jan 16, 2014 at 8:01 AM, Morten Olav Hansen <mortenoh@xxxxxxxxx>wrote:

> You can unzip the file with gunzip dhis2.sql.gz, and then import with psql
> -U <user> -f <filename> <dbname>
>
> --
> Morten
>
>
> On Thu, Jan 16, 2014 at 1:39 PM, Gerald Thomas <gerald.81@xxxxxxxxxxx>wrote:
>
>>  Dear when I run the backup the server came with a file which dhis2.sql.gz
>> but I  can’t import this database into another postgresql to see if this
>> file was ok. Please is there any way I can extract the file to have the
>> dhis2.sql
>> Please I need help
>>
>> 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
>>
>>
>
> _______________________________________________
> 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
>
>


-- 
Knut Staring
Dept. of Informatics, University of Oslo
+4791880522
http://dhis2.org