I thought you said you want to restore FROM Windows TO Ubuntu? On Thu, May 19, 2016 at 2:17 PM, Chisom <enejachikw...@gmail.com> wrote:
> Dear Bob, > > > > The server is Ubuntu. No GUI. I thought I could connect to the server with > pgAdmin on Windows to make the dump. > > > > ------ Original message------ > > *From: *Knut Staring > > *Date: *Thu, 19 May 2016 15:08 > > *To: *Chisom; > > *Cc: *bobjolli...@gmail.com;CHIKWADO ENEJA;iok...@wrp-n.org; > dhis2-devs@lists.launchpad.net; > > *Subject:*Re: [Dhis2-devs] [SUSPECTED SPAM] RE: Restoring backup > Hi Eneja, > > I would suggest you rather do the dump directly on the Command line in > Windows, instead of using pgAdmin. > > Knut > > On Thu, May 19, 2016 at 1:52 PM, Chisom <enejachikw...@gmail.com> wrote: > >> Thanks Bob. >> >> >> >> I've done that at the postgres# prompt and there's simply no feedback. I >> am contemplating installing pgAdmin on the server then attempt to connect >> to it from a Windows pc. Do you think this is a good way to proceed? >> >> >> >> Regards, >> >> Eneja. >> >> >> >> ------ Original message------ >> >> *From: *Bob Jolliffe >> >> *Date: *Thu, 19 May 2016 14:37 >> >> *To: *CHIKWADO ENEJA; >> >> *Cc: *iok...@wrp-n.org;joha...@ifi.uio.no;dhis2-devs@lists.launchpad.net; >> >> *Subject:*Re: [SUSPECTED SPAM] RE: [Dhis2-devs] Restoring backup >> Hi Eneja >> >> Please see my earlier request for more exact information. It sounds >> to me that your pgAdmin dump is not in plain text format. In which >> case you would have to use pg_restore rather than psql to restore it. >> But you can easily verify by just looking inside the file to see if it >> is a text file - eg using less as I indicated. >> >> Regards >> Bob >> >> On 19 May 2016 at 13:23, CHIKWADO ENEJA <cen...@modhip.gov.ng> wrote: >> > Dear Bob, >> > >> > >> > >> > The backup made has been copied into a folder in the server. The >> challenge I >> > have had is to restore that file into an existing database. >> > >> > >> > >> > Regards. >> > >> > >> > >> > C Eneja >> > >> > >> > >> > ------ Original message------ >> > >> > From: Dr. Ifeanyi Okoye >> > >> > Date: Thu, 19 May 2016 13:55 >> > >> > To: 'Bob Jolliffe';'Johan Ivar Sæbø'; >> > >> > Cc: 'dhis2-devs';CHIKWADO ENEJA; >> > >> > Subject:[SUSPECTED SPAM] RE: [Dhis2-devs] Restoring backup >> > >> > >> > >> > Hello Bob, >> > I created the backup file using pgAdmin for Windows. I use PG9.4 with >> DHIS >> > Live on my laptop. >> > I created it as a plain backup. Size is 3MB. >> > >> > We are now trying to restore the file to an Ubuntu server also running >> PG9.4 >> > and having some difficulty reading in the file. >> > >> > Lt. Eneja, please could you give Bob some more details as requested? >> > >> > Thank you. >> > >> > Ifeanyi Okoye MB;BS, M.Inf.Sc | Strategic Information Manager >> > Strategic Information Unit, US Department of Defense-Walter Reed Program >> > Nigeria >> > Embassy of the United States of America, Plot 1075 Diplomatic Drive, >> CBD, >> > Abuja, Nigeria >> > Work: +234-9-461-4000 Ext 4560 | Mobile: +234-805-519-2251 | Email: >> > iok...@wrp-n.org >> > www.hivresearch.org, www.wrp-n.org >> > >> > >> > -----Original Message----- >> > From: Bob Jolliffe [mailto:bobjolli...@gmail.com >> <bobjolli...@gmail.com>] >> > Sent: 19 May 2016 11:09 >> > To: Johan Ivar Sæbø <joha...@ifi.uio.no> >> > Cc: Dr. Ifeanyi Okoye <iok...@wrp-n.org>; dhis2-devs >> > <dhis2-devs@lists.launchpad.net>; CHIKWADO ENEJA <cen...@modhip.gov.ng> >> > Subject: Re: [Dhis2-devs] Restoring backup >> > >> > Hi Ifeany >> > >> > Can you give exact psql command you are using and the output? >> > >> > If it is a plain text format you should be able to see the sql commands >> in >> > it by running a command like 'less backup.sql' (assuming that is the >> name of >> > your file). That is always good to verify that what you have is indeed >> a >> > plain (and uncorrupted) file. >> > >> > Bob >> > >> > >> > >> > On 19 May 2016 at 09:52, Johan Ivar Sæbø <joha...@ifi.uio.no> wrote: >> >> Hi Ifeany, >> >> >> >> I forward this to the developer list, which is a good place to direct >> >> such issues. You should create an account and join the list here: >> >> https://launchpad.net/~dhis2-devs >> >> >> >> I leave it to someone with more expertise to help with the backup >> >> restoration. >> >> Johan >> >> >> >> On 18.05.2016 19:57, Dr. Ifeanyi Okoye wrote: >> >>> >> >>> Hello Johan, >> >>> I hope you are doing well. >> >>> >> >>> I need some technical help with DHIS2 and looking for someone to talk >> to. >> >>> >> >>> I created a db backup file in plain format using pgAdmin for Windows >> >>> (PostgreSQL 9.4). I am trying to restore the backup file to a Postgre >> >>> db in Ubuntu with psql but it is just not working. Says it cannot read >> >>> file. >> >>> >> >>> Who can I talk to to help with this. Been driving us nuts all day. >> >>> >> >>> My colleague can give some more insight into this. >> >>> >> >>> Looking forward to hearing from you. >> >>> >> >>> Ifeanyi Okoye MB;BS, M.Inf.Sc | Strategic Information Manager >> >>> Strategic Information Unit, US Department of Defense-Walter Reed >> >>> Program Nigeria Embassy of the United States of America, Plot 1075 >> >>> Diplomatic Drive, CBD, Abuja, Nigeria >> >>> Work: +234-9-461-4000 Ext 4560 | Mobile: +234-805-519-2251 | Email: >> >>> iok...@wrp-n.org >> >>> www.hivresearch.org, www.wrp-n.org >> >>> >> >> >> >> >> >> >> >> _______________________________________________ >> >> 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 >> >> > > > -- > Knut Staring > Dept. of Informatics, University of Oslo > Norway: +4791880522 > Skype: knutstar > http://dhis2.org > -- Knut Staring Dept. of Informatics, University of Oslo Norway: +4791880522 Skype: knutstar http://dhis2.org
_______________________________________________ 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