I'm running postgres 9.4 on Ubuntu server 14 which is running on virtualbox. After a reboot no remote connections would work to postgres.
I have other services on server that still take remote connections (Rstudio server, Shiny server, SSH) and that machine can still connect to the internet, and to samba shares.
Here's my pg_hba.conf
local all postgres peer host all scraper localhost trust local all all peer host all all 127.0.0.1/32 md5 host all all ::1/128 md5 hostssl all all 0.0.0.0/0 md5
In trying to connect with pgadmin from another machine, I get this message
An error has occurred: 03:23:06 PM: Error: Error connecting to the server. FATAL: password authentication failed for user "postgres"
It fails if I use
psql, or windows odbc connections so it doesn't appear to have anything to do with pgadmin
If I ssh in then I can run psql locally...
If I run
\du I find that all users show
Password valid until infinity
I forgot to say that I am indeed using the correct password. I can be sure I'm using the right password because I when I was in
psql I reset the password of the users in question using
ALTER USER user WITH PASSWORD 'MYPASSWORD';