Re: PostgreSQL 7.3 and SuSE 8.1 problem

Hi,

On Wed, Jan 22, 2003 at 05:42:55PM +0200, Andrei Verovski wrote:
> PostgreSQL server (which is launched via "rcpostgesql start") refuses
> connections from localhost (to any database), whenever I am trying to
> connect with phpPgAdmin or pgaccess with message "blah blah blah...
> refused connection" as user "postgres" and no password (or password of
> UNIX user "postgres").
>
> However, I can connect with psql command-line utility as user
> "postgres", AND with Webmin (without any additional logon parameters
> except root/password at the beginning). This is quite strange.
>
> I have checked PostgreSQL config files (hba.conf), and enabled all
> connections from localhost and local network (192.168.*.*) with "trust"
> parameter.
localhost is on the 127.0.0.0/8 network.

> Also, I have changed password for UNIX user "postgres" as "abc", but
> anyway, it did not worked from PHP and pgaccess.
The unix password has no connction to the postgres password.

Hope this helps,
-tb
--
Thomas Beutin tb(at)laokoon(dot)IN-Berlin(dot)DE
Beam me up, Scotty. There is no intelligent live down in Redmond.