I am working on a proof of concept for a large bank in the middle-east and need some assistance because I'm stuck at an error message I cannot figure out. Please contact me on +44 78 8646 0908. Quite urgent! When creating a new Direct Connection, I fill in the Server, Port, Used ID and Password; then when I try to get the list of Databases to choose from I get an error message: "no pghba.conf entry for host "18.104.22.168", user "postgres", database "postgres", no encryption" My configuration: Public IP = 22.214.171.124 Port = 5433 (port mapped on the firewall to 5432) The line I tried to add to the pghba.conf file is:
TYPE DATABASE USER ADDRESS METHOD
IPv4 local connections:
host all postgres 126.96.36.199 password I also tried: host First postgres 188.8.131.52 password (First is the name of the Database) Can someone please help me out? Thanks!