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@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:
iokoye@wrp-n.org
www.hivresearch.org, www.wrp-n.org-----Original Message-----
From: Bob Jolliffe [mailto:bobjolliffe@gmail.com]
Sent: 19 May 2016 11:09
To: Johan Ivar Sæbø <johansa@ifi.uio.no>
Cc: Dr. Ifeanyi Okoye <iokoye@wrp-n.org>; dhis2-devs
<dhis2-devs@lists.launchpad.net>; CHIKWADO ENEJA <ceneja@modhip.gov.ng>
Subject: Re: [Dhis2-devs] Restoring backupHi 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@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-devsI leave it to someone with more expertise to help with the backup
restoration.
JohanOn 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@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