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?
Best Answer
Okay ... Upon installation of postgres another service was using the port 5432 so postgres took 5434. I didn't notice. Works now