No pg_hba.conf entry

  • 14Views
  • Last Post 3 weeks ago
Alfredo Bianco posted this 3 weeks ago

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 "", user "postgres", database "postgres", no encryption" My configuration: Public IP = 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         password I also tried: host    First         postgres         password (First is the name of the Database) Can someone please help me out? Thanks!

Mariia Zaharova posted this 3 weeks ago



Thank you for contacting Skyvia Support.


Please be informed that we have replied to you by email.


Should you have other questions, don't hesitate to reach out.