dhis2-devs team mailing list archive

[Knut Staring <knutst@xxxxxxxxx>]

Easier if he rather uses pg_dump directly,  I think.

Knut
On 19 May 2016 14:46, "CHIKWADO ENEJA" <ceneja@xxxxxxxxxxxxx> 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: *bobjolliffe@xxxxxxxxx;CHIKWADO ENEJA;iokoye@xxxxxxxxx;
> dhis2-devs@xxxxxxxxxxxxxxxxxxx;
>
> *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 <enejachikwado@xxxxxxxxx> 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: *bobjolliffe@xxxxxxxxx;CHIKWADO ENEJA;iokoye@xxxxxxxxx;
>> dhis2-devs@xxxxxxxxxxxxxxxxxxx;
>>
>> *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  <enejachikwado@xxxxxxxxx> 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: *iokoye@xxxxxxxxx;johansa@xxxxxxxxxx;dhis2-devs@xxxxxxxxxxxxxxxxxxx
>>> ;
>>>
>>> *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 <ceneja@xxxxxxxxxxxxx> 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:
>>> > iokoye@xxxxxxxxx
>>> > www.hivresearch.org, www.wrp-n.org
>>> >
>>> >
>>> > -----Original Message-----
>>> > From: Bob Jolliffe [mailto:bobjolliffe@xxxxxxxxx
>>> <bobjolliffe@xxxxxxxxx>]
>>> > Sent: 19 May 2016 11:09
>>> > To: Johan Ivar Sæbø <johansa@xxxxxxxxxx>
>>> > Cc: Dr. Ifeanyi Okoye <iokoye@xxxxxxxxx>; dhis2-devs
>>> > <dhis2-devs@xxxxxxxxxxxxxxxxxxx>; CHIKWADO ENEJA <ceneja@xxxxxxxxxxxxx
>>> >
>>> > 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ø <johansa@xxxxxxxxxx> 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:
>>> >>> iokoye@xxxxxxxxx
>>> >>> www.hivresearch.org, www.wrp-n.org
>>> >>>
>>> >>
>>> >>
>>> >>
>>> >> _______________________________________________
>>> >> 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
>>>
>>>
>>
>>
>> --
>> 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
>