Hi
The command line you've described didn't work ...
I've included the option "-i" in the /etc/sysconfig/postgresql file:
POSTGRES_OPTIONS="-i"
and restarted the server using SuSE scripts and it worked out perfectly.
Thanks and regards
EJ
On Tue, 2002-09-10 at 16:51, Josh Berkus wrote:
> Ernesto,
>
> > 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@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?
>
> http://www.postgresql.org/users-lounge/docs/faq.html