Recently, I connected to a PostgreSQL webhosting service to which I didn't have full access, I was using no specific database or 'postgres', but this failed with a 'no access' error. By entering a database name, it succeeded.
Now I want to connect to AmazonAWS, but it fails with a similar message:
I have entered host, database, user and password, the connection fails.no pg_hba.conf entry for host "xx", user "xx", database "x(removed)x", SSL off.
However, when I use the PostgreSQL Maestro tool using the same credentials, it works!
Do you have any idea how and why?