Restoring backup

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@wrp-n.org
www.hivresearch.org, www.wrp-n.org

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:
DHIS 2 developers in Launchpad

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@wrp-n.org
www.hivresearch.org, www.wrp-n.org

_______________________________________________
Mailing list: DHIS 2 developers in Launchpad
Post to : dhis2-devs@lists.launchpad.net
Unsubscribe : DHIS 2 developers in Launchpad
More help : ListHelp - Launchpad Help

Hello Dr. Ifeanyi

The shortest approach is to install pgAdmin in Ubuntu and use it to restore the backup. You can actually install pgAdmin or phppgadmin in Ubuntu and use one of them to create and restore backups.

Lungo

···

From: Johan Ivar Sæbø johansa@ifi.uio.no
To: Dr. Ifeanyi Okoye iokoye@wrp-n.org; dhis2-devs dhis2-devs@lists.launchpad.net
Cc: ‘CHIKWADO ENEJA’ ceneja@modhip.gov.ng
Sent: Thursday, May 19, 2016 11:52 AM
Subject: [Dhis2-devs] Restoring backup

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