No pg_hba.conf entry

  • 60Views
  • Last Post 22 November 2022
Alfredo Bianco posted this 21 November 2022

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 22 November 2022



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.