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