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 users
mailing list