Easier if he rather uses pg_dump directly, I think. Knut On 19 May 2016 14:46, "CHIKWADO ENEJA" <[email protected]> wrote:
> Yes. Someone (Ifeanyi) made a dump from a Windows setup of DHIS using > pgAdmin. He sent it via email and now I have to restore it to an Ubuntu > setup. > > > > Sorry if this wasn't clear. > > > > C Eneja > > Lieutenant > > IT Officer > > MOD HIP > > 4B Ikole Street > > Area 11 Garki > > Abuja > > Nigeria > > > > > > ------ Original message------ > > *From: *Knut Staring > > *Date: *Thu, 19 May 2016 15:20 > > *To: *Chisom; > > *Cc: *[email protected];CHIKWADO ENEJA;[email protected]; > [email protected]; > > *Subject:*Re: [Dhis2-devs] [SUSPECTED SPAM] RE: Restoring backup > > > I thought you said you want to restore FROM Windows TO Ubuntu? > > On Thu, May 19, 2016 at 2:17 PM, Chisom <[email protected]> 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: *[email protected];CHIKWADO ENEJA;[email protected]; >> [email protected]; >> >> *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 <[email protected]> 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: *[email protected];[email protected];[email protected] >>> ; >>> >>> *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 <[email protected]> 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: >>> > [email protected] >>> > www.hivresearch.org, www.wrp-n.org >>> > >>> > >>> > -----Original Message----- >>> > From: Bob Jolliffe [mailto:[email protected] >>> <[email protected]>] >>> > Sent: 19 May 2016 11:09 >>> > To: Johan Ivar Sæbø <[email protected]> >>> > Cc: Dr. Ifeanyi Okoye <[email protected]>; dhis2-devs >>> > <[email protected]>; CHIKWADO ENEJA <[email protected] >>> > >>> > 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ø <[email protected]> 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: >>> >>> [email protected] >>> >>> www.hivresearch.org, www.wrp-n.org >>> >>> >>> >> >>> >> >>> >> >>> >> _______________________________________________ >>> >> Mailing list: https://launchpad.net/~dhis2-devs >>> >> Post to : [email protected] >>> >> Unsubscribe : https://launchpad.net/~dhis2-devs >>> >> More help : https://help.launchpad.net/ListHelp >>> > >>> >>> _______________________________________________ >>> Mailing list: https://launchpad.net/~dhis2-devs >>> Post to : [email protected] >>> 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 : [email protected] Unsubscribe : https://launchpad.net/~dhis2-devs More help : https://help.launchpad.net/ListHelp
