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...@hotmail.com>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 <d...@dancocos.com> > *Sent:* Wednesday, January 15, 2014 7:59 PM > > *To:* Gerald Thomas <gerald...@hotmail.com> > *Cc:* jason.p.picker...@gmail.com, dhis2-devs@lists.launchpad.net > > 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...@hotmail.com>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.picker...@gmail.com >> *Sent:* Wednesday, January 15, 2014 3:28 PM >> >> *To:* Gerald Thomas <gerald...@hotmail.com> >> *Cc:* Morten Olav Hansen <morte...@gmail.com>, Olav Poppe<olav.po...@me.com>, >> dhis2-devs@lists.launchpad.net >> >> 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...@hotmail.com>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...@hotmail.com> >>> *Sent:* Tuesday, January 14, 2014 9:36 PM >>> *To:* Morten Olav Hansen <morte...@gmail.com>, Olav Poppe<olav.po...@me.com> >>> *Cc:* dhis2-devs@lists.launchpad.net >>> >>> 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 <morte...@gmail.com> >>> *Sent:* Tuesday, January 14, 2014 9:13 PM >>> *To:* Olav Poppe <olav.po...@me.com> >>> *Cc:* Gerald Thomas <gerald...@hotmail.com>, >>> dhis2-devs@lists.launchpad.net >>> >>> 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.po...@me.com> wrote: >>> >>>> Hi, have you run the analytics update? >>>> >>>> Den 14. jan. 2014 kl. 17:27 skrev Gerald Thomas <gerald...@hotmail.com >>>> >: >>>> >>>> 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@lists.launchpad.net >>>> Unsubscribe : https://launchpad.net/~dhis2-devs >>>> More help : https://help.launchpad.net/ListHelp >>>> >>>> >>>> _______________________________________________ >>>> Mailing list: https://launchpad.net/~dhis2-devs >>>> Post to : dhis2-devs@lists.launchpad.net >>>> Unsubscribe : https://launchpad.net/~dhis2-devs >>>> More help : https://help.launchpad.net/ListHelp >>>> >>>> >>> >>> _______________________________________________ >>> Mailing list: https://launchpad.net/~dhis2-devs >>> Post to : dhis2-devs@lists.launchpad.net >>> Unsubscribe : https://launchpad.net/~dhis2-devs >>> More help : https://help.launchpad.net/ListHelp >>> >>> >> >> _______________________________________________ >> Mailing list: https://launchpad.net/~dhis2-devs >> Post to : dhis2-devs@lists.launchpad.net >> Unsubscribe : https://launchpad.net/~dhis2-devs >> More help : https://help.launchpad.net/ListHelp >> >> > > _______________________________________________ > Mailing list: https://launchpad.net/~dhis2-devs > Post to : dhis2-devs@lists.launchpad.net > Unsubscribe : https://launchpad.net/~dhis2-devs > More help : https://help.launchpad.net/ListHelp > >
_______________________________________________ Mailing list: https://launchpad.net/~dhis2-devs Post to : dhis2-devs@lists.launchpad.net Unsubscribe : https://launchpad.net/~dhis2-devs More help : https://help.launchpad.net/ListHelp