The command line you've described didn't work ...
I've included the option "-i" in the /etc/sysconfig/postgresql file:
and restarted the server using SuSE scripts and it worked out perfectly.
Thanks and regards
On Tue, 2002-09-10 at 16:51, Josh Berkus wrote:
> > I'm using pg 7.2 in s SuSE 8.0 box.
> > I have no problem loging from the command line with
> > psql -U ernesto -d docmgr
> > but I'm unable to login from pgaccess or TOra. It gives an error of
> > connection refused and asks if the server is running on localhost and
> > port 5432.
> How did you start PostgreSQL? If you started it without the " -i"
> option, you will not be able to connect any way other than the command
> line on the local machine. This sounds like your problem.
> Be warned that SuSE's postgresql startup scripts are unreliable. I
> keep meaning to pester the folks in Germany about this, but am rather
> busy ...
> Start PostgreSQL with:
> postgres(at)localhost > pg_ctl -o "-i" -l /log/file/name -D
> /pgsql/data/directory start
> -Josh Berkus
> ---------------------------(end of broadcast)---------------------------
> TIP 5: Have you checked our extensive FAQ?
In response to
pgsql-novice by date
|Next:||From: Terry Yapt||Date: 2002-09-10 17:58:22|
|Subject: Re: pl/pgsql and returns timestamp type|
|Previous:||From: Josh Berkus||Date: 2002-09-10 15:51:29|
|Subject: Re: login problem|