← Back to team overview

dhis2-devs team mailing list archive

Re: [SUSPECTED SPAM] RE: Restoring backup

 

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

Follow ups