dhis2-devs team mailing list archive

[Morten Olav Hansen <mortenoh@xxxxxxxxx>]

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