dhis2-devs team mailing list archive

[Bob Jolliffe <bobjolliffe@xxxxxxxxx>]

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