hi,
tried to connect to a postgres-database, and got the following:
[roger@frodo]$ psql -U roger -h localhost Passwort: psql: FATAL: »Password«-authentication for user roger not successful.
i did initdb as postgres again, installed as postgres a new user called roger with a password (createuser -W), worked fine.
in postgresql.conf, i set tcpip_socket = true
my pg_hba.conf looks like this: host all all 127.0.0.1 255.255.255.255 password host all all 192.168.2.0 255.255.255.0 password host all all 192.168.3.0 255.255.255.0 password #local all all ident sameuser
HELP :-) Thank you very much (btw. same config is running on a fc2-server, log says nothing at all, was thinking at selinux perhaps, but it doesnt seem...)
Roger