dhis2-devs team mailing list archive

[Knut Staring <knutst@xxxxxxxxx>]

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