Re: [Dhis2-devs] [SUSPECTED SPAM] RE: Restoring backup

2016-05-19 Thread Chisom
Thanks Bob. Am currently out of the office. I will do this as soon as am back there today. -- Original message-- From: Bob Jolliffe Date: Thu, 19 May 2016 15:42 To: Chisom; Cc: cen...@modhip.gov.ng;iok...@wrp-n.org;joha...@ifi.uio.no;dhis2-devs@lists.launchpad.net; Subject:Re:

Re: [Dhis2-devs] [SUSPECTED SPAM] RE: Restoring backup

2016-05-19 Thread Bob Jolliffe
OK you can see the contents of the file so we know it is a plain text dump. Assuming the file is called dbdump.sql and your database is called dhis, then try the following from the commandline and report back what you get: sudo -u postgres psql -d dhis -f dbdump.sql (you might need to change

Re: [Dhis2-devs] [SUSPECTED SPAM] RE: Restoring backup

2016-05-19 Thread Chisom
Dear Bob, Yes I can see the contents of the file. The machine runs trusty and DHIS2 is setup. And yes, am part of a team of three responsible for maintaining the server. Sadly, I have never had to do this kind of db restore before and neither has any member of the team. Any help would be

Re: [Dhis2-devs] [SUSPECTED SPAM] RE: Restoring backup

2016-05-19 Thread Knut Staring
> > *From: *Knut Staring > > *Date: *Thu, 19 May 2016 15:20 > > *To: *Chisom; > > *Cc: *bobjolli...@gmail.com;CHIKWADO ENEJA;iok...@wrp-n.org; > dhis2-devs@lists.launchpad.net; > > *Subject:*Re: [Dhis2-devs] [SUSPECTED SPAM] RE: Restoring backup > > > I

Re: [Dhis2-devs] [SUSPECTED SPAM] RE: Restoring backup

2016-05-19 Thread Bob Jolliffe
Hi Eneja It is indeed possible to connect to postgres on the ubuntu server from pgadmin on windows, but it requires changing a configuration setting on postgres. By default it won't listen to network connections for security reasons. In general I would leave that setting alone unless you know

Re: [Dhis2-devs] [SUSPECTED SPAM] RE: Restoring backup

2016-05-19 Thread Knut Staring
> > > > -- Original message-- > > *From: *Knut Staring > > *Date: *Thu, 19 May 2016 15:08 > > *To: *Chisom; > > *Cc: *bobjolli...@gmail.com;CHIKWADO ENEJA;iok...@wrp-n.org; > dhis2-devs@lists.launchpad.net; > > *Subject:*Re: [Dhis2-devs] [SUSPECTED

Re: [Dhis2-devs] [SUSPECTED SPAM] RE: Restoring backup

2016-05-19 Thread Chisom
@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 On Thu, May 19, 2016 at 1:52 PM, Chisom <enejachikw...@gmail.com> wrote: Thanks Bob. I'v

Re: [Dhis2-devs] [SUSPECTED SPAM] RE: Restoring backup

2016-05-19 Thread Knut Staring
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 wrote: > Thanks Bob. > > > > I've done that at the postgres# prompt and there's simply no feedback. I > am

Re: [Dhis2-devs] [SUSPECTED SPAM] RE: Restoring backup

2016-05-19 Thread Chisom
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

Re: [Dhis2-devs] [SUSPECTED SPAM] RE: Restoring backup

2016-05-19 Thread Bob Jolliffe
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