When I try to connect to one of our production postgres databases instances using 0xDBE, I get an error no pg_hba.conf entry for host "[My IP]".
I am able to connect to the instance through command line using this:
psql [database] -h [host] -p 5432 -U [username] -W
Interesting is if I don't specify -W explicitly in the command line, I am not prompted for my password and then I receive the same error on the command line:
psql: FATAL: LDAP authentication failed for user "[user]"
FATAL: no pg_hba.conf entry for host "[My IP]", user "[user]", database "[db]", SSL off
I'm not sure if this might be a dba/config issue or not. But I can't connect through 0xDBE - I just always get this no pg_hba.conf entry error even if I re-enter my credentials. Any suggestions welcome!