dhis2-devs team mailing list archive

[Knut Staring <knutst@xxxxxxxxx>]

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