My Postgres installation won't allow me to connect remotely. I set the listen_addresses field in the postgresql.conf to '*' and added the line
host all all 0.0.0.0/0 md5
to pg_hba.conf, restarted the database and tried
psql dbname uname -h 127.0.0.1
I always get
Password authentication failed for user "uname"
(also when just setting
host all all 127.0.0.1/32 md5
in hba or testing from a remote host).
I can't find any more configurations or suggestions to fix this. I'm running PostgreSQL 9.4 on Ubuntu 15.04 (installed from the repository). Has anyone a suggestion on what to try next? Or am I missing something?
Password authentication failed for user "uname"
pgsql dbname uname
on the houst where postgres runs), I have the according rule in pg_hba.conflocal all all md5