no connection to postgres

Roger Grosswiler roger at gwch.net
Thu Feb 10 15:03:19 UTC 2005


hi,

tried to connect to a postgres-database, and got the following:

[roger at 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






More information about the fedora-list mailing list