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:
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
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
>
> *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
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
>
>
>
> -- 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
@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
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
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
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
10 matches
Mail list logo