Easier if he rather uses pg_dump directly, I think.
Knut
···
On Thu, May 19, 2016 at 2:17 PM, Chisom
enejachikwado@gmail.com 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@gmail.com;CHIKWADO ENEJA;iokoye@wrp-n.org;dhis2-devs@lists.launchpad.net;
**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
–
Knut Staring
Dept. of Informatics, University of Oslo
Norway: +4791880522
Skype: knutstar
On Thu, May 19, 2016 at 1:52 PM, Chisom enejachikwado@gmail.com 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@wrp-n.org;johansa@ifi.uio.no;dhis2-devs@lists.launchpad.net;
**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@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:
-----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 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@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:
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:
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
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
–
Knut Staring
Dept. of Informatics, University of Oslo
Norway: +4791880522
Skype: knutstar